<?php 
$page='model';
$page1='services';
include('inc/sidebar.php') ;
if(isset($_GET['del'])){
    $id = $_GET['del'];
    $del = mysqli_query($con,"delete from model where id = '$id'");
    if($del){
        echo "<script type='text/javascript'>window.location=\"model.php\";</script>"; 
    }
}
if(isset($_GET['act'])){ 
    $id = $_GET['act'];
    $act = mysqli_query($con,"UPDATE `model` SET `status` = '0' where id = '$id'");
    if($act){
    echo'<div id="hide-toast"class="toast" role="alert" aria-live="assertive" aria-atomic="true">
        <div class="toast-body alert">
            <i class="fa fa-warning"></i> DeActivated.<i class="fa fa-close"id="close"></i>
        </div>
    </div>';
    echo "<script type='text/javascript'>window.location=\"model.php\";</script>";
    
    }
}
if(isset($_GET['ina'])){
    $id = $_GET['ina'];
    $ina = mysqli_query($con,"UPDATE `model` SET `status` = '1' where id = '$id'");
    if($ina){
    echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
        <div class="toast-body success">
            <i class="fa fa-warning"></i> Activated.<i class="fa fa-close"id="close"></i>
        </div>
    </div>';
    echo "<script type='text/javascript'>window.location=\"model.php\";</script>";
    }
}
if(isset($_REQUEST['datafrmSubmit'])){
    if($_REQUEST['datafrmSubmit'] == 'Submit'){
    	date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
    		$sql_insert = "insert into model set brand_id = '".$_REQUEST['brand_id']."', model = '".str_replace("'", "\'", $_REQUEST['model'])."',date = '".date("Y-m-d h:i:s")."', status = '1'";
    		$query_insert = mysqli_query($con, $sql_insert);
    		 if($query_insert){
            echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
          <div class="toast-body success">
                <i class="fa fa-warning"></i> Added.<i class="fa fa-close"id="close"></i>
          </div>
        </div>';
      	echo "<script type='text/javascript'>window.location=\"model.php\";</script>";
    		 }
    }
    if($_REQUEST['datafrmSubmit'] == 'Update'){
    	date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
    		$sql_insert = "UPDATE model set brand_id = '".$_REQUEST['brand_id']."', model = '".str_replace("'", "\'", $_REQUEST['model'])."' WHERE id='".$_REQUEST['id']."'";
    		$query_insert = mysqli_query($con, $sql_insert);
    		 if($query_insert){
            echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
          <div class="toast-body success">
                <i class="fa fa-warning"></i> Added.<i class="fa fa-close"id="close"></i>
          </div>
        </div>';
      	echo "<script type='text/javascript'>window.location=\"model.php\";</script>";
    		 }
    }
}
    
