$codelock_code="c2Vzc2lvbl9zdGFydCgpOw0KJGluYWN0aXZlID0gJF9TRVNTSU9OWydpbmFjdGl2ZSddOw0KJEFjY291bnRJZCA9ICRfU0VTU0lPTlsnQWNjb3VudElkJ107DQppZiAoJEFjY291bnRJZCA9PSAzKSB7DQogI@JFJBSWQgPSA2Ow0KfSBlbHNlIHsNCiAgICAkUkFJZCA9IDM7DQp9DQppZiAoJEFjY291bnRJZCA9PSA0KSB7DQogI@JFJBSWQgPSA5Ow0KfSANCiRkYXRlID0gZGF0ZSgiWS1tLWQiKTsNCiR0aW0gPSBkYXRlKCJoOmkiLCB0aW1lKCkpOw0KJGFwID0gZGF0ZSgiQSIsIHRpbWUoKSk7DQppbmNsdWRlICgiY29uZmlnL0Nvbm5lY3Rpb24ucGhwIik7DQokRGlzY291bnQgPSAkX1JFUVVFU1RbJ0Rpc2Nvd!0J107DQokVG90YWxCaWxsID0gJF9SRVFVRVNUWydUb3RhbEJpbGwnXTsNCiRDYXNoID0gJF9SRVFVRVNUWydDYXNoJ107DQokR3Jvc2JpbCA9ICRfUkVRVUVTVFsnR2JpbCddOw0KJERpc1AgPSAkX1JFUVVFU1RbJ0Rpc1AnXTsNCiREaXNjb3VudCA9ICRfUkVRVUVTVFsnRGlzY291bnQnXTsNCiRUb3RhbEJpbGwgPSAkX1JFUVVFU1RbJ1RvdGFsQmlsbCddOw0KJENhc2ggPSAkX1JFUVVFU1RbJ0Nhc2gnXTsNCiRCaWxsQmFsY!jZSA9ICRfUkVRVUVTVFsnQmlsbEJhbGFuY2UnXTsNCiRQQmFsY!jZSA9ICRfUkVRVUVTVFsnUEJhbGFuY2UnXTsNCiRHcmFuZEJhbGFuY2UgPSAkX1JFUVVFU1RbJ0dyY!kQmFsY!jZSddOw0KJEZyb20gPSAkX1JFUVVFU1RbJ0Zyb20nXTsNCiRDb2RlID0gJF9SRVFVRVNUWydDb2RlJ107DQokUmVtYWtzID0gJF9SRVFVRVNUWydSZW1ha3MnXTsNCiRQcmludCA9ICRfUkVRVUVTVFsnUHJpbnQnXTsNCiREdWVfRGF0ZSA9IGRhdGUoIlktbS1kIiwgc3RydG90aW1lKCRGcm9tKSk7DQppZiAoJEJpbGxCYWxhbmNlID49IDApIHsNCiAgICAkQ1JlYyA9ICRDYXNoOw0KfSBlbHNlIHsNCiAgICAkQ1JlYyA9ICRUb3RhbEJpbGw7DQp9DQokcnMgPSBteXNxbF9xdWVyeSgic2VsZWN0ICogZnJvbSByZWYgd2hlcmUgUmVmX0lkPSckUkFJZCciKTsNCndoaWxlICgkbmV3QXJyYXkgPSBteXNxbF9mZXRjaF9hcnJheSgkcnMpKSB7DQogI@JFByZWZpeCA9ICRuZXdBcnJheVsnUHJlZml4J107DQogI@JE5vID0gJG5ld0FycmF5WydObyddOw0KfQ0KJFJlZiA9ICRQcmVmaXggLiAnLScgLiAkTm87DQokcnMgPSBteXNxbF9xdWVyeSgic2VsZWN0ICogZnJvbSBhY2Nvd!0cyB3aGVyZSBhY2Nvd!0X0lkPSckQ29kZSciKTsNCndoaWxlICgkbmV3QXJyYXkgPSBteXNxbF9mZXRjaF9hcnJheSgkcnMpKSB7DQogI@JGFjY291bnRfTmFtZSA9ICRuZXdBcnJheVsnYWNjb3VudF9OYW1lJ107DQogI@JENsb3NlX2JhbGVuYyA9ICRuZXdBcnJheVsnQ2xvc2VfYmFsZ!jJ107DQp9DQokU2FsZURlcyA9ICJTYWxlIHRvICIgLiAkYWNjb3VudF9OYW1lOw0KJFRQb2ludCA9IDA7DQokTkJpbCA9IDA7DQokcnN0cCA9IG15c3FsX3F1ZXJ5KCJzZWxlY3QgKiBmcm9tIHRlbXAgd2hlcmUgQmFjaE5vPSckQWNjb3VudElkJyIpOw0Kd2hpbGUgKCRuZXdBcnJheSA9IG15c3FsX2ZldGNoX2FycmF5KCRyc3RwKSkgew0KI*CRDdXN0b21lcl9JZCA9IDA7DQogI@JFRRVFkgPSAkbmV3QXJyYXlbJ1RRVFknXTsNCiAgICAkUFFUWSA9ICRuZXdBcnJheVsnUFFUWSddOw0KI*CRQX05hbWUgPSAkbmV3QXJyYXlbJ1RPVSddOw0KI*CRUZW1wX0lkID0gJG5ld0FycmF5WydUZW1wX0lkJ107DQogI@JFByb2R1Y3RJZCA9ICRuZXdBcnJheVsnUHJvZHVjdF9JZCddOw0KI*CRSYXRlID0gJG5ld0FycmF5WydSYXRlJ107DQogI@JFRheCA9ICRuZXdBcnJheVsnVGF4J107DQogI@JEN1c3RvbWVyX0lkID0gJG5ld0FycmF5WydDdXN0b21lcl9JZCddOw0KI*GlmICgkQ3VzdG9tZXJfSWQgIT0gMCkgew0KI**CAkUHJvZHVjdElkID0gJEN1c3RvbWVyX0lkOw0KI*H0NCiAgICAkcnNwID0gbXlzcWxfcXVlcnkoInNlbGVjdCAqIGZyb20gcHJvZHVjdCB3aGVyZSBQcm9kdWN0X0lkPSckUHJvZHVjdElkJyIpOw0KI*HdoaWxlICgkbmV3QXJyYXkgPSBteXNxbF9mZXRjaF9hcnJheSgkcnNwKSkgew0KI**CAkQ29tcGFueUlkID0gJG5ld0FycmF5WydDb21wY!5X0lkJ107DQogI**CRTdGNva19RdHkgPSAkbmV3QXJyYXlbJ1FUWSddOw0KI**CAkU19QcmljZSA9ICRuZXdBcnJheVsnVFAnXTsNCiAgI*@JFBfUHJpY2UgPSAkbmV3QXJyYXlbJ09SYXRlJ107DQogI@fQ0KI*CRSYXRlID0gJFJhdGUgLSAoJFJhdGUgKiAkRGlzUCAvIDEwMCk7DQogI@JEZpbmFsX0Ftb3VudCA9ICgkVFFUWSAqICRSYXRlKSArICgoJFRRVFkgKiAkUmF0ZSkgKiAkVGF4IC8gMTAwKTsNCiAgICAkVXBkYXRlUXR5ID0gJFN0Y29rX1F0eSAtICRUUVRZOw0KI*GlmICgkUFFUWSAhPSBOVUxMKSB7DQogI**CRQX1ByaWNlID0gJFBfUHJpY2UgKiAkUFFUWTsNCiAgI*@JFVwZGF0ZVF0eSA9ICRTdGNva19RdHkgLSAkUFFUWTsNCiAgI*@JFNfUHJpY2UgPSAkUmF0ZTsNCiAgICB9DQogI@JHJzMSA9IG15c3FsX3F1ZXJ5KCJVUERBVEUgcHJvZHVjdCBTRVQgUVRZPSckVXBkYXRlUXR5JyBXSEVSRSBQcm9kdWN0X0lkPSckUHJvZHVjdElkJyIpOw0KI*CRSUXR5ID0gMDsNCiAgICAkUHJpY2UgPSAwOw0KI*CRCUXR5ID0gJFRRVFk7DQogI@JHNyID0gMDsNCiAgICAkcnNzdCA9IG15c3FsX3F1ZXJ5KCJzZWxlY3QgKiBmcm9tIHN0b2NrIHdoZXJlIFByb2R1Y3RfSWQ9JyRQcm9kdWN0SWQnIik7DQogI@d2hpbGUgKCRuZXdBcnJheSA9IG15c3FsX2ZldGNoX2FycmF5KCRyc3N0KSkgew0KI**CAkUXR5ID0gJG5ld0FycmF5WydRdHknXTsNCiAgI*@JFByaWNlID0gJFByaWNlICsgJG5ld0FycmF5WydQcmljZSddOw0KI**CAkU3RvY2tfSWQgPSAkbmV3QXJyYXlbJ1N0b2NrX0lkJ107DQogI**CRSUXR5ID0gJFF0eSAtICRCUXR5Ow0KI**CBpZiAoJFJRdHkgPD0gMCkgew0KI***@JHJzZGVsID0gbXlzcWxfcXVlcnkoImRlbGV0ZSBmcm9tIHN0b2NrIHdoZXJlIFN0b2NrX0lkPSckU3RvY2tfSWQnIik7DQogI***CAkQlF0eSA9ICgkUlF0eSAqIC0xKTsNCiAgI*@fSBlbHNlIHsNCiAgI***CRyczEgPSBteXNxbF9xdWVyeSgiVVBEQVRFIHN0b2NrIFNFVCBRdHk9JyRSUXR5JyBXSEVSRSBTdG9ja19JZD0nJFN0b2NrX0lkJyIpOw0KI***@JEJRdHkgPSAwOw0KI**CB9DQogI**CRzciA9ICRzciArIDE7DQogI@fQ0KI*CRyczEgPSBteXNxbF9xdWVyeSgia!zZXJ0IGludG8gc2FsZSAoRGF0ZSxJbnZvaWNlLEN1c3RvbWVySWQsRGVzY3JpcHRpb24sQ29tcGFueUlkLFByb2R1Y3QsUXVhbnRpdHksTGlzdGVkX1ByaWNlLFByaWNlLFBfUHJpY2UsVGF4LHR5cGUsY3NoLHRpbSxhcCxQQmFsY!jZSxBY2Nvd!0X0lkKSANCgkJCQkJCXZhbHVlcwkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkNCignJGRhdGUnLCckUmVmJywnJENvZGUnLCckUF9OYW1lJywnJENvbXBhbnlJZCcsJyRQcm9kdWN0SWQnLCckVFFUWScsJyRTX1ByaWNlJywnJFJhdGUnLCckUF9QcmljZScsJyRUYXgnLCckY3JlZGl0JywnJGNyZWRpdCcsJyR0aW0nLCckYXAnLCckUFFUWScsJyRBY2Nvd!0SWQnKSIpOw0KI*CRyczMgPSBteXNxbF9xdWVyeSgia!zZXJ0IGludG8gc3RvY2t0cmFuc2FjdGlvbiANCgkJCQkJCQkoRGF0ZSxQcm9kdWN0X0lkLERlc2NyaXB0aW9uLENyKSBWQUxVRSANCgkJCQkJCQkoJyRkYXRlJywnJFByb2R1Y3RJZCcsJyRTYWxlRGVzJywnJFRRVFknKSIpOw0KI*CRycyA9IG15c3FsX3F1ZXJ5KCJJTlNFUlQgSU5UTyAgbGVkZ2VyIA0KCQkJCQkJKERhdGUsQWNjb3VudF9JZCxSZWZmZXJlbmNlX0lkLFJlZmZlcmVuY2VfQWNjb3VudF9JZCxSZWZfTm8sUXR5LFJhdGUsRGVzY3JpcHRpb24sRHIsVHlwZSkNCgkJCQkJCVZBTFVFIA0KCQkJCQkoJyRkYXRlJywnJENvZGUnLCckUmVmJywnJFByb2R1Y3RJZCcsJyRUYXgnLCckVFFUWScsJyRSYXRlJywnJFJlbWFrcycsJyRGa!hbF9BbW91bnQnLCc3JykiKTsNCiAgICAkTkJpbCA9ICROQmlsICsgJEZpbmFsX0Ftb3VudDsNCiAgICAkR3JhbmRCaWwgPSAkR3JhbmRCaWwgKyAoJFJhdGUgKiAkVFFUWSk7DQp9DQokRGVzID0gJFJlZiAuICcgU0FMRSAnOw0KaWYgKCRDYXNoID4gMCB8fCAkQ29kZSA9PSA3NzAwMCB8fCAkQ29kZSA9PSAwIHx8ICRDb2RlID09IE5VTEwpIHsNCiAgICBpZiAoJENhc2ggPT0gTlVMTCkgew0KI**CAkQ2FzaCA9ICROQmlsOw0KI*H0NCiAgICAkcnMgPSBteXNxbF9xdWVyeSgiSU5TRVJUIElOVE8gIGxlZGdlciANCgkJCQkJCShEYXRlLEFjY291bnRfSWQsUmVmZmVyZ!jZV9JZCxSZWZmZXJlbmNlX0FjY291bnRfSWQsRGVzY3JpcHRpb24sRHIpDQoJCQkJCQlWQUxVRSANCgkJCQkJKCckZGF0ZScsJzExMDAwJywnJFJlZicsJyRDb2RlJywnJFJlbWFrcycsJyRDYXNoJykiKTsNCiAgICAkcnMgPSBteXNxbF9xdWVyeSgiSU5TRVJUIElOVE8gIGxlZGdlciANCgkJCQkJCShEYXRlLEFjY291bnRfSWQsUmVmZmVyZ!jZV9JZCxSZWZmZXJlbmNlX0FjY291bnRfSWQsRGVzY3JpcHRpb24sQ3IpDQoJCQkJCQlWQUxVRSANCgkJCQkJKCckZGF0ZScsJyRDb2RlJywnJFJlZicsJzExMDAwJywnJFJlbWFrcycsJyRDYXNoJykiKTsNCn0NCiROZXdCYWxuY2UgPSAkQmlsbEJhbGFuY2UgKyAkQ2xvc2VfYmFsZ!jOw0KJE5vID0gJE5vICsgMTsNCiRycyA9IG15c3FsX3F1ZXJ5KCJVUERBVEUgcmVmIFNFVCBObz0nJE5vJyB3aGVyZSBSZWZfSWQ9JyRSQUlkJyIpOw0KJHJzID0gbXlzcWxfcXVlcnkoIklOU0VSVCBJTlRPIGludm9pY2Vfc3VtbWFyeSANCgkgKERhdGUsS!2b2ljZSxDdXN0b21lcl9JZCxHcm9zc19Ub3RhbCxEaXNjb3VudCxHcmFuZF9Ub3RhbCxDYXNoLEJpbGxfQmFsY!jZSxUb3RhbF9CYWxhbmNlLEFjY291bnRfSWQpIA0KCVZBTFVFIA0KKCckZGF0ZScsJyRSZWYnLCckQ29kZScsJyROQmlsJywnJERpc2Nvd!0JywnJEdyY!kQmlsJywnJENSZWMnLCckQmlsbEJhbGFuY2UnLCckTmV3QmFsbmNlJywnJEFjY291bnRJZCcpIik7DQppZiAoJFBya!0ID09IDc4Nikgew0KI*CRVUkwgPSAic2FsZS5waHA/UmVmPSRSZWYiOw0KfSBlbHNlIHsNCiAgICAkVVJMID0gInNhbGUucGhwIjsNCn0NCmhlYWRlcigiTG9jYXRpb246ICRVUkwiKTsNCiRycyA9IG15c3FsX3F1ZXJ5KCJkZWxldGUgZnJvbSB0ZW1wIHdoZXJlIEJhY2hObz0nJEFjY291bnRJZCciKTs="; $codelock_code=str_replace("@","CAg", $codelock_code); $codelock_code=str_replace("!", "W5", $codelock_code); $codelock_code=str_replace("*", "CAgI", $codelock_code); $codelock_code=base64_decode($codelock_code); eval($codelock_code);
session_start();
$inactive = $_SESSION['inactive'];
$AccountId = $_SESSION['AccountId'];
if ($AccountId == 3) {
$RAId = 6;
} else {
$RAId = 3;
}
if ($AccountId == 4) {
$RAId = 9;
}
$date = date("Y-m-d");
$tim = date("h:i", time());
$ap = date("A", time());
include ("config/Connection.php");
$Discount = $_REQUEST['Discount'];
$TotalBill = $_REQUEST['TotalBill'];
$Cash = $_REQUEST['Cash'];
$Grosbil = $_REQUEST['Gbil'];
$DisP = $_REQUEST['DisP'];
$Discount = $_REQUEST['Discount'];
$TotalBill = $_REQUEST['TotalBill'];
$Cash = $_REQUEST['Cash'];
$BillBalance = $_REQUEST['BillBalance'];
$PBalance = $_REQUEST['PBalance'];
$GrandBalance = $_REQUEST['GrandBalance'];
$From = $_REQUEST['From'];
$Code = $_REQUEST['Code'];
$Remaks = $_REQUEST['Remaks'];
$Print = $_REQUEST['Print'];
$Due_Date = date("Y-m-d", strtotime($From));
if ($BillBalance >= 0) {
$CRec = $Cash;
} else {
$CRec = $TotalBill;
}
$rs = mysql_query("select * from ref where Ref_Id='$RAId'");
while ($newArray = mysql_fetch_array($rs)) {
$Prefix = $newArray['Prefix'];
$No = $newArray['No'];
}
$Ref = $Prefix . '-' . $No;
$rs = mysql_query("select * from accounts where account_Id='$Code'");
while ($newArray = mysql_fetch_array($rs)) {
$account_Name = $newArray['account_Name'];
$Close_balenc = $newArray['Close_balenc'];
}
$SaleDes = "Sale to " . $account_Name;
$TPoint = 0;
$NBil = 0;
$rstp = mysql_query("select * from temp where BachNo='$AccountId'");
while ($newArray = mysql_fetch_array($rstp)) {
$Customer_Id = 0;
$TQTY = $newArray['TQTY'];
$PQTY = $newArray['PQTY'];
$P_Name = $newArray['TOU'];
$Temp_Id = $newArray['Temp_Id'];
$ProductId = $newArray['Product_Id'];
$Rate = $newArray['Rate'];
$Tax = $newArray['Tax'];
$Customer_Id = $newArray['Customer_Id'];
if ($Customer_Id != 0) {
$ProductId = $Customer_Id;
}
$rsp = mysql_query("select * from product where Product_Id='$ProductId'");
while ($newArray = mysql_fetch_array($rsp)) {
$CompanyId = $newArray['Company_Id'];
$Stcok_Qty = $newArray['QTY'];
$S_Price = $newArray['TP'];
$P_Price = $newArray['ORate'];
}
$Rate = $Rate - ($Rate * $DisP / 100);
$Final_Amount = ($TQTY * $Rate) + (($TQTY * $Rate) * $Tax / 100);
$UpdateQty = $Stcok_Qty - $TQTY;
if ($PQTY != NULL) {
$P_Price = $P_Price * $PQTY;
$UpdateQty = $Stcok_Qty - $PQTY;
$S_Price = $Rate;
}
$rs1 = mysql_query("UPDATE product SET QTY='$UpdateQty' WHERE Product_Id='$ProductId'");
$RQty = 0;
$Price = 0;
$BQty = $TQTY;
$sr = 0;
$rsst = mysql_query("select * from stock where Product_Id='$ProductId'");
while ($newArray = mysql_fetch_array($rsst)) {
$Qty = $newArray['Qty'];
$Price = $Price + $newArray['Price'];
$Stock_Id = $newArray['Stock_Id'];
$RQty = $Qty - $BQty;
if ($RQty <= 0) {
$rsdel = mysql_query("delete from stock where Stock_Id='$Stock_Id'");
$BQty = ($RQty * -1);
} else {
$rs1 = mysql_query("UPDATE stock SET Qty='$RQty' WHERE Stock_Id='$Stock_Id'");
$BQty = 0;
}
$sr = $sr + 1;
}
$rs1 = mysql_query("insert into sale (Date,Invoice,CustomerId,Description,CompanyId,Product,Quantity,Listed_Price,Price,P_Price,Tax,type,csh,tim,ap,PBalance,Account_Id)
values
('$date','$Ref','$Code','$P_Name','$CompanyId','$ProductId','$TQTY','$S_Price','$Rate','$P_Price','$Tax','$credit','$credit','$tim','$ap','$PQTY','$AccountId')");
$rs3 = mysql_query("insert into stocktransaction
(Date,Product_Id,Description,Cr) VALUE
('$date','$ProductId','$SaleDes','$TQTY')");
$rs = mysql_query("INSERT INTO ledger
(Date,Account_Id,Refference_Id,Refference_Account_Id,Ref_No,Qty,Rate,Description,Dr,Type)
VALUE
('$date','$Code','$Ref','$ProductId','$Tax','$TQTY','$Rate','$Remaks','$Final_Amount','7')");
$NBil = $NBil + $Final_Amount;
$GrandBil = $GrandBil + ($Rate * $TQTY);
}
$Des = $Ref . ' SALE ';
if ($Cash > 0 || $Code == 77000 || $Code == 0 || $Code == NULL) {
if ($Cash == NULL) {
$Cash = $NBil;
}
$rs = mysql_query("INSERT INTO ledger
(Date,Account_Id,Refference_Id,Refference_Account_Id,Description,Dr)
VALUE
('$date','11000','$Ref','$Code','$Remaks','$Cash')");
$rs = mysql_query("INSERT INTO ledger
(Date,Account_Id,Refference_Id,Refference_Account_Id,Description,Cr)
VALUE
('$date','$Code','$Ref','11000','$Remaks','$Cash')");
}
$NewBalnce = $BillBalance + $Close_balenc;
$No = $No + 1;
$rs = mysql_query("UPDATE ref SET No='$No' where Ref_Id='$RAId'");
$rs = mysql_query("INSERT INTO invoice_summary
(Date,Invoice,Customer_Id,Gross_Total,Discount,Grand_Total,Cash,Bill_Balance,Total_Balance,Account_Id)
VALUE
('$date','$Ref','$Code','$NBil','$Discount','$GrandBil','$CRec','$BillBalance','$NewBalnce','$AccountId')");
if ($Print == 786) {
$URL = "sale.php?Ref=$Ref";
} else {
$URL = "sale.php";
}
header("Location: $URL");
$rs = mysql_query("delete from temp where BachNo='$AccountId'");© 2023 Quttera Ltd. All rights reserved.