<?php 
$page='services1';
$page1='services';

include('inc/sidebar.php') ;
if(isset($_GET['id'])){
   
    $get_service= "select * from service WHERE id='".$_GET['id']."'";
    $query=mysqli_query($con,$get_service);
    $service_data=mysqli_fetch_array($query); 
    
}
if(isset($_REQUEST['datafrmSubmit'])){
    if($_REQUEST['datafrmSubmit'] == 'Submit'){
        $date=date("Y-m-d h:i:s");
        $location = 'uploads/services/';
        $service_image = $_FILES['img']['name'];
        $tmp_name = $_FILES['img']['tmp_name'];
        $upload_dir = $location.$service_image;
        if(move_uploaded_file($tmp_name, $upload_dir))
        { }
    	date_default_timezone_set("Asia/Kolkata");
        
            $sql_insert = "insert into service set image = '".$service_image."',brand_id = '".$_REQUEST['brand_id']."',model_id = '".$_REQUEST['model_id']."',price = '".$_REQUEST['price']."',service_name = '".str_replace("'", "\'", $_REQUEST['service_name'])."',date = '$date',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>Service Added.<i class="fa fa-close"id="close"></i>
                        </div>
                    </div>';
                echo "<script type='text/javascript'>window.location=\"services.php\";</script>"; 
            }
        
    }
    if($_REQUEST['datafrmSubmit'] == 'Update'){
        $dsc=$_REQUEST['dsc'];
        $location = 'uploads/services/';
        $service_image = $_FILES['img']['name'];
        $tmp_name = $_FILES['img']['tmp_name'];
        $upload_dir = $location.$service_image;
        if(move_uploaded_file($tmp_name, $upload_dir))
        { }
    	date_default_timezone_set("Asia/Kolkata"); 
        
    	if(!empty($_FILES['img']['name'])){
    		$sql_insert1 = mysqli_query($con, "UPDATE  service set image = '".$service_image."'  WHERE ID='".$_GET['id']."'");
    	}
        $sql_insert = "UPDATE  service set brand_id = '".$_REQUEST['brand_id']."',model_id = '".$_REQUEST['model_id']."',price = '".$_REQUEST['price']."',service_name = '".str_replace("'", "\'", $_REQUEST['service_name'])."' WHERE ID='".$_GET['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>Service Updated.<i class="fa fa-close"id="close"></i>
                    </div>
                </div>';
            echo "<script type='text/javascript'>window.location=\"services.php\";</script>"; 
        }   
    }
}   
?>


<!-- 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">Add Mobile Service</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">
                    <a type="button"href="services.php" class="btn btn--primary"style="height: 38px;"><i class="fa fa-plus"></i>Go Back</a>
                </div>
            </div>
        </div>
    <div class="row">
    <div class="col-md-12 mb-30">
        <div class="card">
            <div class="card-body">
                <form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
                    <input type="hidden" name="_token" value="F3hYZRLH4v3C9Ru6ljqKNSmfRwKJx6eXLvbIf74y" /> <input type="hidden" name="type" value="element" />
                    <div class="form-row">
                        <div class="col-md-4">
                            <input type="hidden" name="has_image[]" value="1" />
                            <div class="form-group">
                                <label>Cover Image</label>
                                <div class="image-upload">
                                    <div class="thumb">
                                        <div class="avatar-preview">
                                            <div class="profilePicPreview" <?php if(isset($_GET['id'])){ ?>style="background-image: url('<?php if(isset($service_data)){ echo SERVICES_SITE_PATH.$service_data['image'];} ?>');"<?php }else{ ?>style="background-image: url('images/img.jpg');"<?php } ?>>
                                                <button type="button" class="remove-image"><i class="fa fa-times"></i></button>
                                            </div>
                                        </div>
                                        <div class="avatar-edit">
                                            <input type="file" class="profilePicUpload" value=""name="img" id="profilePicUpload0" accept=".png, .jpg, .jpeg" />
                                            <label for="profilePicUpload0" class="bg--primary">Image</label>
                                            <small class="mt-2 text-facebook">
                                                Supported files: <b>jpeg, jpg, png</b>
                                            </small>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-8">
                        <div class="col-md-12">
                                <div class="form-group">
                                    <label>Select Brand</label>
                                    <select  class="form-control"  name="brand_id"id="brandID"  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 if($brand_data['id']==$service_data['brand_id']){ echo 'selected'; } ?>><?php echo $brand_data['brand'] ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-12">
                                <div class="form-group">
                                    <label>Select Model</label>
                                    <select  class="form-control"  name="model_id"id="modelID"  required="" >
                                        <option value="">Select Brand First</option>
                                        <?php	
                                        	$sql_model= mysqli_query($con,"SELECT * FROM model WHERE brand_id='".$service_data['brand_id']."' AND  status=1 ORDER BY id DESC");
                                        	while($model_data= mysqli_fetch_array($sql_model))
                                        	{
                                        ?>
                                        <option value="<?php echo $model_data['id'] ?>" <?php if($model_data['id']==$service_data['model_id']){ echo 'selected'; } ?>><?php echo $model_data['model'] ?></option>
                                        <?php } ?>
                                        
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-12">
                                <div class="form-group">
                                    <label>Service Name</label>
                                    <input type="text" class="form-control" placeholder="Service Name" name="service_name" id="service_name" value="<?php if(isset($service_data)){echo $service_data['service_name']; } ?>" required="" />
                                </div>
                            </div>
                            <div class="col-md-12">
                                <div class="form-group">
                                    <label>Price</label>
                                    <input type="number" class="form-control" placeholder="Price" name="price" id="price" value="<?php if(isset($service_data)){echo $service_data['price'];} ?>"  required=""/>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="form-group">
                        <button type="submit" name="datafrmSubmit" id="datafrmSubmit"value="<?php if(isset($_GET['id']))
                       { echo 'Update';  }else{ echo 'Submit'; } ?>"class="btn btn--primary btn-block btn-lg"><?php if(isset($_GET['id']))
                       { echo 'Update';  }else{ echo 'Submit'; } ?></button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

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

    </div>
 
 <!-- body-wrapper end -->
    </div>
    <script>
            $(document).ready(function() {
                $('#brandID').on('change', function() {
                    var brand_id = this.value;
                        $.ajax({
                            url: "inc/fetch-model.php",
                            type: "POST",
                            data: {
                                brand_id: brand_id
                            },
                            cache: false,
                            success: function(result){
                                $("#modelID").html(result);
                            }
                    });
                });
            });
        </script>
<?php include('inc/footer.php') ?>