----->".$name.$k;
$Type = "Item".$k."_Type"; $name[$k][2] = $_POST[$Type]; // echo "**".$Type; $Type = $_POST[$Type]; echo "`".$Type."*";
$nameQty = "Item".$k."_Qty"; $name[$k][3] = $_POST[$nameQty];
$nameQty_Unit = "Item".$k."_QtyUnit"; $name[$k][10] = $_POST[$nameQty_Unit];
$namePrice = "Item".$k."_Price"; $name[$k][4] = $_POST[$namePrice];
$nameDisc = "Item".$k."_Discount"; $name[$k][5] = $_POST[$nameDisc]; //
$nameOC = "Item".$k."_OthCharges"; $name[$k][6] = $_POST[$nameOC]; //echo $nameOC; echo "
";
$nameGST = "Item".$k."_GST"; $name[$k][9] = $_POST[$nameGST]; //echo $nameOC; echo "
";
$nameFP = "Item".$k."_FPrice"; $name[$k][7] = $_POST[$nameFP];
$DiscCheck = "ch".$k; $name[$k][8] = $_POST[$DiscCheck];
$i++;
}
echo "
----->";
print_r($name); echo "
----->".$Stock_Cnt;
//echo $name;
$OC_Name = $_POST["OC_Name"];
$OtherCharges = $_POST["OtherCharges"];
$Installation_Date = $_POST["Installation_Date"]; //$InstallationDate = date('Y-m-d',strtotime($Installation_Date));
$PerDiscount = $_POST["Discount"];
$BillDiscount = $_POST["BillDiscount"];
$Bill_Total = $_POST["Bill_Total"];
$FirmName = $_POST["FirmName"];
if($Installation_Date == '1970-01-01') $Installation_Date = "";
if($PODate == '1970-01-01') $PODate = "";
if($OrderDate == '1970-01-01') $OrderDate = "";
if (isset($Bill_No) && isset($Bill_Date) && isset($qty) && isset($Bill_Total) && isset($FirmName))
{
// print_r($_POST);
$Fdate = date("Y-m-d");
$Tag = "0";
$ExhbtNWCount = $ExhbtCount-$ExhbtWCount;
$qry5 = "SELECT * from FRegCnt where `TypeCode` = 'Cm'"; echo $qry5;
$result5 = mysql_db_query("ScpFinance", $qry5) or die ("could not query" . mysql_error());
while ($re5 = mysql_fetch_array($result5)) { $ConsumablePtr = $re5["Ptr"]; }
$ConsumablePtr++;
//---------------------------------------------------------------- INSERT INTO REGISTER MASTER _____________________________________________________
$qry3 = "SELECT * from RegisterCnt"; echo $qry3;
$result3 = mysql_db_query("ScpFinance", $qry3) or die ("could not query" . mysql_error());
while ($re3 = mysql_fetch_array($result3))
{
$RegisterName = $re3["RegisterName"];
$RegCnt = $re3["RegCnt"]; echo $RegCnt;
}
$RegCnt++; $NewCnt = str_pad($RegCnt, 3, "0", STR_PAD_LEFT); $UID = $RegisterName.$NewCnt;
$query0 = "INSERT INTO RegisterMaster VALUES
('$UID','$Bill_No','$BillDate', '$Order_No', '$OrderDate','$PO_No', '$PODate', '$qty', '$InclGST', '$Incl_GSTNo', '$OC_Name','$OtherCharges','$PerDiscount', '$BillDiscount', '$Bill_Total', '$FirmName','SCP', '$Installation_Date','','GRANTNAME','A', '$Fdate')"; //echo "
".$query0 ;
$result5 = mysql_db_query("ScpFinance", $query0) or die ("could not connect to database->".mysql_error());
$tung5=mysql_affected_rows();
if($tung5 != 0)
{
$query10 = "UPDATE RegisterCnt set `RegCnt`='$RegCnt'";
$result10 = mysql_db_query("ScpFinance", $query10) or die ("could not query" . mysql_error());
$tung10=mysql_affected_rows();
//-------------------------------------------- Stock No Allocation ---------------------------------------------------------------------------------
$Stock_No = 0;
for($k=1;$k<=$qty;$k++)
{
//
if($InclGST == "Yes") { $GST = $Incl_GSTNo; } else { $GST = $name[$k][9]; }
$val = $name[$k][4];
if($name[$k][8] == "on" )
{
$Per = ($name[$k][3]*$name[$k][4]*$name[$k][5])/100; //echo "
".$Per."
";
$DisPer = $name[$k][5];
}
else
{ $val2 = $val - $name[$k][5];
$Per=$name[$k][5];
$DisPer = '0'; // No % Disc so 0
}
echo $DisPer."---".$Per."
";
if($name[$k][2] == "Ct")
{
$IndPrice = $name[$k][7] / $name[$k][3];
$qry5 = "SELECT * from FRegCnt where `TypeCode` = 'Ct'"; //echo $qry5;
$result5 = mysql_db_query("ScpFinance", $qry5) or die ("could not query" . mysql_error());
while ($re5 = mysql_fetch_array($result5))
{
$TypeCode = $re5["TypeCode"];
$CCBType = $re5["CCBType"]; //echo $CCBType;
$SNumber = $re5["SNumber"]; //echo $SNumber;
$Ptr = $re5["Ptr"]; //echo $Ptr;
}
// $name[$k][3] has Capital Qty
$Ptr++; $NStock = $Ptr+($name[$k][3]-1); if($name[$k][3] > 1) { $Stock_No = $Ptr."-".$NStock; } else { $Stock_No = $NStock; }
$query5 = "INSERT INTO Capitals VALUES ('$UID','$Stock_No','".$name[$k][1]."','".$name[$k][3]."','".$name[$k][10]."','".$name[$k][4]."', '$DisPer','$Per', '".$name[$k][6]."','$GST','".$name[$k][7]."','$Installation_Date','A')"; echo "
".$query5 ;
$result5 = mysql_db_query("ScpFinance", $query5) or die ("could not connect to database".mysql_error());
$tung5=mysql_affected_rows();
$query7 = "UPDATE FRegCnt set `Ptr`='$NStock' where `TypeCode` = 'Ct'";
$result7 = mysql_db_query("ScpFinance", $query7) or die ("could not query" . mysql_error());
$tung7=mysql_affected_rows();
}
//-------------------------------------------------------------------------------------------------------------------------------------------------------------------
// CONSUMABLES INSERTION
//-------------------------------------------------------------------------------------------------------------------------------------------------------------------
if($name[$k][2] == "Cm")
{
$query6 = "INSERT INTO Consumables VALUES
('','$UID','$ConsumablePtr','".$name[$k][1]."','".$name[$k][3]."','".$name[$k][10]."','".$name[$k][4]."','$DisPer','$Per', '".$name[$k][6]."','$GST','".$name[$k][7]."', '$Installation_Date','A')";
echo "
".$query6 ;
$result6 = mysql_db_query("ScpFinance", $query6) or die ("could not connect to database".mysql_error());
$tung6=mysql_affected_rows();
$query8 = "UPDATE FRegCnt set `Ptr`='$ConsumablePtr' where `TypeCode` = 'Cm'";
$result8 = mysql_db_query("ScpFinance", $query8) or die ("could not query" . mysql_error());
$tung8=mysql_affected_rows();
}
}
}
//-------------------------------------------------------------------------------------------------------------------------------------------------------------------
$_SESSION['UID']= $UID;
header( 'Location: ShowBill.php' ) ;
}
else echo "Error found!!! Please fill the form correctly";
} //else close
}
else
{
$formValues = $_POST; $formErrors = array();
DisplayForm($formValues, $formErrors);
}//echo $_POST["a_addr1"]; }//} ////////$_SESSIOM['H_HCBL'] = $H_HCBL;
}
else
{
DisplayForm(null, null); //echo "here1"; //
}
}
}
else
{
header( 'Location: ../Access_Denied.html' ) ;
}
?>