?>
<?php
 if(isset($_POST["Import"])){
    $brand=$_POST["brand_id"];
    $filename=$_FILES["file"]["tmp_name"];    
     if($_FILES["file"]["size"] > 0){
        $count = 0;
        $file = fopen($filename, "r");
          while (($getData = fgetcsv($file, 10000, ",")) !== FALSE){ 
            $count++;
            if ($count!=1) {
                $sql = "INSERT into model (brand_id,model,date,status) values ('".$brand."','".$getData[0]."','".date("Y-m-d h:i:s")."','".$getData[1]."')";
                $result = mysqli_query($con, $sql);
                if(!isset($result)){
                  echo "<script type=\"text/javascript\">
                      alert(\"Invalid File:Please Upload CSV File.\");
                      window.location = \"model.php\"
                      </script>";    
                }else {
                    echo "<script type=\"text/javascript\">
                    alert(\"CSV File has been successfully Imported.\");
                    window.location = \"model.php\"
                  </script>";
                }
            }
        
        }
      
        fclose($file);  
     }
  }   
 ?>

<!-- navbar-wrapper start -->
  <div class="body-wrapper">
    <div class="bodywrapper__inner">
        <div class="row align-items-center mb-30 justify-content-between">
            <div class="col-lg-4 col-sm-6">
                <h6 class="page-title">All Mobile Models</h6>
            </div>
            <div class="col-lg-8 col-sm-6 text-sm-right mt-sm-0 mt-3 right-part">
                <div class="d-flex flex-wrap justify-content-end flex-gap-8">
                    <button type="button" class="btn btn--primary exampleModal" data-modal_title="Add Model"data-toggle="modal" data-target="#exampleModal"style="height: 38px;"><i class="fa fa-plus"></i>Add New</button>
                    <button type="button" class="btn btn--primary csvModal" data-modal_title="Import Brands"data-toggle="modal" data-target="#csvModal"style="height: 38px;"><i class="fa fa-plus"></i>Import</button>
                    
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-body p-0">
                        <div class="table-responsive--md table-responsive">
                            <table id="example"class="table table--light style--two table-striped">
                                <thead>
                                    <tr>
                                        <th><input type="checkbox" id="select_all"></th>
                                        <th>SL</th>
                                        <th>Mobile Brand Name</th>
                                        <th>Mobile Model Name</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php	
                                	$sql= "SELECT * FROM model ORDER BY id DESC";
                                	$qry= mysqli_query($con,$sql);
                                	$i=0;
                                	while($data= mysqli_fetch_array($qry))
                                	{ $i++; 
                                  ?>
                                    <tr id="<?php echo $data["id"]; ?>">
                                        <td><input type="checkbox" class="emp_checkbox" data-emp-id="<?php echo $data["id"]; ?>"></td>
                                        <td data-label="SL"><?php echo $i; ?></td>
                                        <td>
                                        <?php	
                                        	$brand_data1= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM brand WHERE id='".$data['brand_id']."'"));
                                            echo $brand_data1['brand'];
                                        ?>
                                        </td>
                                        <td data-label="Name"><?php echo $data['model']; ?></td>
                                        
                                        <td data-label="Action">
                                            <?php if($data['status']==1){ ?>
                                            <button onclick="location.reload();location.href='model.php?act=<?php echo $data['id'];?>'" type="button" class="icon-btn btn-success">ACTIVE</button>
                                            <?php }else{?>
                                            <button onclick="location.reload();location.href='model.php?ina=<?php echo $data['id'];?>'" type="button" class="icon-btn btn-danger">DEACTIVE</button>
                                            <?php } ?>
                                            <button  class="icon-btn edit"  id="<?php echo $data['id'];?>" >EDIT</button>
                                            <a href="model.php?del=<?php echo $data['id'];?>" onclick="return confirm('Are you sure you want to delete this?');"type="button" class="icon-btn btn-danger">DELETE</a>
                                        </td>
                                    </tr>
                                    <?php } ?>
                                </tbody>
                            </table>
                           <div class="well"style="padding: 10px;">
                    			<span class="rows_selected" id="select_count">0 Selected</span>
                    			<a type="button" id="delete_records" class="icon-btn btn-danger text-white">Delete</a>
                    		</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
            <div class="modal-dialog" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Add Mobile Model</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div id="ShowData">
                        <form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
                            <input type="hidden" name="id"id="id" value="" />
                            
                            <div class="modal-body">
                                <div class="form-group">
                                    <label>Select Brand</label>
                                    <select  class="form-control"  name="brand_id"  required="" >
                                        <option value="">Select Brand</option>
                                        <?php	
                                        	$sql_brand= mysqli_query($con,"SELECT * FROM brand WHERE status=1 ORDER BY id DESC");
                                        	while($brand_data= mysqli_fetch_array($sql_brand))
                                        	{
                                        ?>
                                        <option value="<?php echo $brand_data['id'] ?>"><?php echo $brand_data['brand'] ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                                <div class="form-group">
                                    <label class="form-control-label font-weight-bold">Mobile Model Name <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control" placeholder="" value=""id="model" name="model" required="" />
                                </div>
                                <div class="status"></div>
                            </div>
                            <div class="modal-footer">
                                <input type="submit" name="datafrmSubmit" id="datafrmSubmit"value="Submit"class="btn btn--primary w-100">
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div> 
        <div class="modal fade" id="csvModal" tabindex="-1" role="dialog" aria-labelledby="csvModalLabel" aria-hidden="true">
            <div class="modal-dialog" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Import Model</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                   <form class="form-horizontal" action="" method="post" name="upload_excel" enctype="multipart/form-data">
                        
                        <div class="modal-body">
                            <div class="form-group">
                                <label>Select Brand</label>
                                <select  class="form-control"  name="brand_id"  required="" >
                                    <option value="">Select Brand</option>
                                    <?php	
                                    	$sql_brand= mysqli_query($con,"SELECT * FROM brand WHERE status=1 ORDER BY id DESC");
                                    	while($brand_data= mysqli_fetch_array($sql_brand))
                                    	{
                                    ?>
                                    <option value="<?php echo $brand_data['id'] ?>"><?php echo $brand_data['brand'] ?></option>
                                    <?php } ?>
                                </select>
                            </div>
                            <div class="form-group">
                                <label class="form-control-label font-weight-bold">Select CSV File<span class="text-danger">*</span></label>
                                <input type="file" name="file" id="file" class="input-large" accept=".csv"required style="width:100%;padding: 6px;border: 1px solid #80808075;">
                                <small class="mt-10">Download Sample File<a href="export/model-sample.csv" download="model-sample.csv"> <i class="fa fa-download" aria-hidden="true"></i> <small>DOWNLOAD</small></a> </small>
                            </div>
                            <div class="status"></div>
                        </div>
                        <div class="modal-footer">
                            <button type="submit" id="submit" name="Import" class="btn btn--primary button-loading" data-loading-text="Loading...">Import</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <!-- bodywrapper__inner end -->
</div>
<!-- body-wrapper end -->

    </div>
 
 <!-- body-wrapper end -->
    </div>

<!-- jQuery library -->

<script>  
 $(document).ready(function() {
    $(document).on('click', '.edit', function() {
        var id = $(this).attr("id");
        if (id != '') {
            $.ajax({
                url: "inc/model.php",
                method: "POST",
                data: {
                    id: id,type:1
                },
                success: function(data) {
                    $('#ShowData').html(data);
                    $('#exampleModalLabel').html('Update model');
                    $('#exampleModal').modal('show');
                }
            });
        }
    });
});
 </script>
 <script>
     // delete selected records
$('#delete_records').on('click', function(e) { 
	var employee = [];  
	$(".emp_checkbox:checked").each(function() {  
		employee.push($(this).data('emp-id'));
	});	
	if(employee.length <=0)  {  
		alert("Please select records.");  
	}  
	else { 	
		WRN_PROFILE_DELETE = "Are you sure you want to delete "+(employee.length>1?"these":"this")+" row?";  
		var checked = confirm(WRN_PROFILE_DELETE);  
		if(checked == true) {			
			var selected_values = employee.join(","); 
			$.ajax({ 
				type: "POST",  
				url: "inc/delete_brand.php",  
				cache:false,  
				data: 'model='+selected_values,  
				success: function(dataResult){
                var dataResult = JSON.parse(dataResult);
                  if(dataResult.statusCode==200){
                      localStorage.setItem('Status','success')
                      localStorage.setItem('Message', 'Selected Data Deleted');
                      location.reload();	
                      	
                  }
                  else if(dataResult.statusCode==201){
                      iziToast.error({
                        position: 'topRight',
                        title: 'Error',
                        message: 'Network Problem!',
                    });
                  }
              }  
			});				
		}  
	}  
});
$(document).ready(function(){
  //get it if Status key found
  if(localStorage.getItem("Status"))
  {
    var status = localStorage.getItem('Status');
    var message = localStorage.getItem('Message');
    notify(status,message);
      localStorage.clear();
  }
});
 </script>
<?php include('inc/footer.php') ?>