<?php 
include('header.php');
include('left_sidebar.php');
$button=@$_GET["mode"]=="edit"? "Update": "Submit";
if(@$_GET["objID"]!="")
{
      $CatRs=mysqli_query($con,"select * from tp_category where id='".$_GET["objID"]."'") ;
      $CatRow=mysqli_fetch_assoc($CatRs) ;  
  
}


if($_POST["Submit"]=="Update")
{
    
extract($_POST);

$cQuery="update tp_category set category_id='".mysqli_real_escape_string($con,$_REQUEST["category_id"])."',
subcategory='".mysqli_real_escape_string($con,$_REQUEST["subcategory"])."',
amount='".mysqli_real_escape_string($con,$_REQUEST["amount"])."',
status='".mysqli_real_escape_string($con,$_REQUEST["status"])."'";

    if($_FILES['image1']['name']!=""){                           
          $image=time()."-".md5(rand())."-".$_FILES['image1']['name'];              
             if($image!=""){
                $cQuery.=",filename ='".$image."'"    ;              
                $target="../file_upload/category/";
                $source=$_FILES["image1"]["tmp_name"];
                $target=$target.$image;
                move_uploaded_file($source,$target) ; 
              }               
              } 
                         
             $cQuery.="  where id='".$_GET["objID"]."'" ;
        
        $RowCons=mysqli_query($con,$cQuery) or die(mysql_error());
          if($RowCons)
           {
                 $_SESSION["msg"]="record is updated successfully ";
                 header("location:view_category.php");
                 exit() ;
           }

}else if(isset($_POST["Submit"])=="Submit")
{
        extract($_POST);

        $cQuery="insert into tp_category set category_id='".mysqli_real_escape_string($con,$_REQUEST["category_id"])."',
subcategory='".mysqli_real_escape_string($con,$_REQUEST["subcategory"])."',
amount='".mysqli_real_escape_string($con,$_REQUEST["amount"])."',
status='".mysqli_real_escape_string($con,$_REQUEST["status"])."'";  

if($_FILES['image1']['name']!="")
                        {                            
          $image=time()."-".md5(rand())."-".$_FILES['image1']['name'];
                
             if($image!="")
             {
                $cQuery.=",filename ='".$image."'"    ;              
                $target="../file_upload/category/";
                $source=$_FILES["image1"]["tmp_name"];
                $target=$target.$image;
                move_uploaded_file($source,$target) ; 
              }     
                }      
                 
        $RowCons=mysqli_query($con,$cQuery) or die(mysql_error());
        if($RowCons)
           {
                 $_SESSION["msg"]="One Record Is Inserted ";
                 header("location:view_category.php");
                 exit() ;
           
           }

}

?>
       
        <!-- ============================================================== -->
        <!-- Page wrapper  -->
        <!-- ============================================================== -->
        <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Container fluid  -->
            <!-- ============================================================== -->
            <div class="container-fluid">
                <!-- ============================================================== -->
                <!-- Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <div class="row page-titles">
                    <div class="col-md-5 col-8 align-self-center">
                        <h3 class="text-themecolor">New Category</h3>
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                            <li class="breadcrumb-item active">New Category</li>
                        </ol>
                    </div>
                   
                </div>
                <!-- ============================================================== -->
                <!-- End Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <!-- ============================================================== -->
                <!-- Start Page Content -->
                <!-- ============================================================== -->
                
                 <!-- Row -->
                   <div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title">New Category</h4>
                              
                               
                                <form class="form" method="post" action="" enctype="multipart/form-data">
                                 <?php if(isset($_SESSION["msg"]))
                    { ?>                                        
                                        <div class="alert alert-danger"> <?php echo $_SESSION["msg"]; ?>
                                            <button type="button" class="close" data-dismiss="alert" aria-label="Close"> <span aria-hidden="true">×</span> </button>
                                        </div>
                                    <?php unset($_SESSION["msg"]);  }
                                        ?>
                                    <div class="form-group row">
                                        <label for="example-search-input" class="col-2 col-form-label">Main Category</label>
                                        <div class="col-10">
                                             <select class="custom-select col-12" id="inlineFormCustomSelect" name="category_id" required>
                                             
                      <option value='Skoda cars' <?php if($CatRow['category_id']=='Skoda cars'){ echo "Selected";}?>> Skoda cars</option>
                     
                                              </select>
                                        </div>
                                    </div>
                                     
                                     <div class="form-group row">
                                        <label for="example-tel-input" class="col-2 col-form-label">SubCategory:</label>
                                        <div class="col-10">
                                            <input class="form-control" type="text" name="subcategory" value="<?php echo htmlspecialchars($CatRow["subcategory"]);?>" id="example-tel-input" placeholder="subcategory" required>
                                        </div>
                                    </div>

                                    <!-- <div class="form-group row">
                                        <label for="example-tel-input" class="col-2 col-form-label">Starts Amount:</label>
                                        <div class="col-10">
                                            <input class="form-control" type="text" name="amount" value="<?php echo htmlspecialchars($CatRow["amount"]);?>" id="example-tel-input" placeholder="amount" required>
                                        </div>
                                    </div>

                                    <div class="form-group row">
                                        <label for="example-text-input" class="col-2 col-form-label">Image</label>
                                        <div class="col-7">
                                            <input class="form-control" type="file" id="example-file-input" name="image1">
                                        </div>
                                        <div class="col-3">
                                        <?php if(isset($CatRow["filename"])){?>
                                           <img src="../file_upload/category/<?=$CatRow["filename"];?>" height="80">
                                        <?php } ?>
                                        </div>
                                    </div> -->
                                     
                                    <div class="form-group row" style="display:none;">
                                        <label for="example-search-input" class="col-2 col-form-label">Status</label>
                                        <div class="col-10">
                                            <select class="custom-select col-12" id="inlineFormCustomSelect" name="status" required>
                                           
                                              <?php if($CatRow['status']=='1'){ ?>
                                                <option value="1" selected >Active</option>
                                                <option value="0">Deactive</option>
                                                <?php }else if($CatRow['status']=='0'){?>
                                                <option value="0" selected >Deactive</option>
                                                  <option value="1"  >Active</option>
                                              <?php }else{ ?> 
                                                <option value="1" selected>Active</option>
                                               <option value="0">Deactive</option>
                                              <?php } ?>
                                                 
                                              </select>
                                        </div>
                                    </div>
                                    <input name="Submit" type="hidden"  value="<?=$button;?>"/> 
                                   <button type="submit" name="submit" class="btn btn-info waves-effect waves-light ">Submit</button> 
                                </form>
                            </div>
                        </div>
                    </div>
                </div>  
               
                
                     
                <!-- ============================================================== -->
                <!-- End PAge Content -->
                <!-- ============================================================== -->
               <?php include('footer.php');?>