<?php
include("topmenu.php");

?>

<div class="main_content_iner overly_inner ">
<div class="container-fluid p-0 ">

<div class="row">
<div class="col-12">
<div class="page_title_box d-flex align-items-center justify-content-between">
<div class="page_title_left">
<h3 class="f_s_30 f_w_700 text_white">Branch</h3>
<ol class="breadcrumb page_bradcam mb-0">
<li class="breadcrumb-item"><a href="javascript:void(0);">Al Barsha Electronics LLC </a></li>
<li class="breadcrumb-item"><a href="javascript:void(0);">Dashboard</a></li>
<li class="breadcrumb-item active">Branch</li>
<li class="breadcrumb-item active">Branch Services</li>
</ol>

</div>
</div>



<div class="row">
    <div class="col-lg-12">
        <div class="card">
            <div class="card-header align-items-center d-flex card-header2">
                <h4 class="card-title mb-0 flex-grow-1">Update Content</h4>
                
            </div><!-- end card header -->

            
            <div class="card-body">
                <div class="live-preview">
                <form method="post" enctype="multipart/form-data">
                    <div class="row gy-4">
                    
                        
                        <!--end col-->

                        <?php 
                        $sqp=mysqli_query($db,"select * from branch_srvc_hdng");
                        $rqp=mysqli_fetch_row($sqp);
                        ?>
        
                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Title<span class="red">*</span></label>
                                <input type="text"  class="form-control" id="exampleInputdate" name="a1" value="<?php echo $rqp[1] ?>" required>
                            </div>
                        </div>
                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Heading<span class="red">*</span></label>
                                <input type="text"  class="form-control" id="exampleInputdate" name="a2" value="<?php echo $rqp[2] ?>" required>
                            </div>
                        </div>
                        
                        <div class="mt-3">
                        <input type="submit" class="btn btn-primary"  name="sub1" value="Submit">
                        <!-- staticBackdrop Modal -->
                        </div>

                    
                </form>
                </div>
                    <!--end row-->
               </div>
            </div>
        </div>   
        
        
        
    </div>
    </div>

    <?php
    if (isset ($_POST['sub1']))
    {
        $a1=addslashes($_POST['a1']);
        $a2=addslashes($_POST['a2']);

        $res=mysqli_query($db,"UPDATE branch_srvc_hdng SET t1='$a1', h1='$a2'");

        msg("Successfully updated","branch_srvc_add.php");
    }
    if(isset($_REQUEST['deletepro_id']))
    {
        $srvcId =$_REQUEST['deletepro_id'];
        $sql_query="DELETE FROM branch_srvcs WHERE id=$srvcId";
        $s1 = mysqli_query($db,$sql_query);
        if( $s1 ){
            $s2 = mysqli_query($db, "DELETE FROM branch_srvc_ft WHERE srvc_id=$srvcId");
            if( $s2 ){
                $s3 = mysqli_query( $db, "DELETE FROM branch_srvc_ftimg WHERE srvc_id=$srvcId" );
            }
        }
        header("Location: branch_srvc_add.php");
    }

?>




 
      

<script type="text/javascript">
function deletepro_id(id)
{

     if(confirm('Sure To Remove This Details ?'))
     {
        window.location.href='branch_srvc_add.php?deletepro_id='+id;
     }
}
</script>



    <div class="row">
    <div class="col-lg-12">
        <div class="card">
            <div class="card-header align-items-center d-flex card-header2">
                <h4 class="card-title mb-0 flex-grow-1">Add service</h4>
                
            </div><!-- end card header -->

            
            <div class="card-body">
                <div class="live-preview">
                <form method="post" enctype="multipart/form-data">
                    <div class="row gy-4">
                    
                        
                        <!--end col-->
                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Select service<span class="red">*</span></label>
                                <select  class="form-control" id="exampleInputdate" name="ba" required>
                                    <option value="">Select Branch</option>

                                    <?php
                                        $sb=mysqli_query($db,"select * from branch_dtls ");
                                        while($rsb=mysqli_fetch_row($sb))
                                        {

                                    ?>
                                    <option value="<?php echo $rsb[0];?>"><?php echo $rsb[1];?></option>
                                    <?php
                                    }
                                    ?>
                                
                                </select>
                            </div>
                        </div> 



                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Service name<span class="red">*</span></label>
                                <input type="text"  class="form-control" id="exampleInputdate" name="a1" required>
                            </div>
                        </div> 
        

                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Service Image(width-556 & height-610)<span class="red">*</span></label>
                                <input type="file"  class="form-control" id="exampleInputdate" name="photo" required>
                            </div>
                        </div>
                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Heading <span class="red">*</span></label>
                                <input type="text"  class="form-control" id="exampleInputdate" name="a2" required>
                            </div>
                        </div>
                        <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Description<span class="red">*</span></label>
                                <textarea  class="form-control" id="exampleInputdate" name="a3" required></textarea>
                            </div>
                        </div> 
                        
                         <div class="col-lg-4">
                            <div>
                                <label for="labelInput" class="form-label">Banner Heading<span class="red">*</span></label>
                               <input type="text"  class="form-control" id="exampleInputdate" name="a4" required>
                            </div>
                        </div> 

                       
                    </div>
                    <div class="row gy-4">
                        

                        
                        <div class="mt-5">
                        <input type="submit" class="btn btn-primary"  name="sub2" value="Submit">
                        <!-- staticBackdrop Modal -->
                        </div>

                    
                </form>
                </div>
                    <!--end row-->
               </div>
            </div>
        </div>   
        
        
        
    </div>
    </div>

