$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}");
}
}
}
}
if (isset($_GET[$PageKey])) {
$sql = "select * from elec_machine_maint where {$PageKey} = '" . $_GET[$PageKey] . "'";
$result = mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$PageKeyValue = $row[$PageKey];
$machine_maint_date = getDateFormate($row["machine_maint_date"]);
$details = $row["details"];
$department_id = $row['department_id'];
$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];
///////////////////////////////// Pending Quantity ///////////////////////
$sql_upd="update ms_indent_transaction set pend_qty=$pend_qty where indent_transaction_id=$indent_trans_id";
mysql_query ($sql_upd) or die (mysql_error());
///////////////////////////////// End ///////////////////////
$tableColumns=array("order_transaction_id","order_id","indent_transaction_id","item_id","po_qty","pend_qty","rate","disc_perc","duty_perc","ecess_perc","vat_perc","net_rate");
$tableData=array("'$order_trans_id'","'$PageKeyValue'","'$indent_trans_id'","'$item_id'","'$po_qty'","'$po_qty'","'$rate'","'$disc_perc'","'$duty_perc'","'$ecess_perc'","'$vat_perc'","'$net_rate'");
if(updateDataIntoTable("ms_order_transaction",$tableColumns,$tableData))
$Message = "$PageFor Updated";
}
}
//redirect("store_list_purchase_order.php?Message=$Message");
}
}
}
if(isset($_GET["order_id"]))
{
$order_id = $_GET["order_id"];
}
else
{
$sql="select max(order_id) as order_id from ms_order_master";
{
if($_POST['item_name'][$i]!='')
{
$RGP_trans_id=$_POST['RGP_trans_id'][$i];
$item_name=addslashes($_POST['item_name'][$i]);
$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");
}
}
}
}
}
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'");
updateDataIntoTable("maint_job",$tableColumns,$tableDataJob);
}
$Message = "$PageFor Updated";
}
}
$Message = "$PageFor Updated";
//redirect("maint_list_machines.php?Message=$Message");
}
}
}
?>
<?
if(isset($_GET["Message"]))
{
$Message = $_GET["Message"];
}
