EVOLUTION-NINJA
Edit File: edit_civil_purchase_order.php
<?php echo view('includes/header');?> <div class="page-content-wrapper"> <div class="page-content"> <h3 class="page-title"> Edit Generated Civil Purchase Order</h3> <script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" /> <form method="post" class="work_po_form"> <table class="inner" border="1"> <tr> <th style="width:18%;">PO #</th> <td><input type="text" name="po_no" id="po_no" pattern="[0-9]+" style="width:45%;border: transparent;" value="<?php if(!empty($po_details)){echo '0000';echo $po_details->po_no; }?>" readonly> <select style="width:52%;" class="project_name" name="project_name" id="project_name" style="width:100%;border: transparent;" required> <option value="<?php if(!empty($po_details)){echo $po_details->project_name; }?>"><?php echo $po_details->project_name; ?> </option> <?php foreach($owners as $value) { ?> <option value="<?php echo $value->project_name;?>"><?php echo $value->project_name;?></option> <?php } ?> </select> <input type="hidden" id="edit_id" name="edit_id" value="<?php if(!empty($po_details)){echo $po_details->id; }?>" style="width: 100%;border: transparent;" required> </td> <td style="width:60%;" rowspan="8"> <textarea rows="5" id="address" name="address" style="width: 100%; border: transparent;" placeholder="Address :" required readonly><?php if(!empty($po_details)){echo $po_details->vendor_address; }?></textarea> </td> </tr> <tr> <th>Vendor</th> <td contenteditable="true"><input type="text" id="vendor_name" name="vendor_name" onfocusout="vendor_myFunction(this.value)" value="<?php if(!empty($po_details)){echo $po_details->vendor; }?>" style="width: 100%;border: transparent;" required readonly> </td> </tr> <tr> <th>Date</th> <td style="width:109px;"><input type="text" name="g_date" id="g_date" style="width: 100%;border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->date; }?>" readonly="readonly" required></td> </tr> <tr > <th>Currency</th> <td> <select name="currency" id="currency" style="width: 100%;border: transparent;" required> <option value="INR" <?php if(!empty($po_details) && ($po_details->currency=='INR')){echo "selected"; }?>>INR</option> <option value="CHF" <?php if(!empty($po_details) && ($po_details->currency=='CHF')){echo "selected"; }?>>CHF</option> <option value="EUR" <?php if(!empty($po_details) && ($po_details->currency=='EUR')){echo "selected"; }?>>EUR</option> <option value="GBP" <?php if(!empty($po_details) && ($po_details->currency=='GBP')){echo "selected"; }?>>GBP</option> <option value="USD" <?php if(!empty($po_details) && ($po_details->currency=='USD')){echo "selected"; }?>>USD</option> </select> </td> </tr> <tr> <th>Contact Person</th> <td style="width:109px;"><input type="text" pattern="[a-zA-Z\s]+" id="contact_person" name="contact_person" style="width: 100%;border: transparent;" required value="<?php if(!empty($po_details)){echo $po_details->contact_person; }?>"> </td> </tr> <tr> <th>Contact Number</th> <td style="width:109px;"><input type="text" pattern="^\d{10}" name="contact_number" id="contact_number" style="width: 100%;border: transparent;" required value="<?php if(!empty($po_details)){echo $po_details->contact_number; }?>"></td> </tr> <tr> <th>E-mail ID</th> <td style="width:109px;"><input type="email" id="email" name="email" style="width: 100%;border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->email; }?>"> </td> </tr> <tr> <th>From Address</th> <td style="width:109px;"><?php if($master_data){ echo $master_data->sname; } ?> </td> </tr> </table> <table style="width:100%; table-layout:fixed; " border="1"> <thead class="thead-default"> <tr> <th width="4%">Sl. No.</th> <th width="18%">Product Name</th> <th width="12%">Indent</th> <th width="10%" >Number</th> <th width="8%">Quantity</th> <th width="6%">Unit Price</th> <th width="6%" class="inr_val" id="inr_val" name="inr_val">Value</th> <th width="6%" class="chf_val" id="chf_val" name="chf_val" style="display: none;">CHF Value</th> <th width="6%" style="display: none;" class="eur_val" id="eur_val" name="eur_val">EUR Value</th> <th width="6%" style="display: none;" class="gbp_val" id="gbp_val" name="gbp_val">GBP Value</th> <th width="6%" style="display: none;" class="usd_val" id="usd_val" name="usd_val">USD Value</th> <th width="6%">SGST</th> <th width="6%">CGST</th> <th width="6%">IGST</th> <th width="6%">Total Value</th> <th width="12%">Remarks</th> </tr> </thead> <tbody> <?php $c=1;$key=1; foreach($fetch_details as $po_details){?> <tr> <td scope="row"><?php echo $c;?></td> <input type="hidden" id="edit_id<?php echo $key;?>" name="edit_id[]" value="<?php if(!empty($po_details)){echo $po_details->id; }?>" style="width: 100%;border: transparent;" required> <td> <input type="text" class="p_name" name="p_name[]" id="p_name" value="<?php if(!empty($po_details)){echo $po_details->product_name; }?>" style="border: transparent;text-transform: uppercase !important;" readonly="readonly" required> <input type="hidden" style="width:100%; border:transparent;" class="product_id" name="product_id[]" id="product_id" style="border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->product_id; }?>" required> </td> <td> <input type="text" class="i_no" name="i_no[]" id="i_no<?php echo $key;?>" value="<?php if(!empty($po_details)){echo $po_details->indent; }?>" style="width:100%; border: transparent;" required> </td> <td> <input type="text" class="purpose" name="purpose[]" id="purpose" value="<?php if(!empty($po_details)){echo $po_details->purpose_no; }?>" style="width:100%;border: transparent;text-transform: uppercase !important;" required > </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" id="quantityy<?php echo $key;?>" class="quantityy<?php echo $key;?>" name="quantityy[]" value="<?php if(!empty($po_details)){echo $po_details->quentity; }?>" pattern="[0-9]+" style="width: 100%;border: transparent;" required> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" id="unit<?php echo $key;?>" name="unit[]" onkeyup="unit_valuefirst(this.value,<?php echo $key;?>)" value="<?php if(!empty($po_details)){echo $po_details->unit_price; }?>" pattern="[0-9]+" class="unit<?php echo $key;?>" style="width: 100%;border: transparent;" required> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo round($po_details->inr_value); }?>" class="inrvalue<?php echo $key;?> inrval" id="inrvalue<?php echo $key;?>" name="inrvalue[]" pattern="[0-9]+" style="width: 100%;border: transparent;" required readonly> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->sgst; }?>" class="osgst<?php echo $key;?>" id="sgst<?php echo $key;?>" name="sgst[]" onkeyup="gstvalue1(this.value,<?php echo $key;?>)" pattern="[0-9]+" style="width: 42%;border: transparent;margin-left: 1px;" required> <span>%</span> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" class="ocgst<?php echo $key;?>" id="cgst<?php echo $key;?>" name="cgst[]" onkeyup="gstvalue2(this.value,<?php echo $key;?>)" value="<?php if(!empty($po_details)){echo $po_details->cgst; }?>" pattern="[0-9]+" style="width: 42%;border: transparent;margin-left: 1px;" required> <span>%</span> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" class="oigst<?php echo $key;?>" id="igst<?php echo $key;?>" name="igst[]" onkeyup="gstvalue3(this.value,<?php echo $key;?>)" value="<?php if(!empty($po_details)){echo $po_details->igst; }?>" pattern="[0-9]+" style="width: 42%;border: transparent;margin-left: 1px;" required> <span>%</span> </td> <td> <input type="text" class="totalvalue<?php echo $key;?> tot_val" id="totalvalue<?php echo $key;?>" value="<?php if(!empty($po_details)){echo round($po_details->total_value); }?>" name="totalvalue[]" style="width: 100%;border: transparent;" required readonly> </td> <td> <input type="text" style="width:100%; border:transparent;text-transform: uppercase !important;" class="remarks" name="remarks[]" id="remarks" value="<?php if(!empty($po_details)){echo $po_details->remarks; }?>"> </td> </tr> <?php $c++;$key++; }?> <tr> <td></td> <td colspan="3"> <input type="text" placeholder="OTHER CHARGES :" name="ot_charges" id="ot_charges" style="width: 100%;border: transparent;text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->ot_charges; }?>"> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_quantity; }?>" id="quantity_val" name="quantity_val" style="width: 100%;border: transparent;" pattern="[0-9]+"> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_unit; }?>" id="unit1" name="unit1" onfocusout="unitvalue1(this.value)" style="width: 100%;border: transparent;" pattern="[0-9]+"> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo round($po_details->ot_inr_value); }?>" class="inr_value_val" id="inr_value_val" name="inr_value_val" style="width: 100%;border: transparent;" pattern="[0-9]+" readonly> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_sgst; }?>" class="oosgst ot_sgst" id="ot_sgst" name="ot_sgst" onfocusout="sgstvalue1(this.value)" pattern="[0-9]+" style="width: 42%;border: transparent;margin-left: 1px;"> <span>%</span> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_cgst; }?>" class="oocgst ot_cgst" id="ot_cgst" name="ot_cgst" onfocusout="sgstvalue2(this.value)" pattern="[0-9]+" style="width: 42%;border: transparent;margin-left: 1px;"> <span>%</span> </td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_igst; }?>" class="ooigst ot_igst" id="ot_igst" name="ot_igst" onfocusout="sgstvalue3(this.value)" pattern="[0-9]+" style="width: 42%;border: transparent;margin-left: 1px;"> <span>%</span> </td> <td> <input type="text" value="<?php if(!empty($po_details)){echo round($po_details->ot_total_value); }?>" class="total_value_val to_val" id="total_value_val" name="total_value_val" style="width: 100%;border: transparent;" readonly> </td> <td> <input type="text" value="<?php if(!empty($po_details)){echo $po_details->otc_remarks; }?>" style="width: 100%;border: transparent;text-transform: uppercase !important;" class="otc_remarks" name="otc_remarks" id="remarks" style="width: 100%;border: transparent;"> </td> </tr> <tr> <td rowspan="3" colspan="9"> <textarea rows="3" id="note" name="note" style="width: 100%; border: transparent; margin-top: -15px;text-transform: uppercase !important;" placeholder="NOTE : " > <?php if(!empty($po_details)){echo $po_details->note; }?></textarea> </td> <td colspan="2">TOTAL AMOUNT</td> <td> <input type="text" class="total_amt" id="total_amt" value="<?php if(!empty($po_details)){echo round($po_details->total_amt); }?>" name="total_amt" style="width: 100%;border: transparent;" readonly="readonly" required onfocusin="amount_total1()"> </td> </tr> <tr> <td colspan="2">DISCOUNT %</td> <td> <input type="text" pattern="^\d*(\.\d{0,2})?$" class="discount" id="discount" name="discount" value="<?php if(!empty($po_details)){echo $po_details->discount; }?>" onkeyup="discountvalue(this.value)" pattern="^\d*(\.\d{0,2})?$" style="width: 74%;border: transparent;" required> <span>%</span> </td> </tr> <tr> <td colspan="2">GRAND TOTAL</td> <td> <input type="text" class="g_total" id="g_total" name="g_total" value="<?php if(!empty($po_details)){echo round($po_details->grand_total); }?>" style="width: 100%;border: transparent;" readonly="readonly" required> </td> </tr> <tr> <td colspan="12"> Terms and Conditions: <br/> 1. Material Delivery :<input type="text" class="comment" id="comment" value="<?php if(!empty($po_details)){echo $po_details->material_delivery; }?>" name="comment" style="width: 70%;border: transparent; text-transform: uppercase !important;" > <br/> 2. GST No. :<input type="text" class="gst_no" id="gst_no" name="gst_no" style="width: 70%;border: transparent; text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->gst_no; }?>" ><br/> 3. Terms of payment :<input type="text" class="terms_payment" id="terms_payment" name="terms_payment" style="width: 70%;border: transparent; text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->terms_of_payment; }?>" ><br/> 4. BANK DETAILS :<input type="text" class="bank_details" id="bank_details" name="bank_details" style="width: 70%;border: transparent; text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->bank_details; }?>" readonly> </td> </tr> </tbody> </table> <br/><br/> <button type="submit" class="btn center-block" style="float: left;margin-left: 39%;width: 100px;">Submit</button> <a href="<?php echo site_url('civil-purchase-order-list'); ?>" class="btn default" style=" width:8%;color: #876174; background:#dddddd !important;margin-left: 20px;">Cancel</a> </form> </div> <!-- page-content --> </div> <?php echo view('includes/footer');?> <script type="text/javascript"> $(document).ready(function() { $( "#vendor_name" ).autocomplete({ source: '<?php echo site_url("auto-complete-civil-vendor-name"); ?>', }); }); function vendor_myFunction(id) { var customer = id; $.ajax({ type : 'post', url : '<?php echo site_url("civil-vendor-search-by-fetch")?>', data : {id:id}, success:function(response) { // obj=jQuery.parseJSON(response); console.log(obj); if(obj.result == 1) { document.getElementById('address').value=obj.message.vendor_name+"\n"; document.getElementById('address').value+=obj.message.company_name+"\n"; document.getElementById('address').value+=obj.message.company_address+"\n"; document.getElementById('bank_details').value=' '+'A/c No. '+obj.message.account_no+"\n"; document.getElementById('bank_details').value+=','+obj.message.bank_name+"\n"; document.getElementById('bank_details').value+=','+obj.message.bank_address+"\n"; document.getElementById('bank_details').value+=','+obj.message.ifsc_coce+"\n"; } } }); } function unit_valuefirst(str,i) { var unit=str; var quantity_val =$('.quantityy'+i).val(); var inr_val = str * quantity_val; //alert(cgst); $('.inrvalue'+i).val(inr_val); var cgst =$('.ocgst'+i).val(); var sgst =$('.osgst'+i).val(); var igst =$('.oigst'+i).val(); var tax=parseFloat(cgst) + parseFloat(sgst)+ parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.totalvalue'+i).val(total); amount_total1(); } var total_vall=0; function gstvalue(str,i) { var n=0; var gst=str; var inr_val =$('.inr_value'+i).val(); //alert(inr_val); var total_val =(inr_val * gst)/100 ; $('.total_value'+i).val(parseFloat(total_val) + parseInt(inr_val)); var total_value11 = $('.total_value'+i).val(); total_vall= parseFloat(total_vall) + parseFloat(total_value11); //$('.total_amt').val(total_vall); amount_total1(); } function amount_total1() { var a=$(".to_val").val(); var b=$(".tot_val").val(); var tot_vals=[]; $('.tot_val').each(function () { tot_vals.push($(this).val()); }); var sum = 0; for(var i=0; i < tot_vals.length; i++){ sum += parseFloat(tot_vals[i]); } if(a=="") { $('.total_amt').val(parseFloat(sum).toFixed(2)); } else { var amnt=parseFloat(sum) + parseFloat(a); $('.total_amt').val(amnt.toFixed(2)); } } </script> <style type="text/css"> .thead-default{ background:#337ab7; color:white; } .table{ margin-bottom:0 !important; //width:auto !important; } th, td{ //border:1px solid gray; padding:6px; } .inner th{ border:transparent !important; } .inner tr{ border-bottom:1px solid gray; } table{ width:100%; } #ui-id-1 { display: none; width: 350px; top: 258px; overflow-x: hidden !important; overflow-y: scroll !important; height: 203px !important; } @media only screen and (min-width:320px) and (max-width:640px) { .page-content { width:900px; } .page-content-wrapper { overflow-x:scroll !important; } } </style> <script> var total_vall=0; </script> <script> function unitvalue1(str) { var unit=str; var quantity_val =$('#quantity_val').val(); var inr_val = str * quantity_val; $('.inr_value_val').val(inr_val); var cgst =$('.oocgst').val(); var sgst =$('.oosgst').val(); var igst =$('.ooigst').val(); var tax=parseFloat(cgst) + parseFloat(sgst) + parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.total_value_val').val(total); amount_total1(); } function gstvalue1(str,i) { var gst=str; var inr_val =$('.inrvalue'+i).val(); var cgst =$('.ocgst'+i).val(); var igst =$('.oigst'+i).val(); var sgst =$('.osgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); var total_inr = parseFloat(total) + parseFloat(inr_val); $('.totalvalue'+i).val(total_inr); amount_total1(); } function gstvalue2(str,i) { var inr_val =$('.inrvalue'+i).val(); var cgst =$('.ocgst'+i).val(); var igst =$('.oigst'+i).val(); var sgst =$('.osgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); var total_inr = parseFloat(total) + parseFloat(inr_val); $('.totalvalue'+i).val(total_inr); amount_total1(); } function gstvalue3(str,i) { var inr_val =$('.inrvalue'+i).val(); var cgst =$('.ocgst'+i).val(); var igst =$('.oigst'+i).val(); var sgst =$('.osgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); var total_inr = parseFloat(total) + parseFloat(inr_val); $('.totalvalue'+i).val(total_inr); amount_total1(); } function sgstvalue1(str) { var gst=str; var inr_val =$('.inr_value_val').val(); var cgst =$('.oocgst').val(); var igst =$('.ooigst').val(); var sgst =$('.oosgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); var total_inr = parseFloat(total) + parseFloat(inr_val); // alert(total_inr); $('.total_value_val').val(total_inr); amount_total1(); } function sgstvalue2(str) { var gst=str; var inr_val =$('.inr_value_val').val(); var sgst =$('.oosgst').val(); var igst =$('.ooigst').val(); var cgst =$('.oocgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); var total_inr = parseFloat(total) + parseFloat(inr_val); // alert(total_inr); $('.total_value_val').val(total_inr); amount_total1(); } function sgstvalue3(str) { var gst=str; var inr_val =$('.inr_value_val').val(); var sgst =$('.oosgst').val(); var igst =$('.ooigst').val(); var cgst =$('.oocgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); var total_inr = parseFloat(total) + parseFloat(inr_val); // alert(total_inr); $('.total_value_val').val(total_inr); amount_total1(); } var discount_total_value=0; function discountvalue(str) { var discount=str; var total_amt = $(".total_amt").val(); var mul_val =(discount * total_amt)/100; var discount_total_value= parseFloat(total_amt) - parseFloat(mul_val); $('.g_total').val(discount_total_value.toFixed(2)); } </script> <script type="text/javascript"> $('.work_po_form').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $(".submit_button").attr('disabled', 'disabled'); $(".submit_button").text("Submitting..."); $.ajax({ type : 'post', url : '<?php echo site_url("update-civil-purchase-order")?>', data : formdata, contentType: false, processData: false, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); setTimeout(function(){ window.location.href = "<?php echo site_url('civil-purchase-order-list');?>" }, 1500); } else if(response.result == 2) { toastr["error"](response.message); $(".submit_button").text("Submit"); $(".submit_button").removeAttr('disabled'); } else { toastr["error"](response.message); $(".submit_button").text("Submit"); $(".submit_button").removeAttr('disabled'); } } }); }); </script>