<?php
                    
if(isset($_POST['sub2']))
{
    $fileName=$_FILES['photo']['name'];

    $ba=addslashes($_POST['ba']);

    $a1=addslashes($_POST['a1']);
    $a2=addslashes($_POST['a2']);
    $a3=addslashes($_POST['a3']);
     $a4=addslashes($_POST['a4']);

    $fileTmpPath = $_FILES['photo']['tmp_name'];
       
    $fileSize = $_FILES['photo']['size'];
    $fileType = $_FILES['photo']['type'];
    $fileNameCmps = explode(".", $fileName);
    $fileExtension = strtolower(end($fileNameCmps));
    $newFileName = md5(time() . $fileName) . '.' . $fileExtension;
    
    
    $newFileName = md5(time() . $fileName) . '.' . $fileExtension;
    $allowedfileExtensions = array('jpg', 'gif', 'png','jpeg');
    if (in_array($fileExtension, $allowedfileExtensions))
    {
        $uploadFileDir = "../images/branch/srvc/"; 
        $dest_path = $uploadFileDir . $newFileName;
        //$pd=date("d/m/y");
        
        
        list($width, $height, $type, $attr) = getimagesize($fileTmpPath);
        
        
        if($width=="566" && $height=="610")
        {
            CompressImage($_FILES['photo']['tmp_name'],  $dest_path,80);

            $ins=mysqli_query($db,"insert into branch_srvcs values('0', '$ba', '$a1','$newFileName','$a2','$a3','$a4')");

            msg(" successfully added","branch_srvc_add.php");

        }else{
            msg("Image Size should be in width - 556px & height - 610px", "branch_srvc_add.php");
        }
    }else{
        msg("Image extension should be jpg or png", "branch_srvc_add.php");
    }

}


?>

<div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header card-header2">
                                    <h4 class="card-title mb-0">View data</h4>
                                </div><!-- end card header -->

                                <div class="card-body">
                                    


                                    <table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
                                    <thead>
                                        <tr>
                                            <th>branch name</th>
                                            <th>Image</th>
                                            
											<th>Service name</th>
                                            <th>Description</th>
                                            <th>Feature with dropdown</th>
                                            <th>Feature with image</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>

                                    <?php
                                    $s=mysqli_query($db,"select * from branch_srvcs order by id desc");
                                    while($r=mysqli_fetch_row($s))
                                    {
                                         $bbs = mysqli_query($db, "SELECT * FROM branch_dtls where id=$r[1] "); // Execute the query  
            $bbr = mysqli_fetch_row($bbs);

                                    ?>
                                        <tr>
                                            <td><?php echo $bbr[1]?></td>
                                            <td><img src="../images/branch/srvc/<?php echo $r[3]?>" width="120" height="150px" class="img img-responsive img-circle"></td>
                                            <td><?php echo $r[2]?></td>
                                            <td><?php echo $r[5]?></td>
                                            <td><a href="branch_srvs_ft.php?id=<?= $r[0] ?>">Add features</a></td>
                                            <td><a href="branch_srvs_ftimg.php?id=<?= $r[0] ?>">Add Image Features</a></td>
			
                                            <td>
                                                <a href="branch_srvc_edit.php?id=<?php echo $r[0]?>" title="Edit">
                                                <i class="ti-pencil-alt" class="mst"style="font-size: 15px !important;"></i>
                                                 </a>
                                                 <a href="javascript:deletepro_id(<?php echo $r[0]; ?>)" title="Delete" data-toggle="tooltip" data-original-title="Delete" title="Delete"><i class="ti-trash" class="mst"style="font-size: 15px !important;"></i>  </a>           
                                            </td>
                                            
                                        </tr>
                                        
                                       
                                        <?php
                                    }


                              ?>
                                       
                                        
                                    </tbody>
                                </table>
                                </div><!-- end card-body -->
                            </div><!-- end card -->
                        </div>
                        <!-- end col -->
                    </div>



