<?
$product="active";
$caller1="open";
$prod_vid="active";

require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
session_start();
?>

<?
								
								
								
if(isset($_POST['sumbit']))

{
if ($_REQUEST["form_action"] == "Insert") {


 date_default_timezone_set('Asia/Kolkata');

  $date_ss = date('Y-m-d H:i:s ', time());


 $tablename = "`tbl_doctor_appointment`";
 
 
 
$date=trim(addslashes($_REQUEST['date']));

$date = date("Y-m-d", strtotime($date));

 $product_name=trim(addslashes($_REQUEST['product_name']));
 $one_line=trim(addslashes($_REQUEST['one_line']));
 $videocode=trim(addslashes($_REQUEST['videocode']));
 
$price=trim(addslashes($_REQUEST['price']));
$int_price=trim(addslashes($_REQUEST['int_price']));
echo $sell_price=trim(addslashes($_REQUEST['sell_price']));
$ean=trim(addslashes($_REQUEST['ean']));
$filename = $_REQUEST['filename'];

if($sell_price=='')
{
echo $sell_price=100;
}

$weight=trim(addslashes($_REQUEST['weight']));
$category=trim(addslashes($_REQUEST['category']));
$job_description=trim(addslashes($_REQUEST['job_description']));
$sp_ins=trim(addslashes($_REQUEST['sp_ins']));
$disease=0;
$company=trim(addslashes($_REQUEST['company']));
//$reason_to_min=trim(addslashes($_REQUEST['reason_to_min']));

$used_for=trim(addslashes($_REQUEST['used_for']));

$dosage=trim(addslashes($_REQUEST['dosage']));

 //$Query_last_invoice = "SELECT date from  tbl_doctor_appointment where  (date='".$date."'  )  ";

	//$name_last_invoice=$DB->query($Query_last_invoice);

	  //$noo=mysql_num_rows($name_last_invoice);
	  $tablename = "shop_product";
	  
	  
	/*  '".trim( $_REQUEST['job_code'] )."','".$new_job_name."','".$des."','".trim( $_REQUEST['job_priority'] )."','".$job_po_no."','".trim( $_REQUEST['pricing'] )."','".trim( $_REQUEST['job_type'] )."','','".$est_time_new."','".$date."','".trim( $_REQUEST['user_type'] )."','','',

		'".trim( $clientemail )."','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','',''*/
	  
	  $Query="INSERT INTO $tablename  VALUES (NULL,'$product_name','','','','','','','','','120','','','','','12','0','','58','0','".$price."','100','0','0','1','1','1','1','1','0','0','0','0','0','0','2','0000-00-00 00:00:00','0000-00-00 00:00:00','0','100','$videocode','1','$filename','0',NULL,'yes')";

		$DB->query($Query);
		
		 $mysql_insert_id= mysql_insert_id();
		 
		 if($_FILES['mast']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/s-img/'; // the directory for the original image

	$thumbdir = '../../default/s-img/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	echo $userfile_name = $_FILES['mast']['name'];



	 $userfile_tmp = $_FILES['mast']['tmp_name'];



	//$userfile_name = $_FILES['uploadFile']['name'];



	//$userfile_tmp = $_FILES['uploadFile']['tmp_name'];





	$getExt = explode ('.', $userfile_name);

	 $rand_name = md5(rand(000,999));

	/* $prod_img = $filedir.$mysql_insert_id.$i.$getExt[0].".".$getExt[1];*/

	

	 $new_file_name = $userfile_name;

	

		//exit();

		 $new_file_name = str_replace('&','and',$new_file_name);

		 $new_file_name = str_replace('#','',$new_file_name);

		 $new_file_name = str_replace('+','',$new_file_name);
$new_file_name = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
$new_file_name_3730=$new_file_name;
		  $new_file_name=($mysql_insert_id.$new_file_name);

		   $prod_img = $filedir.$new_file_name; // original_images/456546565465465464jhh.jpg

		$items[] = $prod_img;

		$prod_img_thumb = $thumbdir.$getExt[0].".".$getExt[1];

		 

		

		

		

		move_uploaded_file($userfile_tmp, $prod_img);

		 $upload_img = "UPDATE  shop_product SET image='".$new_file_name."' WHERE product_id='".$mysql_insert_id."'";
	 $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }



 
 
 
				
				
				
}


}
?>
      
	  <?php include("header.php"); ?>
  
	  
	        <div class="row wrapper border-bottom white-bg page-heading">
			
			<? if($flag=="sucess")
{

?>
<div class="alert alert-success">
  <strong>Success!</strong> Data Added Sucessfully.
</div>
<?
}
?>
<? if($flag=="failure")
{

?>
<div class="alert alert-danger">
  <strong>Danger!</strong> Already Exists.
</div>

<?
}
?>
			
                <div class="col-lg-10">
                    <h2>Product</h2>
                    <ol class="breadcrumb">
                        <li>
                            <a href="index.html">Home</a>
                        </li>
                        <li>
                            <a> Video</a>
                        </li>
                        <li class="active">
                            <strong>Add Video</strong>
                        </li>
                    </ol>
                </div>
                <div class="col-lg-2">

                </div>
            </div>
        <div class="wrapper wrapper-content animated fadeInRight">
            
            
            <div class="row">
			
			<div class="ibox-content">
			
			

