if ($_POST['machine_maint_date'] == "") { $machine_maint_date = date("Y-m-d"); } else { $machine_maint_date = getDateFormate($_POST['machine_maint_date']); } $department_id = $_POST['department_id']; $machine_id = $_POST['machine_id']; $details = addslashes($_POST['details']); if ($department_id == '0' || $machine_id == '0') { $Message = "Error While Adding Or Updating."; echo "<script>alert('Department or Machine or Machine Not Selected.Please Select It!!!');location.href='elec_add_machine_maint.php?Message={$Message}';</script>"; } else { if ($PageKeyValue == "") { $tableName = "elec_machine_maint"; $tableData = array("''", "'{$machine_maint_date}'", "'{$department_id}'", "'{$machine_id}'", "'{$details}'", "now()"); addDataIntoTable($tableName, $tableData); //print_r($tableData); $Message = "{$PageFor} Inserted"; redirect("{$Page}?Message={$Message}"); } else { if ($mode == "edit") { $tableName = "elec_machine_maint"; $tableColumns = array("machine_maint_id", "machine_maint_date", "department_id", "machine_id", "details"); $tableData = array("'{$PageKeyValue}'", "'{$machine_maint_date}'", "'{$department_id}'", "'{$machine_id}'", "'{$details}'"); updateDataIntoTable($tableName, $tableColumns, $tableData); $Message = "{$PageFor} Updated"; redirect("elec_list_machine_maint.php?Message={$Message}"); } } } }
$department_id=$_POST['department_id'][$i]; $uom_id=$_POST['uom_id'][$i]; $remarks=$_POST['remarks'][$i]; $quantity=$_POST['quantity'][$i]; $pend_qty=$_POST['quantity'][$i]; $rate=$_POST['rate'][$i]; if($RGP_trans_id!="") { $tableData=array("'$RGP_trans_id'","'$PageKeyValue'","'$department_id'","'$item_name'","'$uom_id'","'$remarks'","'$quantity'","'$pend_qty'","'$rate'"); //print_r($tableData);echo "<br />"; updateDataIntoTable("ms_RGP_transaction",$tableColumns,$tableData); } else { $tableData=array("''","'$PageKeyValue'","'$department_id'","'$item_name'","'$uom_id'","'$remarks'","'$quantity'","'$pend_qty'","'$rate'","now()"); addDataIntoTable("ms_RGP_transaction",$tableData); } } } $Message = "$PageFor Updated"; redirect("store_list_RGP.php?Message=$Message"); } } } } if(isset($_GET["RGP_id"])){ $RGP_id = $_GET["RGP_id"]; }else{ $sql="select max(RGP_id) as RGP_id from ms_RGP_master"; $res=mysql_query($sql);
$NRGP_qty=$_POST['NRGP_qty'][$i]; $remain_qty=$_POST['remain_qty'][$i]; $rate=$_POST['rate'][$i]; ////////////////Item Update //////////// $res_S=mysql_query("select * from ms_item_master where item_id='".$item_id."'"); $row_S=mysql_fetch_array($res_S); $total=0; $total=(float)$row_S['closing_stock']-(float)$NRGP_qty; $sql_U="update ms_item_master set closing_stock='".$total."' where item_id='".$item_id."'"; mysql_query($sql_U); /////////GRN Update ////// $sql_U="update ms_GRN_transaction set NRGP_qty='".$remain_qty."' where GRN_transaction_id='".$GRN_trans_id."'"; mysql_query($sql_U); /////////////////////End Updates ////////// $tableData=array("''","'$insert_id'","'$GRN_trans_id'","'$item_id'","'$remarks'","'$NRGP_qty'","'$rate'","now()"); addDataIntoTable("ms_NRGP_GRN_transaction",$tableData); } } $Message = "$PageFor Inserted"; redirect("$Page?Message=$Message"); } } else { if($mode == "edit") { $tableName="ms_NRGP_master"; $tableColumns=array("$PageKey","NRGP_date","supplier_id","ref_quot_no","ref_quot_date","despatch_through","special_instr"); $tableData=array("'$PageKeyValue'","'$NRGP_date'","'$supplier_id'","'$ref_quot_no'","'$ref_quot_date'","'$despatch_through'","'$special_instr'"); if(updateDataIntoTable($tableName,$tableColumns,$tableData)) {
$indent_trans_id=$_POST['indent_trans_id'][$i]; $item_id=$_POST['item_id'][$i]; $po_qty=$_POST['po_qty'][$i]; $pend_qty=$_POST['pend_qty'][$i]; $rate=$_POST['rate'][$i]; $disc_perc=$_POST['disc_perc'][$i]; $duty_perc=$_POST['duty_perc'][$i]; $ecess_perc=$_POST['ecess_perc'][$i]; $vat_perc=$_POST['vat_perc'][$i]; $net_rate=$_POST['net_rate'][$i]; //////////////Update Quantity /////////////// $sql_upd="update ms_indent_transaction set pend_qty=$pend_qty where indent_transaction_id=$indent_trans_id"; mysql_query($sql_upd); //////////////////////////////////////////// $tableData=array("''","'$order_id'","'$indent_trans_id'","'$item_id'","'$po_qty'","'$po_qty'","'$rate'","'$disc_perc'","'$duty_perc'","'$ecess_perc'","'$vat_perc'","'$net_rate'","now()"); if(addDataIntoTable("ms_order_transaction",$tableData)) $Message = "$PageFor Inserted"; } redirect("$Page?Message=$Message"); } } else { if($mode == "edit") { $tableName="ms_order_master"; $tableColumns=array("order_id","order_date","po_type_id","supplier_id","indent_id","tc_billing_address","tc_delivery_address","tc_payment_terms","tc_delivery","tc_delivery_date","tc_errection","tc_freight","tc_excise_and_taxes","tc_p_and_f","tc_remarks","gross_amt_total","disc_amt_total","duty_amt_total","vat_amt_total","ecess_amt_total","pf_after_before_amount","round_off_amount","total_amount","net_amount "); $tableData=array("'$PageKeyValue'","'$order_date'","'$po_type_select'","'$supplier_id'","'$indent_id'","'$tc_billing_address'","'$tc_delivery_address'","'$tc_payment_terms'","'$tc_delivery'","'$tc_delivery_date'","'$tc_errection'","'$tc_freight'","'$tc_excise_and_taxes'","'$tc_p_and_f'","'$tc_remarks'","'$cal_gross_amt'","'$cal_disc_amt'","'$cal_duty_amount'","'$cal_vat_amt'","'$cal_ecess_amt'","'$cal_pack_fowd_amt'","'$cal_round_off'","'$cal_total_amt'","'$cal_net_amt'"); //print_r($tableData);echo "<br />"; if(updateDataIntoTable($tableName,$tableColumns,$tableData))
$sch_date= date("Y-m-d", mktime(0, 0, 0,$da[1] ,$da[2]+$duration , $da[0])); $tableName="maint_machine_transaction"; if($machine_transaction_id=="") { $tableData=array("''","'$PageKeyValue'","'$service_id'","'$maint_date'","'$sch_date'","now()"); //print_r($tableData); addDataIntoTable($tableName,$tableData); $machine_tr_id=mysql_insert_id(); $res_j=mysql_query("select max(job_code) as job_code from maint_job"); $row_j=mysql_fetch_array($res_j); $jc=$row_j['job_code']+1; //echo $jc." : ".$service_id." : ".$PageKeyValue." : ".$sch_date." : ".$maint_date."<br>";; $tableDataJob=array("''","'$jc'","'$service_id'","'$PageKeyValue'","'P'","'$sch_date'","'$maint_date'","''","''","now()"); addDataIntoTable("maint_job",$tableDataJob); } else { //$machine_transaction_id.'<br />'; $tableData=array("''","'$PageKeyValue'","'$service_id'","'$maint_date'","'$sch_date'","now()"); //print_r($tableData); $tableColumns=array("machine_transaction_id","machine_id","service_id","maint_date","schedule_date"); $tableData=array("'$machine_transaction_id'","'$machine_code'","'$service_id'","'$maint_date'","'$sch_date'"); updateDataIntoTable($tableName,$tableColumns,$tableData); $job_id=$_POST['job_id'][$i]; $tableColumns=array("job_id","service_id","machine_id","schedule_date","maint_date"); //echo $jc." : ".$service_id." : ".$PageKeyValue." : ".$sch_date." : ".$maint_date."<br>";; $tableDataJob=array("'$job_id'","'$service_id'","'$machine_code'","'$sch_date'","'$maint_date'");