</div>
</div>
</div>
</div>
    









<div id="back-top" style="display: none;">
<a title="Go to Top" href="#">
<i class="ti-angle-up"></i>
</a>
</div>

<div class="footer_part">
                <div class="container-fluid">
                <div class="row">
                <div class="col-lg-12">
                <div class="footer_iner text-center">
                <p>2023 © Al Barsha Electronics LLC  - Designed by <a href="https://www.oracuz.com/">Oracuz</a></p>
                </div>
                </div>
                </div>
                </div>
                </div>
                </section>

<script src="js/jquery1-3.4.1.min.js"></script>

<script src="js/popper1.min.js"></script>

<script src="js/bootstrap.min.php"></script>

<script src="js/metisMenu.js"></script>

<script src="vendors/count_up/jquery.waypoints.min.js"></script>

<script src="vendors/chartlist/Chart.min.js"></script>

<script src="vendors/count_up/jquery.counterup.min.js"></script>

<script src="vendors/niceselect/js/jquery.nice-select.min.js"></script>

<script src="vendors/owl_carousel/js/owl.carousel.min.js"></script>

<script src="vendors/datatable/js/jquery.dataTables.min.js"></script>
<script src="vendors/datatable/js/dataTables.responsive.min.js"></script>
<script src="vendors/datatable/js/dataTables.buttons.min.js"></script>
<script src="vendors/datatable/js/buttons.flash.min.js"></script>
<script src="vendors/datatable/js/jszip.min.js"></script>
<script src="vendors/datatable/js/pdfmake.min.js"></script>
<script src="vendors/datatable/js/vfs_fonts.js"></script>
<script src="vendors/datatable/js/buttons.php5.min.js"></script>
<script src="vendors/datatable/js/buttons.print.min.js"></script>

<script src="vendors/datepicker/datepicker.js"></script>
<script src="vendors/datepicker/datepicker.en.js"></script>
<script src="vendors/datepicker/datepicker.custom.js"></script>
<script src="js/chart.min.js"></script>
<script src="vendors/chartjs/roundedBar.min.js"></script>

<script src="vendors/progressbar/jquery.barfiller.js"></script>

<script src="vendors/tagsinput/tagsinput.js"></script>

<script src="vendors/text_editor/summernote-bs4.js"></script>
<script src="vendors/am_chart/amcharts.js"></script>

<script src="vendors/scroll/perfect-scrollbar.min.js"></script>
<script src="vendors/scroll/scrollable-custom.js"></script>

<script src="vendors/vectormap-home/vectormap-2.0.2.min.js"></script>
<script src="vendors/vectormap-home/vectormap-world-mill-en.js"></script>

<script src="vendors/apex_chart/apex-chart2.js"></script>
<script src="vendors/apex_chart/apex_dashboard.js"></script>
<script src="vendors/echart/echarts.min.js"></script>
<script src="vendors/chart_am/core.js"></script>
<script src="vendors/chart_am/charts.js"></script>
<script src="vendors/chart_am/animated.js"></script>
<script src="vendors/chart_am/kelly.js"></script>
<script src="vendors/chart_am/chart-custom.js"></script>

<script src="js/dashboard_init.js"></script>
<script src="js/custom.js"></script>


<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.13.2/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.3.4/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/2.3.4/js/buttons.html5.min.js"></script>

<script type="text/javascript">
    

    $(document).ready(function() {
    $('#example').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ]
    } );
} );
</script>




</body>

<!-- Mirrored from demo.dashboardpack.com/sales.php/ by HTTrack Website Copier/3.x [XR&CO'2014], Wed, 15 Feb 2023 12:12:37 GMT -->
 </html>