<script language="JavaScript" type="text/JavaScript">
function  validation(){}
	//print($row1['file_path']);


	
</script>
			
			
                            <form name="register" method="post" onSubmit="return validation();" class="form-horizontal" enctype="multipart/form-data">
                                
								
								
								
								<div class="form-group"><label class="col-sm-2 control-label">Product Name</label>

                                    <div class="col-sm-10"><input type="text" name="product_name" value=""  class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">Price</label>

                                    <div class="col-sm-10"><input type="text" name="price" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">Video Code</label>

                                    <div class="col-sm-10"><input type="text" name="videocode" value="" class="form-control"></div>
                                </div>
                                <div class="form-group"><label class="col-sm-2 control-label">Video File Name</label>

                                    <div class="col-sm-10"><input type="text" name="filename" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<!--<div class="form-group"><label class="col-sm-2 control-label">Price</label>

                                    <div class="col-sm-10"><input type="text" name="price" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								 
								
								<div class="form-group"><label class="col-sm-2 control-label">International Price</label>

                                    <div class="col-sm-10"><input type="text" name="int_price" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">Malaysia Price</label>

                                    <div class="col-sm-10"><input type="text" name="ean" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">Quantity</label>

                                    <div class="col-sm-10"><input type="text" name="sp_ins" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">One Line</label>

                                    <div class="col-sm-10"><input type="text" name="one_line" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">Weight(Mention in gms)</label>

                                    <div class="col-sm-10"><input type="text" name="weight" value="" onkeypress="return isNumber(event)" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<div class="form-group"><label class="col-sm-2 control-label">Used For</label>

                                    <div class="col-sm-10"><input type="text" name="used_for" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								
								<div class="form-group"><label class="col-sm-2 control-label">Dosage</label>

                                    <div class="col-sm-10"><input type="text" name="dosage" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>-->
								
								
								
								
								
								
                               
                              





								
								
								<div class="form-group"><label class="col-sm-2 control-label">Cover Image</label>

                                    <div class="col-sm-10"><input type="file" name="mast" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								
								
                               
								 
                                
                                
                                
                               
                               
                               
                                
                                
                                
                                
                                
                                <div class="form-group">
                                    <div class="col-sm-4 col-sm-offset-2">
                                        <button class="btn btn-white" type="submit">Cancel</button>
                                       <!-- <button class="btn btn-primary" type="submit">Save changes</button>-->
										<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Submit" >
										
										
										<?php
                        if ($update_option == 1) {
                            echo'<input type="hidden" name="form_action" value="Update"/>';
                            echo'<input type="hidden" name="id" value="' . $id . '"/>';
							
                        } else {
                            echo'<input type="hidden" name="form_action" value="Insert"/>';
                        }
                        ?>
										
                                    </div>
                                </div>
                            </form>
                        </div>

                
                
                    </div>
        
            
        </div>
        <div class="footer">
            <div class="pull-right">
                10GB of <strong>250GB</strong> Free.
            </div>
            <div>
                <strong>Copyright</strong> dranbuganapathi.com  &copy; 2019-2020
            </div>
        </div>

        </div>
                    </div>

  <!-- Mainly scripts -->
    <script src="js/jquery-2.1.1.js"></script>
    <script src="js/bootstrap.min.js"></script>

    <!-- Custom and plugin javascript -->
    <script src="js/inspinia.js"></script>
    <script src="js/plugins/pace/pace.min.js"></script>
    <script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>

    <!-- Chosen -->
    <script src="js/plugins/chosen/chosen.jquery.js"></script>

   <!-- JSKnob -->
   <script src="js/plugins/jsKnob/jquery.knob.js"></script>

   <!-- Input Mask-->
    <script src="js/plugins/jasny/jasny-bootstrap.min.js"></script>

   <!-- Data picker -->
   <script src="js/plugins/datapicker/bootstrap-datepicker.js"></script>

   <!-- NouSlider -->
   <script src="js/plugins/nouslider/jquery.nouislider.min.js"></script>

   <!-- Switchery -->
   <script src="js/plugins/switchery/switchery.js"></script>

    <!-- IonRangeSlider -->
    <script src="js/plugins/ionRangeSlider/ion.rangeSlider.min.js"></script>

    <!-- iCheck -->
    <script src="js/plugins/iCheck/icheck.min.js"></script>

    <!-- MENU -->
    <script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>

    <!-- Color picker -->
    <script src="js/plugins/colorpicker/bootstrap-colorpicker.min.js"></script>

    <!-- Clock picker -->
    <script src="js/plugins/clockpicker/clockpicker.js"></script>

    <!-- Image cropper -->
    <script src="js/plugins/cropper/cropper.min.js"></script>

    <!-- Date range use moment.js same as full calendar plugin -->
    <script src="js/plugins/fullcalendar/moment.min.js"></script>

    <!-- Date range picker -->
    <script src="js/plugins/daterangepicker/daterangepicker.js"></script>

    <script>
        $(document).ready(function(){

            var $image = $(".image-crop > img")
            $($image).cropper({
                aspectRatio: 1.618,
                preview: ".img-preview",
                done: function(data) {
                    // Output the result data for cropping image.
                }
            });

            var $inputImage = $("#inputImage");
            if (window.FileReader) {
                $inputImage.change(function() {
                    var fileReader = new FileReader(),
                            files = this.files,
                            file;

                    if (!files.length) {
                        return;
                    }

                    file = files[0];

                    if (/^image\/\w+$/.test(file.type)) {
                        fileReader.readAsDataURL(file);
                        fileReader.onload = function () {
                            $inputImage.val("");
                            $image.cropper("reset", true).cropper("replace", this.result);
                        };
                    } else {
                        showMessage("Please choose an image file.");
                    }
                });
            } else {
                $inputImage.addClass("hide");
            }

            $("#download").click(function() {
                window.open($image.cropper("getDataURL"));
            });

            $("#zoomIn").click(function() {
                $image.cropper("zoom", 0.1);
            });

            $("#zoomOut").click(function() {
                $image.cropper("zoom", -0.1);
            });

            $("#rotateLeft").click(function() {
                $image.cropper("rotate", 45);
            });

            $("#rotateRight").click(function() {
                $image.cropper("rotate", -45);
            });

            $("#setDrag").click(function() {
                $image.cropper("setDragMode", "crop");
            });

            $('#data_1 .input-group.date').datepicker({
                todayBtn: "linked",
                keyboardNavigation: false,
                forceParse: false,
                calendarWeeks: true,
                autoclose: true
            });

            $('#data_2 .input-group.date').datepicker({
                startView: 1,
                todayBtn: "linked",
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true,
                format: "dd/mm/yyyy"
            });

            $('#data_3 .input-group.date').datepicker({
                startView: 2,
                todayBtn: "linked",
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true
            });

            $('#data_4 .input-group.date').datepicker({
                minViewMode: 1,
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true,
                todayHighlight: true
            });

            $('#data_5 .input-daterange').datepicker({
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true
            });

            var elem = document.querySelector('.js-switch');
            var switchery = new Switchery(elem, { color: '#1AB394' });

            var elem_2 = document.querySelector('.js-switch_2');
            var switchery_2 = new Switchery(elem_2, { color: '#ED5565' });

            var elem_3 = document.querySelector('.js-switch_3');
            var switchery_3 = new Switchery(elem_3, { color: '#1AB394' });

            $('.i-checks').iCheck({
                checkboxClass: 'icheckbox_square-green',
                radioClass: 'iradio_square-green'
            });

            $('.demo1').colorpicker();

            var divStyle = $('.back-change')[0].style;
            $('#demo_apidemo').colorpicker({
                color: divStyle.backgroundColor
            }).on('changeColor', function(ev) {
                        divStyle.backgroundColor = ev.color.toHex();
                    });

            $('.clockpicker').clockpicker();

            $('input[name="daterange"]').daterangepicker();

            $('#reportrange span').html(moment().subtract(29, 'days').format('MMMM D, YYYY') + ' - ' + moment().format('MMMM D, YYYY'));

            $('#reportrange').daterangepicker({
                format: 'MM-DD-YYYY',
                startDate: moment().subtract(29, 'days'),
                endDate: moment(),
                minDate: '01-01-2012',
                maxDate: '12-31-2015',
                dateLimit: { days: 60 },
                showDropdowns: true,
                showWeekNumbers: true,
                timePicker: false,
                timePickerIncrement: 1,
                timePicker12Hour: true,
                ranges: {
                    'Today': [moment(), moment()],
                    'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                    'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                    'This Month': [moment().startOf('month'), moment().endOf('month')],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
                },
                opens: 'right',
                drops: 'down',
                buttonClasses: ['btn', 'btn-sm'],
                applyClass: 'btn-primary',
                cancelClass: 'btn-default',
                separator: ' to ',
                locale: {
                    applyLabel: 'Submit',
                    cancelLabel: 'Cancel',
                    fromLabel: 'From',
                    toLabel: 'To',
                    customRangeLabel: 'Custom',
                    daysOfWeek: ['Su', 'Mo', 'Tu', 'We', 'Th', 'Fr','Sa'],
                    monthNames: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
                    firstDay: 1
                }
            }, function(start, end, label) {
                console.log(start.toISOString(), end.toISOString(), label);
                $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
            });


        });
        var config = {
                '.chosen-select'           : {},
                '.chosen-select-deselect'  : {allow_single_deselect:true},
                '.chosen-select-no-single' : {disable_search_threshold:10},
                '.chosen-select-no-results': {no_results_text:'Oops, nothing found!'},
                '.chosen-select-width'     : {width:"95%"}
                }
            for (var selector in config) {
                $(selector).chosen(config[selector]);
            }

        $("#ionrange_1").ionRangeSlider({
            min: 0,
            max: 5000,
            type: 'double',
            prefix: "$",
            maxPostfix: "+",
            prettify: false,
            hasGrid: true
        });

        $("#ionrange_2").ionRangeSlider({
            min: 0,
            max: 10,
            type: 'single',
            step: 0.1,
            postfix: " carats",
            prettify: false,
            hasGrid: true
        });

        $("#ionrange_3").ionRangeSlider({
            min: -50,
            max: 50,
            from: 0,
            postfix: "°",
            prettify: false,
            hasGrid: true
        });

        $("#ionrange_4").ionRangeSlider({
            values: [
                "January", "February", "March",
                "April", "May", "June",
                "July", "August", "September",
                "October", "November", "December"
            ],
            type: 'single',
            hasGrid: true
        });

        $("#ionrange_5").ionRangeSlider({
            min: 10000,
            max: 100000,
            step: 100,
            postfix: " km",
            from: 55000,
            hideMinMax: true,
            hideFromTo: false
        });

        $(".dial").knob();

        $("#basic_slider").noUiSlider({
            start: 40,
            behaviour: 'tap',
            connect: 'upper',
            range: {
                'min':  20,
                'max':  80
            }
        });

        $("#range_slider").noUiSlider({
            start: [ 40, 60 ],

            behaviour: 'drag',
            connect: true,
            range: {
                'min':  20,
                'max':  80
            }
        });

        $("#drag-fixed").noUiSlider({
            start: [ 40, 60 ],
            behaviour: 'drag-fixed',
            connect: true,
            range: {
                'min':  20,
                'max':  80
            }
        });


    </script>

</body>

</html>