= 4){
$fyear=$yr+1;
$combine = $yr.$fyear;
} else {
$fyear=$yr-1;
$combine = $fyear.$yr;
}
$prefix = $conn->query('SELECT Prefix from branches where BranchId="'.$_SESSION['branchid'].'"');
while($pref = mysqli_fetch_array($prefix)) {
$pre = $pref[0];
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($_POST['act'] == 'GET_STOCK')
{
if ($_POST['Branch'] == '' || $_POST['Product'] == '') { // product code
echo "You must enter all fields";
}
else{
//$result = $conn->query('SELECT CurrentStock FROM stock S,products P WHERE BranchId="'.$_POST['Branch'].'" and P.ProdCode="'.$_POST['Product'].'" and P.ProdId=S.ProdId');
$result = $conn->query('SELECT CurrentStock FROM stock S,products P WHERE BranchId="'.$_POST['Branch'].'" and P.Prodname="'.$_POST['Product'].'" and P.ProdId=S.ProdId');
if($result->num_rows==1) {
$row = mysqli_fetch_row($result);
echo $row[0];
}
else
echo '0';
}
}
if ($_POST['act'] == 'GET_TAX')
{
if ($_POST['Product'] == '' ) { // product code
echo "0";
}
else{
//$result = $conn->query('SELECT CGST+UT_SGST as GST FROM tax T,products P WHERE P.HSNcode=T.HSNcode and P.ProdCode="'.$_POST['Product'].'"');
$result = $conn->query('SELECT CGST+UT_SGST as GST FROM tax T,products P WHERE P.HSNcode=T.HSNcode and P.Prodname="'.$_POST['Product'].'"');
if($result->num_rows==1) {
$row = mysqli_fetch_row($result);
echo $row[0];
}
else
echo '0';
}
}
if ($_POST['act'] == 'GET_PNAME')
{
if ($_POST['Product'] == '' ) { // product code
echo "UNKNOWN";
}
else{
$result = $conn->query('SELECT Prodname FROM products WHERE ProdCode="'.$_POST['Product'].'"');
if($result->num_rows==1) {
$row = mysqli_fetch_row($result);
echo $row[0];
}
else
echo "UNKNOWN";
}
}
if ($_POST['act'] == 'ADD_PO')
{
if ($_POST['OrderDate'] == '' || $_POST['Branch'] == '' || $_POST['PlanDelDate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' ) { // product code
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$queryi="INSERT INTO po(OrderDate, Branch, Supplier, PlanDelDate, Products, Costvalue, Discount, Grossamount, Taxamount, DeliveryCharges, Netamount, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$_POST["OrderDate"]."','".$_POST["Branch"]."','SIDDHA FOODS TECH','".$_POST["PlanDelDate"]."','".$_POST["lop"]."','".$_POST["Costvalue"]."','".$_POST["Discount"]."','".$_POST["Grossamount"]."','".$_POST["Taxamount"]."','".$_POST["DeliveryCharges"]."','".$_POST["Netamount"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
//echo $queryi;
if ($conn->query($queryi))
{
//get grn number
$result = $conn->query("SELECT Max(GRNNo) from grn where CreatedBy=".$_SESSION["uid"]);
$row = mysqli_fetch_row($result);
$grnno=$row[0];
echo ';';
}
else
echo '';
}
}
if ($_POST['act'] == 'ORDER_PO' || $_POST['act'] == 'CANCEL_PO')
{
if ($_POST['poid'] == '' ) {
echo "You must enter all fields";
}
else {
if($_POST['act'] == 'ORDER_PO')
$Status=2;
else
$Status=4;
$queryu="UPDATE po SET Status=".$Status.", UpdatedBy=".$_SESSION["uid"].", UpdatedOn='".$date."' WHERE PONO = '".$_POST['poid']."'";
//echo $queryu;
if ($conn->query($queryu))
echo '1';
else
echo '0';
}
}
if ($_POST['act'] == 'ADD_GRN')
{
if ($_POST['InvoiceNo'] == '' || $_POST['InvoiceDate'] == '' || $_POST['PONO'] == '' || $_POST['Branch'] == '' || $_POST['ActualDelDate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '' ) {
echo "You must enter all fields";
}
else{
$result0 = $conn->query("SELECT GNo from grn where CreatedBy=".$_SESSION["uid"]);
if($result0->num_rows>=0){
$result1 = $conn->query("SELECT GNo, Max(GRNNo) from grn where Branch='".$_SESSION["branchid"]."' GROUP BY GNo ORDER by GRNNo DESC");
$row = mysqli_fetch_row($result1);
$InvNo=$row[0];
//$maxyear = substr($InvNo, 0, $InvNo < 0 ? 3 : 4);
$maxyear = substr($InvNo, 3, $InvNo < 0 ? 3 : 4);
$num = substr($InvNo, 8, $InvNo < 0 ? 5 : 6);
if (($num == 0)||($num == ''))
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
else
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
}
$gpre = "G";
$InvCombine =$gpre . $pre . $combine . '-' . $NewInvNo;
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$queryi="INSERT INTO grn(GNo,InvoiceNo,InvoiceDate,PONO, Branch, Supplier, ActualDelDate, Products, Costvalue, Discount, Grossamount, Taxamount, DeliveryCharges, Netamount,PayType,PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$InvCombine."','".$_POST["InvoiceNo"]."','".$_POST["InvoiceDate"]."','".$_POST["PONO"]."','".$_POST["Branch"]."','SIDDHA FOODS TECH','".$_POST["ActualDelDate"]."','".$_POST["lop"]."','".$_POST["Costvalue"]."','".$_POST["Discount"]."','".$_POST["Grossamount"]."','".$_POST["Taxamount"]."','".$_POST["DeliveryCharges"]."','".$_POST["Netamount"]."','".$_POST["PayType"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
//echo $queryi;
if ($conn->query($queryi))
{
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//add/update stocks
$Qty=$arr[$i]->Qty-($arr[$i]->Def+$arr[$i]->Miss);
$result = $conn->query("SELECT count(*) as Count from stock where BranchId=".$_POST['Branch']." and ProdId=".$ProdId);
$row = mysqli_fetch_row($result);
if($row[0]==0) //add
{
$queryu1="INSERT into stock(BranchId,ProdId,CurrentStock,ReorderLevel,LastUpdatedOn) values (".$_POST['Branch'].",".$ProdId.",".$Qty.",10,'".$date."')";
}
else //update
{
$queryu1="UPDATE stock SET CurrentStock=CurrentStock+".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
}
//echo $queryu1."\n";
$conn->query($queryu1);
//add/update stock details
$result = $conn->query("SELECT count(*) as Count from stock_detail where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'");
$row = mysqli_fetch_row($result);
if($row[0]==0) //add
{
$queryu2="INSERT INTO stock_detail(BranchId, ProdId, Batch, Exp, CurrentStock, LastUpdatedOn) VALUES (".$_POST['Branch'].",".$ProdId.",'".$arr[$i]->Batch."','".$arr[$i]->Exp."',".$Qty.",'".$date."')";
}
else //update
{
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock+".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
}
$conn->query($queryu2);
}
//TODO:add defect & missing in returns
//update PO Status
$conn->query("UPDATE po set status=3 , UpdatedBy=".$_SESSION["uid"].", S.LastUpdatedOn='".$date."' where PONO='".$_POST['PONO']."'");
$conn->query("UPDATE grndrafts set status=1 , UpdatedBy=".$_SESSION["uid"].", UpdatedOn='".$date."' where GRNNo='".$_POST['grnnum']."'");
echo '';
}
else
echo '';
}
}
if ($_POST['act'] == 'EDIT_GRN')
{
if ($_POST['InvoiceNo'] == '' || $_POST['InvoiceDate'] == '' || $_POST['PONO'] == '' || $_POST['Branch'] == '' || $_POST['ActualDelDate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '' ) {
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$queryi="UPDATE grn SET Products='".$_POST["lop"]."', Costvalue='".$_POST["Costvalue"]."', Grossamount='".$_POST["Grossamount"]."', Taxamount='".$_POST["Taxamount"]."', Netamount='".$_POST["Netamount"]."', UpdatedBy=".$_SESSION["uid"].", UpdatedOn='".$date."' WHERE GNo='".$_POST["grnnum"]."'";
//echo $queryi;
if ($conn->query($queryi))
{
$grnno = $_POST["grnnum"];
echo '';
}
else
echo '';
}
}
if ($_POST['act'] == 'ADD_GRNDRAFTS')
{
if ($_POST['InvoiceNo'] == '' || $_POST['InvoiceDate'] == '' || $_POST['PONO'] == '' || $_POST['Branch'] == '' || $_POST['ActualDelDate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '' ) {
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$queryi="INSERT INTO grndrafts(InvoiceNo,InvoiceDate,PONO, Branch, Supplier, ActualDelDate, Products, Costvalue, Discount, Grossamount, Taxamount, DeliveryCharges, Netamount,PayType,PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$_POST["InvoiceNo"]."','".$_POST["InvoiceDate"]."','".$_POST["PONO"]."','".$_POST["Branch"]."','SIDDHA FOODS TECH','".$_POST["ActualDelDate"]."','".$_POST["lop"]."','".$_POST["Costvalue"]."','".$_POST["Discount"]."','".$_POST["Grossamount"]."','".$_POST["Taxamount"]."','".$_POST["DeliveryCharges"]."','".$_POST["Netamount"]."','".$_POST["PayType"]."','".$_POST["lopi"]."','".$_POST["Note"]."',0,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
//echo $queryi;
if ($conn->query($queryi))
{
//get grndrafts number
$result = $conn->query("SELECT Max(GRNNo) from grndrafts where CreatedBy=".$_SESSION["uid"]);
$row = mysqli_fetch_row($result);
$grnno=$row[0];
$arr = json_decode($_POST['lop'], false);
echo '';
}
else
echo '';
}
}
if ($_POST['act'] == 'EDIT_GRNDRAFTS')
{
if ($_POST['InvoiceNo'] == '' || $_POST['InvoiceDate'] == '' || $_POST['PONO'] == '' || $_POST['Branch'] == '' || $_POST['ActualDelDate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '' ) {
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$queryi="UPDATE grndrafts SET Products='".$_POST["lop"]."', Costvalue='".$_POST["Costvalue"]."', Grossamount='".$_POST["Grossamount"]."', Taxamount='".$_POST["Taxamount"]."', Netamount='".$_POST["Netamount"]."', UpdatedBy=".$_SESSION["uid"].", UpdatedOn='".$date."' WHERE GRNNo='".$_POST["grnnum"]."'";
//echo $queryi;
if ($conn->query($queryi))
{
$grnno = $_POST["grnnum"];
//echo '';
echo '';
}
else
echo '';
}
}
if ($_POST['act'] == 'GET_PRICE')
{
if ($_POST['Product'] == '' || $_POST['Type']=='' ) { // product code & bill type
echo "-1";
}
else{
//$result = $conn->query("SELECT Customer, Member, Dealer, CostPrice, MRP FROM price T,products P WHERE P.ProdId=T.ProdId and P.ProdCode='".$_POST['Product']."' and (BranchId=".$_SESSION["branchid"]." or BranchId=0) order by BranchId desc limit 1");
$result = $conn->query("SELECT Postal,Courier,Imai,FreeMedicineMD,Amazon,Flipkart,DeliveryByPerson, Customer,Patient,Member,Dealer,10Discount, 20Discount, 50Discount, 100Discount,CostPrice, MRP FROM price T,products P WHERE P.ProdId=T.ProdId and P.Prodname='".$_POST['Product']."' and (BranchId=".$_SESSION["branchid"]." or BranchId=0) order by BranchId desc limit 1");
if($result->num_rows==1) {
$row = mysqli_fetch_array($result,MYSQLI_BOTH);
if($_POST['Type']==5) // B2B
echo $row[14].",".$row[15];
else
echo $row[$_POST['Type']];
}
else
echo '-1';
}
}
if ($_POST['act'] == 'GET_B2B_DETAIL')
{
if ($_POST['Name'] == '') { // product code & bill type
echo "You must enter all fields";
}
else{
$result = $conn->query("SELECT name, mobile,gst_num FROM vendors WHERE name='".$_POST['Name']."'");
if($result->num_rows>0) {
$obj=array();
while($row = mysqli_fetch_row($result)) {
array_push($obj,array($row[1],$row[2]));
}
echo(json_encode($obj));
}
else
echo '0';
}
}
if ($_POST['act'] == 'GET_OM_B2B_DETAIL')
{
if ($_POST['Name'] == '') { // product code & bill type
echo "You must enter all fields";
}
else{
$result = $conn->query("SELECT name, mobile,gst_num FROM shoppers WHERE name='".$_POST['Name']."'");
if($result->num_rows>0) {
$obj=array();
while($row = mysqli_fetch_row($result)) {
array_push($obj,array($row[1],$row[2]));
}
echo(json_encode($obj));
}
else
echo '0';
}
}
if ($_POST['act'] == 'ADD_BILL')
{
if ($_POST['BillType'] == '' || $_POST['Branch'] == '' || $_POST['Name'] == '' || $_POST['lop'] == '' || $_POST['Discount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['Paymode'] == '' || $_POST['lopt'] == '' || $_POST['lopi'] == '' ) {
echo "You must enter all fields";
}
else{
$result0 = $conn->query("SELECT InvNo from bills where CreatedBy=".$_SESSION["uid"]);
if($result0->num_rows>=0){
$result1 = $conn->query("SELECT InvNo from bills where Branch='".$_SESSION["branchid"]."' AND BillNo=(SELECT Max(BillNo) from bills)");
$row = mysqli_fetch_row($result1);
$InvNo=$row[0];
//$maxyear = substr($InvNo, 0, $InvNo < 0 ? 3 : 4);
$maxyear = substr($InvNo, 2, $InvNo < 0 ? 3 : 4);
$num = substr($InvNo, 7, $InvNo < 0 ? 5 : 6);
if (($num == 0)||($num == ''))
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
else
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
}
$InvCombine =$pre . $combine . '-' . $NewInvNo;
//$InvCombine =$combine . '-' . $NewInvNo;
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["NetDeliveryCharges"]=($_POST["NetDeliveryCharges"]==''? 0:$_POST["NetDeliveryCharges"]);
$_POST["Age"]=($_POST["Age"]==''? 0:$_POST["Age"]);
$_POST["Gender"]=($_POST["Gender"]==''? 0:$_POST["Gender"]);
$_POST["Settleamount"]=($_POST["Settleamount"]==''? 0:$_POST["Settleamount"]);
$_POST["BalanceAmt"]=($_POST["BalanceAmt"]==''? 0:$_POST["BalanceAmt"]);
$_POST["settleType"]=($_POST["settleType"]==''? '':$_POST["settleType"]);
$queryi="INSERT INTO bills(InvNo, BillDate, BillType, TypeId, Branch, Referer, Name, Mobile, Age, Gender, Products, Discount, DisRemark, DeliveryCharges,Taxoncharges, Taxamount, Totalamount,Settleamount,BalanceAmt,settleType,Paymode, PayType, PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$InvCombine."', '".$date."','".$_POST["BillType"]."','".$_POST["TypeId"]."','".$_POST["Branch"]."','".$_POST["Referer"]."','".$_POST["Name"]."','".$_POST["Mobile"]."','".$_POST["Age"]."','".$_POST["Gender"]."','".$_POST["lop"]."','".$_POST["Discount"]."','".$_POST["DisRemark"]."','".$_POST["DeliveryCharges"]."','".$_POST["NetDeliveryCharges"]."','".$_POST["Taxamount"]."','".$_POST["Netamount"]."','".$_POST["Settleamount"]."','".$_POST["BalanceAmt"]."','".$_POST["settleType"]."','".$_POST["Paymode"]."','".$_POST["lopt"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
//echo $queryi;
if ($conn->query($queryi))
{
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty;
$queryu1="UPDATE stock SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
echo '';
}
else
echo '';
}
}
if ($_POST['act'] == 'ADD_B2B_BILL')
{
if ($_POST['BillType'] == '' || $_POST['Branch'] == '' || $_POST['Name'] == '' || $_POST['lop'] == '' || $_POST['Discount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['Paymode'] == '' || $_POST['lopt'] == '' || $_POST['lopi'] == '' ) {
echo "You must enter all fields";
}
else{
$result0 = $conn->query("SELECT InvNo from bills where CreatedBy=".$_SESSION["uid"]);
if($result0->num_rows>=0){
$result1 = $conn->query("SELECT InvNo, Max(BillNo) from bills where Branch='".$_SESSION["branchid"]."' GROUP BY InvNo ORDER by BillNo DESC");
$row = mysqli_fetch_row($result1);
$InvNo=$row[0];
//$maxyear = substr($InvNo, 0, $InvNo < 0 ? 3 : 4);
$maxyear = substr($InvNo, 2, $InvNo < 0 ? 3 : 4);
$num = substr($InvNo, 7, $InvNo < 0 ? 5 : 6);
if (($num == 0)||($num == ''))
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
else
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
}
$InvCombine =$pre . $combine . '-' . $NewInvNo;
//$InvCombine =$combine . '-' . $NewInvNo;
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["NetDeliveryCharges"]=($_POST["NetDeliveryCharges"]==''? 0:$_POST["NetDeliveryCharges"]);
$_POST["Age"]=($_POST["Age"]==''? 0:$_POST["Age"]);
$_POST["Gender"]=($_POST["Gender"]==''? 0:$_POST["Gender"]);
$_POST["Settleamount"]=($_POST["Settleamount"]==''? 0:$_POST["Settleamount"]);
$_POST["BalanceAmt"]=($_POST["BalanceAmt"]==''? 0:$_POST["BalanceAmt"]);
$_POST["settleType"]=($_POST["settleType"]==''? '':$_POST["settleType"]);
$queryi="INSERT INTO bills(InvNo, BillDate, BillType, TypeId, Branch, Referer, Name, Mobile, Age, Gender, Products, Discount, DisRemark, DeliveryCharges,Taxoncharges, Taxamount, Totalamount,Settleamount,BalanceAmt,settleType,Paymode, PayType, PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$InvCombine."', '".$date."','".$_POST["BillType"]."','".$_POST["TypeId"]."','".$_POST["Branch"]."','".$_POST["Referer"]."','".$_POST["Name"]."','".$_POST["Mobile"]."','".$_POST["Age"]."','".$_POST["Gender"]."','".$_POST["lop"]."','".$_POST["Discount"]."','".$_POST["DisRemark"]."','".$_POST["DeliveryCharges"]."','".$_POST["NetDeliveryCharges"]."','".$_POST["Taxamount"]."','".$_POST["Netamount"]."','".$_POST["Settleamount"]."','".$_POST["BalanceAmt"]."','".$_POST["settleType"]."','".$_POST["Paymode"]."','".$_POST["lopt"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
$Name=$_POST["Name"];
//echo $queryi;
if ($conn->query($queryi))
{
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty;
$queryu1="UPDATE stock SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
if($_POST["BillType"]=='Imai'){
echo '';
} else {
echo '';
}
}
else
echo '';
}
}
if ($_POST['act'] == 'ADD_OM_B2B_BILL')
{
if ($_POST['BillType'] == '' || $_POST['Branch'] == '' || $_POST['Name'] == '' || $_POST['lop'] == '' || $_POST['Discount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['Paymode'] == '' || $_POST['lopt'] == '' || $_POST['lopi'] == '' ) {
echo "You must enter all fields";
}
else{
$result0 = $conn->query("SELECT InvNo from bills where CreatedBy=".$_SESSION["uid"]);
if($result0->num_rows>=0){
$result1 = $conn->query("SELECT InvNo, Max(BillNo) from bills where Branch='".$_SESSION["branchid"]."' GROUP BY InvNo ORDER by BillNo DESC");
$row = mysqli_fetch_row($result1);
$InvNo=$row[0];
//$maxyear = substr($InvNo, 0, $InvNo < 0 ? 3 : 4);
$maxyear = substr($InvNo, 2, $InvNo < 0 ? 3 : 4);
$num = substr($InvNo, 7, $InvNo < 0 ? 5 : 6);
if (($num == 0)||($num == ''))
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
else
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 5, "0", STR_PAD_LEFT);
}
}
}
$InvCombine =$pre . $combine . '-' . $NewInvNo;
//$InvCombine =$combine . '-' . $NewInvNo;
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["NetDeliveryCharges"]=($_POST["NetDeliveryCharges"]==''? 0:$_POST["NetDeliveryCharges"]);
$_POST["Age"]=($_POST["Age"]==''? 0:$_POST["Age"]);
$_POST["Gender"]=($_POST["Gender"]==''? 0:$_POST["Gender"]);
$_POST["Settleamount"]=($_POST["Settleamount"]==''? 0:$_POST["Settleamount"]);
$_POST["BalanceAmt"]=($_POST["BalanceAmt"]==''? 0:$_POST["BalanceAmt"]);
$_POST["settleType"]=($_POST["settleType"]==''? '':$_POST["settleType"]);
$queryi="INSERT INTO bills(InvNo, BillDate, BillType, TypeId, Branch, Referer, Name, Mobile, Age, Gender, Products, Discount, DisRemark, DeliveryCharges,Taxoncharges, Taxamount, Totalamount,Settleamount,BalanceAmt,settleType,Paymode, PayType, PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$InvCombine."', '".$date."','".$_POST["BillType"]."','".$_POST["TypeId"]."','".$_POST["Branch"]."','".$_POST["Referer"]."','".$_POST["Name"]."','".$_POST["Mobile"]."','".$_POST["Age"]."','".$_POST["Gender"]."','".$_POST["lop"]."','".$_POST["Discount"]."','".$_POST["DisRemark"]."','".$_POST["DeliveryCharges"]."','".$_POST["NetDeliveryCharges"]."','".$_POST["Taxamount"]."','".$_POST["Netamount"]."','".$_POST["Settleamount"]."','".$_POST["BalanceAmt"]."','".$_POST["settleType"]."','".$_POST["Paymode"]."','".$_POST["lopt"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
$Name=$_POST["Name"];
//echo $queryi;
if ($conn->query($queryi))
{
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty;
$queryu1="UPDATE stock SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
if($_POST["BillType"]=='Imai'){
echo '';
} else {
echo '';
}
}
else
echo '';
}
}
if ($_POST['act'] == 'EDIT_BILL')
{
if ($_POST['BillType'] == '' || $_POST['Branch'] == '' || $_POST['Name'] == '' || $_POST['lop'] == '' || $_POST['Discount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['Paymode'] == '' || $_POST['lopt'] == '' || $_POST['lopi'] == '' ) {
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["NetDeliveryCharges"]=($_POST["NetDeliveryCharges"]==''? 0:$_POST["NetDeliveryCharges"]);
$_POST["Age"]=($_POST["Age"]==''? 0:$_POST["Age"]);
$_POST["Gender"]=($_POST["Gender"]==''? 0:$_POST["Gender"]);
$queryi="UPDATE bills SET BillType='".$_POST["BillType"]."', TypeId='".$_POST["TypeId"]."', Referer='".$_POST["Referer"]."', Name='".$_POST["Name"]."', Mobile='".$_POST["Mobile"]."', Age='".$_POST["Age"]."', Gender='".$_POST["Gender"]."', Products='".$_POST["lop"]."', Discount='".$_POST["Discount"]."', DeliveryCharges='".$_POST["DeliveryCharges"]."', Taxoncharges='".$_POST["NetDeliveryCharges"]."', Taxamount='".$_POST["Taxamount"]."', Totalamount='".$_POST["Netamount"]."', Paymode='".$_POST["Paymode"]."', PayType='".$_POST["lopt"]."', PayInfo='".$_POST["lopi"]."', Note='".$_POST["Note"]."', UpdatedBy=".$_SESSION["uid"].", UpdatedOn='".$date."' WHERE InvNo='".$_POST["billno"]."'";
//echo $queryi;
if ($conn->query($queryi))
{
$billno = $_POST["billno"];
echo '';
}
else
echo '';
}
}
if($_POST['act'] == 'ADD_RETURN_BILL')
{
if ($_POST['BillNo'] == '' || $_POST['BillType'] == '' || $_POST['Branch'] == '' || $_POST['Name'] == '' || $_POST['lop'] == '' || $_POST['Discount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['Paymode'] == '' || $_POST['lopt'] == '' || $_POST['lopi'] == '' ) {
echo "You must enter all fields";
}
else
{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["Age"]=($_POST["Age"]==''? 0:$_POST["Age"]);
$_POST["Gender"]=($_POST["Gender"]==''? 0:$_POST["Gender"]);
$queryi="INSERT INTO bills_ret(BillNo,RBillDate,BillDate, BillType, TypeId, Branch, Referer, Name, Mobile, Age, Gender, Products, Discount, DisRemark, DeliveryCharges,Taxoncharges, Taxamount, Totalamount,Paymode, PayType, PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$_POST['BillNo']."','".$_POST["RBillDate"]."','".$_POST["BillDate"]."','".$_POST["BillType"]."','".$_POST["TypeId"]."','".$_POST["Branch"]."','".$_POST["Referer"]."','".$_POST["Name"]."','".$_POST["Mobile"]."','".$_POST["Age"]."','".$_POST["Gender"]."','".$_POST["lop"]."','".$_POST["Discount"]."','".$_POST["DisRemark"]."','".$_POST["DeliveryCharges"]."','".$_POST["DeliveryCharges"]."','".$_POST["Taxamount"]."','".$_POST["Netamount"]."','".$_POST["Paymode"]."','".$_POST["lopt"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
//echo $queryi;
if ($conn->query($queryi))
{
//get bill number
$result = $conn->query("SELECT Max(BillNo) from bills_ret where CreatedBy=".$_SESSION["uid"]);
$row = mysqli_fetch_row($result);
$Billno=$row[0];
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty;
$queryu1="UPDATE stock SET CurrentStock=CurrentStock+".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock+".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
//update status of actual bill
$result = $conn->query("select B.InvNo from bills B,bills_ret R where B.InvNo=R.BillNo and B.Products==R.Products and B.InvNo='".$_POST['BillNo']."'");
$cou = $_POST['count'];
if(count($arr) == $cou) { //full cancelled
$queryu1="UPDATE bills set status=3,updatedby=".$_SESSION["uid"].",UpdatedOn='".$date."' where InvNo='".$_POST['BillNo']."'";
}
else //partial cancelled
{
$queryu1="UPDATE bills set status=2,updatedby=".$_SESSION["uid"].",UpdatedOn='".$date."' where InvNo='".$_POST['BillNo']."'";
}
$conn->query($queryu1);
echo '';
}
else
{
if(strpos($conn->error, 'Duplicate entry'))
echo '';
else
echo '';
}
}
}
if($_POST['act'] == 'CANCEL_BILL')
{
if ($_POST['BillType'] == '' || $_POST['Branch'] == '' || $_POST['Name'] == '' || $_POST['lop'] == '' || $_POST['Discount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['Paymode'] == '' || $_POST['lopt'] == '' || $_POST['lopi'] == '' ) {
echo "You must enter all fields";
}
else
{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["Age"]=($_POST["Age"]==''? 0:$_POST["Age"]);
$_POST["Gender"]=($_POST["Gender"]==''? 0:$_POST["Gender"]);
$billno = $_POST["billno"];
$queryi = "UPDATE bills set Status=0,updatedby=".$_SESSION["uid"].",UpdatedOn='".$date."' where InvNo='".$billno."'";
if ($conn->query($queryi))
{
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty;
$queryu1="UPDATE stock SET CurrentStock=CurrentStock+".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock+".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
echo '';
}
else
echo '';
}
}
if($_POST['act'] == 'ADD_GRN_RETURN')
{
if ($_POST['GRNNo'] == '' || $_POST['GrnretDate'] == '' || $_POST['InvoiceNo'] == '' || $_POST['InvoiceDate'] == '' || $_POST['PONO'] == '' || $_POST['Branch'] == '' || $_POST['ActualDelDate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '' ) {
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$queryi="INSERT INTO gretn(GRNNo,RetDate,InvoiceNo,InvoiceDate,PONO, Branch, Supplier, ActualDelDate, Products, Costvalue, Discount, Grossamount, Taxamount, DeliveryCharges, Netamount,PayType,PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$_POST["GRNNo"]."','".$_POST["GrnretDate"]."','".$_POST["InvoiceNo"]."','".$_POST["InvoiceDate"]."','".$_POST["PONO"]."','".$_POST["Branch"]."','SIDDHA FOODS TECH','".$_POST["ActualDelDate"]."','".$_POST["lop"]."','".$_POST["Costvalue"]."','".$_POST["Discount"]."','".$_POST["Grossamount"]."','".$_POST["Taxamount"]."','".$_POST["DeliveryCharges"]."','".$_POST["Netamount"]."','".$_POST["PayType"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
$grno=$_POST["GRNNo"];
if ($conn->query($queryi))
{
//get gretn number
$result = $conn->query("SELECT Max(GRNNo) from gretn where CreatedBy=".$_SESSION["uid"]);
$row = mysqli_fetch_row($result);
$grnno=$row[0];
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty-($arr[$i]->Def+$arr[$i]->Miss);
$queryu1="UPDATE stock SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
echo '';
}
else
{
if(strpos($conn->error, 'Duplicate entry'))
echo '';
else
echo '';
}
}
}
if($_POST['act'] == 'ADD_GRN_RETURNS')
{
if ($_POST['GrnretDate'] == '' || $_POST['Branch'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '' ) {
echo "You must enter all fields";
}
else{
$_POST["DeliveryCharges"]=($_POST["DeliveryCharges"]==''? 0:$_POST["DeliveryCharges"]);
$_POST["GRNNo"]=($_POST["GRNNo"]==''? 0:$_POST["GRNNo"]);
$_POST["PONO"]=($_POST["PONO"]==''? 0:$_POST["PONO"]);
$_POST["InvoiceDate"]=($_POST["InvoiceDate"]==''? $date:$_POST["InvoiceDate"]);
if($_POST["GRNNo"]==0){
if($_POST["GRNNo"]==0){
$result0 = $conn->query("SELECT GRNNo from gretn where CreatedBy=".$_SESSION["uid"]);
if($result0->num_rows>=0){
$result1 = $conn->query("SELECT GRNNo, Max(GRNNo) from gretn where Branch='".$_SESSION["branchid"]."' GROUP BY GRNNo ORDER by GRNNo DESC");
$row = mysqli_fetch_row($result1);
$InvNo=$row[1];
//$maxyear = substr($InvNo, 0, $InvNo < 0 ? 3 : 4);
$maxyear = substr($InvNo, 5, $InvNo < 0 ? 3 : 4);
$num = substr($InvNo, 10, $InvNo < 0 ? 5 : 6);
if (($num == 0)||($num == ''))
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 4, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 4, "0", STR_PAD_LEFT);
}
}
else
{
if($maxyear != $combine){
$newnumber = 1;
$NewInvNo=str_pad($newnumber, 4, "0", STR_PAD_LEFT);
} else {
$newnumber = $num + 1;
$NewInvNo=str_pad($newnumber, 4, "0", STR_PAD_LEFT);
}
}
}
}
$gr="GR";
$InvCombine =$gr . $pre .'-'. $combine . '-' . $NewInvNo;
}
$_POST["ActualDelDate"]=($_POST["ActualDelDate"]==''? $date:$_POST["ActualDelDate"]);
$queryi="INSERT INTO gretn(GretNo,GRNNo,RetDate,InvoiceNo,InvoiceDate,PONO, Branch, Supplier, ActualDelDate, Products, Costvalue, Discount, Grossamount, Taxamount, DeliveryCharges, Netamount,PayType,PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES (NOT NULL,'".$InvCombine."','".$_POST["GrnretDate"]."','".$_POST["InvoiceNo"]."','".$_POST["InvoiceDate"]."','".$_POST["PONO"]."','".$_POST["Branch"]."','SIDDHA FOODS TECH','".$_POST["ActualDelDate"]."','".$_POST["lop"]."','".$_POST["Costvalue"]."','".$_POST["Discount"]."','".$_POST["Grossamount"]."','".$_POST["Taxamount"]."','".$_POST["DeliveryCharges"]."','".$_POST["Netamount"]."','".$_POST["PayType"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
if ($conn->query($queryi))
{
//get gretn number
$result = $conn->query("SELECT Max(GretNo) from gretn where CreatedBy=".$_SESSION["uid"]);
$row = mysqli_fetch_row($result);
$GretNo=$row[0];
//stock update
$arr = json_decode($_POST['lop'], false);
for($i=0;$iquery("SELECT ProdId FROM products WHERE prodname='".$arr[$i]->Prod."'");
$row = mysqli_fetch_row($result);
$ProdId=$row[0];
//update stocks
$Qty=$arr[$i]->Qty-($arr[$i]->Def+$arr[$i]->Miss);
$queryu1="UPDATE stock SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' WHERE BranchId=".$_POST['Branch']." and ProdId=".$ProdId;
$conn->query($queryu1);
//update stock details
$queryu2="UPDATE stock_detail SET CurrentStock=CurrentStock-".$Qty.", LastUpdatedOn='".$date."' where BranchId=".$_POST['Branch']." and ProdId=".$ProdId." and Batch='".$arr[$i]->Batch."' and Exp='".$arr[$i]->Exp."'";
$conn->query($queryu2);
}
echo '';
}
else
{
if(strpos($conn->error, 'Duplicate entry'))
echo '';
else
echo '';
}
}
}
if($_POST['act'] == 'ADD_ST') // Stock transfer
{
if ($_POST['from'] == '' || $_POST['to'] == '' || $_POST['tdate'] == '' || $_POST['lop'] == '' || $_POST['Costvalue'] == '' || $_POST['Discount'] == '' || $_POST['Grossamount'] == '' || $_POST['Taxamount'] == '' || $_POST['Netamount'] == '' || $_POST['PayType'] == '') {
echo "You must enter all fields";
}
else
{
$_POST["charge"]=($_POST["charge"]==''? 0:$_POST["charge"]);
$queryi="INSERT INTO stock_transfer(BranchFrom, BranchTo, Transdate, Products, Costvalue, Discount, Grossamount, Taxamount, Deliverycharges, Netamount, PayType, PayInfo, Note, Status, CreatedBy, CreatedOn, UpdatedBy, UpdatedOn) VALUES ('".$_POST["from"]."','".$_POST["to"]."','".$_POST["tdate"]."','".$_POST["lop"]."','".$_POST["Costvalue"]."','".$_POST["Discount"]."','".$_POST["Grossamount"]."','".$_POST["Taxamount"]."','".$_POST["charge"]."','".$_POST["Netamount"]."','".$_POST["PayType"]."','".$_POST["lopi"]."','".$_POST["Note"]."',1,".$_SESSION["uid"].",'".$date."',".$_SESSION["uid"].",'".$date."')";
//stock update
if ($conn->query($queryi))
{
$arr = json_decode($_POST['lop'], false);
for($i=0;$iQty;
$queryu1="UPDATE stock S, products P SET CurrentStock=CurrentStock-".$Qty.", S.LastUpdatedOn='".$date."' WHERE S.BranchId=".$_POST['Branch']." and S.ProdId=P.ProdId and P.Prodname='".$arr[$i]->Prod."'";
$conn->query($queryu1);
}
echo ';';
}
else
echo '';
}
}
if($_POST['act'] == 'GET_BATCH')
{
if ($_POST['Branch'] == '' || $_POST['Product'] == '') {
echo "You must enter all fields";
}
else{
$result = $conn->query("SELECT Batch,Exp FROM stock_detail S,products P WHERE BranchId=".$_POST['Branch']." and P.Prodname='".$_POST['Product']."' and P.ProdId=S.ProdId and CurrentStock>0 ");
if($result->num_rows>0) {
$obj=array();
while($row = mysqli_fetch_row($result)) {
array_push($obj,$row[0]);
}
echo(json_encode($obj));
}
else
echo '0';
}
}
if($_POST['act'] == 'GET_AVLSTOCK')
{
if ($_POST['Branch'] == '' || $_POST['Product'] == '' || $_POST['Batch'] == '') {
echo "You must enter all fields";
}
else{
$result = $conn->query("SELECT CurrentStock,Exp FROM stock_detail S,products P WHERE BranchId=".$_POST['Branch']." and P.Prodname='".$_POST['Product']."' and Batch=".$_POST['Batch']." and P.ProdId=S.ProdId and CurrentStock>0 ");
if($result->num_rows>0) {
$obj=array();
while($row = mysqli_fetch_row($result)) {
array_push($obj,array($row[0],$row[1]));
}
echo(json_encode($obj));
}
else
echo '0';
}
}
}
else
{
header('Location: ./index.php');
exit;
}
?>