EVOLUTION-NINJA
Edit File: edit_sales_details.php
<?php $this->load->view('includes/header.php')?> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/grid_style.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap-ui.css'); ?>" /> <link rel="stylesheet" href="<?php echo base_url('assets/css/bootstrap-datepicker.css');?>" /> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <script src="<?php echo base_url('assets/js/bootstrap-datepicker.js');?>"></script> <div class="content-wrapper"> <div class="row"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <form id="sales_submit" class="form_submit"> <input type="hidden" class="col-sm-8" value="<?php echo $sales->id;?>" name="sales_id" > <div class="col-xs-12"> <div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom:10px;"> <div class="col-sm-12 col-md-3"> <span style="font-size:25px;">Edit Sales Page</span> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6 "> <label class="col-sm-4">Layouts</label> <div class="col-sm-12 yes_form"> <select name="layout" class="form-control layout" id="layout" required> <option value="">Select</option> <?php foreach($layout_name as $value) { ?> <option value="<?php echo $value->id; ?>"<?php if($sales->layout_name_id==$value->id){ echo 'selected'; } ?>><?php echo $value->layout_name;?></option> <?php } ?> </select> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-4">Site</label> <div class="col-sm-12 yes_form"> <select name="site_number" class="form-control site_number" id="site_number" required > </select> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Site No</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control site_num" name="site_num" value="<?php echo $sales->site_number; ?>" readonly > </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Sqft</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control sqft" name="sqft" value="<?php echo $sales->sqft; ?>"readonly> </div> </div> </div> <!-- <div class="row"> <div class="col-sm-3" style="display: flex;"> <label style="padding-top: 35px; padding-right: 20px;">GF</label> <div class="form-group"> <label style="margin-left: 35px;">Built Up</label> <div class="yes_form"> <input style="margin-left: 35px;" type="text" class="form-control gf_built_up" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" name="gf_built_up" value="<?php //echo $sales->gf_built_up; ?>"> </div> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Balcony</label> <div class="yes_form"> <input style="margin-left: 20px;" type="text" class="form-control gf_balcony" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" name="gf_balcony" value="<?php //echo $sales->gf_balcony; ?>"> </div> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Days</label> <div class="yes_form"> <input style="margin-left: 2px;" type="text" class="form-control gf_days" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" name="gf_days" value="<?php //echo $sales->gf_days; ?>" > </div> </div> </div> </div> --> <!-- <div class="row"> <div class="col-sm-3" style="display: flex;"> <label style="padding-top: 35px; padding-right: 20px;">GF+MF</label> <div class="form-group"> <label></label> <div class="yes_form"> <input style="width: 201px;" type="text" class="form-control gf_mf_built_up" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" name="gf_mf_built_up" value="<?php //echo $sales->gf_mf_built_up; ?>"> </div> </div> </div> <div class="col-md-3"> <div class="form-group"> <label ></label> <div class="yes_form"> <input style="margin-left: 20px;" type="text" class="form-control gf_mf_balcony" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" name="gf_mf_balcony" value="<?php //echo $sales->gf_mf_balcony; ?>"> </div> </div> </div> <div class="col-md-3"> <div class="form-group"> <label ></label> <div class="yes_form"> <input type="text" class="form-control gf_mf_days" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" name="gf_mf_days" value="<?php //echo $sales->gf_mf_days; ?>"> </div> </div> </div> </div> --> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-4">Selection</label> <div class="col-sm-12 yes_form"> <select name="sales_selection" class="form-control sales_selection" required> <option value="">Select</option> <option value="house" <?php if ($sales->selection_type == "house") echo "selected='selected'" ?>>House</option> <option value="site" <?php if ($sales->selection_type == "site") echo "selected='selected'" ?>>Site</option> </select> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6 "> <label class="col-sm-4">Name</label> <div class="col-sm-12 yes_form"> <select name="cust_name" class="form-control cust_name" id="cust_name" required> <option value="">Select</option> <?php foreach($customer_name as $value) { ?> <option value="<?php echo $value->id; ?>"<?php if($sales->customer_name_id==$value->id){ echo 'selected'; } ?>><?php echo $value->name;?></option> <?php } ?> </select> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6 "> <label class="col-sm-4">Payment Type</label> <div class="col-sm-12 yes_form"> <select name="payment_type" class="form-control payment_type" id="cust_name" required> <option value="">Select</option> <?php foreach($payment_type_name as $value) { ?> <option value="<?php echo $value->id; ?>"<?php if($sales->payment_type_id==$value->id){ echo 'selected'; } ?>><?php echo $value->payment_type;?></option> <?php } ?> </select> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Register Date</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control reg_date" id="datepicker1" name="reg_date" value="<?php echo $sales->register_date; ?>"> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Site Cost</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control site_cost" name="site_cost" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" value="<?php echo $sales->site_cost; ?>"> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Site Reg Cost</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control site_reg_cost" name="site_reg_cost" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" value="<?php echo $sales->site_reg_cost; ?>" > </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Construction Cost</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control const_cost" name="const_cost" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" onkeyup="totalcost_valuefirst()" value="<?php echo $sales->construction_cost; ?>" > </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Total Cost</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control tot_cost" name="tot_cost" value="<?php echo $sales->total_cost; ?>" readonly> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">P/L Of Site</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control plan_site" name="plan_site" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" value="<?php echo $sales->plan_of_site; ?>"> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">P/L Of Const</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control plan_const" name="plan_const" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" onkeyup="finalplan_valuefirst()" value="<?php echo $sales->plan_of_construction; ?>"> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Final P/L</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control final_plan" name="final_plan" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" value="<?php echo $sales->final_plan; ?>"> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Package Total</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control package_tot" name="package_tot" value="<?php echo $sales->package_total; ?>" readonly> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">MUDA Approved Plan Charges</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control muda_plan" name="muda_plan" pattern="^\d*(\.\d{0,2})?$" title="Please Enter numbers only" value="<?php echo $sales->muda_approved_plan; ?>"> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Land Owner Khata Charges</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control land_owner_khata" name="land_owner_khata" value="<?php echo $sales->land_owner_khata; ?>"> </div> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Comm%</label> <div class="col-sm-12 yes_form"> <input type="number" class="form-control comm" min="0" name="comm" value="<?php echo $sales->comm; ?>"> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">CR</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control cr" name="cr" value="<?php echo $sales->cr; ?>"> </div> </div> <div class="col-sm-12 col-xs-12 col-md-6"> <label class="col-sm-6">Completed Date</label> <div class="col-sm-12 yes_form"> <input type="text" class="form-control completed_date" id="datepicker2" name="completed_date" value="<?php echo $sales->completed_date; ?>"> </div> </div> </div> <div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;"> <div class="col-sm-12 col-md-2"> </div> <div class="col-sm-7"></div> <div class="col-sm-3"> <button type="submit" class="btn btn-primary">Save</button> <button type="reset" class="btn">Cancel</button> </div> </div> </div> </form> <div id ="jaytab" style="margin-top:3%" class="grid table-responsive"> <table id="list2"></table> <div id="pager2"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> </div> </div> </div> <style type="text/css"> pre { background-color: transparent; border: 1px solid transparent; line-height: 1.6; text-align: justify; } .form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus { border-color: #FF0000; box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6); } </style> <script type="text/javascript"> function totalcost_valuefirst() { var site_cost = $('.site_cost').val(); var site_reg_cost = $('.site_reg_cost').val(); var const_cost = $('.const_cost').val(); var site_total = parseFloat(site_cost)+parseFloat(site_reg_cost)+parseFloat(const_cost); $('.tot_cost').val(site_total.toFixed(2)); } function finalplan_valuefirst() { var plan_site = $('.plan_site').val(); var plan_const = $('.plan_const').val(); var final_plan_total = parseFloat(plan_site)+parseFloat(plan_const); $('.final_plan').val(final_plan_total.toFixed(2)); var site_cost = $('.site_cost').val(); var site_reg_cost = $('.site_reg_cost').val(); var const_cost = $('.const_cost').val(); var site_total = parseFloat(site_cost)+parseFloat(site_reg_cost)+parseFloat(const_cost); var package_tot = parseFloat(site_total) + parseFloat(final_plan_total); $('.package_tot').val(package_tot.toFixed(2)); } $('#datepicker1').datepicker({ format: "dd/mm/yyyy", }).on('changeDate', function(ev){ $('#datepicker1').datepicker('hide'); }); $('#datepicker2').datepicker({ format: "dd/mm/yyyy", }).on('changeDate', function(ev){ $('#datepicker2').datepicker('hide'); }); changelayout_onload(); function changelayout_onload() { var layout_name = '<?php echo $sales->layout_name_id; ?>'; var site_id = '<?php echo $sales->site_no_id; ?>'; $.ajax({ type:'post', url:'<?php echo site_url('fetch-site-id');?>', data:{"layout_name":layout_name}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { var con = ''; //con += '<option value="">select</option>'; $.each(response.message, function( key, value ) { con += '<option value="'+value.id+'"'; if(site_id == value.id) { con += ' selected >'+value.site_no+'</option>'; } else { con += ' >'+value.site_no+'</option>'; } }); $('.site_number').empty(); $('.site_number').append(con); } else { toastr["error"](response.message); } } }); } $('#layout').change(function() { var layout_name = $(this).val(); alert(layout_name); $.ajax({ type:'post', url:'<?php echo site_url('fetch-site-id');?>', data:{"layout_name":layout_name}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { var con = ''; con += '<option value="">select</option>'; $.each( response.message, function( key, value ) { con += '<option value="'+value.id+'">'+value.site_no+'</option>'; }); $('.site_number').empty(); $('.site_number').append(con); } else { toastr["error"](response.message); } } }); }); $('#site_number').change(function() { var layout_id = $('#layout').val(); var site_number = $(this).val(); $.ajax({ type:'post', url:'<?php echo site_url('get-site-dimension');?>', data : {'site_id':site_number,'layout_id':layout_id}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.site_num').val(response.message.site_no); $('.sqft').val(response.message.sq_ft); } else { toastr["error"](response.message); } } }); }); $('#sales_submit').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $(".submit").text("Submitting..."); $(".submit").attr("disabled", true); $.ajax({ type : 'post', url : '<?php echo site_url("update-sales")?>', data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { swal({ title: "Are you sure?", text: "Added Succesfully", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, Add it!", closeOnConfirm: true, closeOnCancel: false }, function(isConfirm) { if (isConfirm) { toastr["success"](response.message); setTimeout(function wait(){ window.location = '<?php echo site_url("sales-list")?>'; }, 1000); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } else { toastr["error"](response.message); } } }); }); </script> <?php $this->load->view('includes/footer.php')?>