$q24";;
}//else{echo "ok";}
// echo $q24."
";
while($ginvmast=sqlsrv_fetch_array($get_inv_det, SQLSRV_FETCH_ASSOC)){
$inv_no_db =$ginvmast["DC_NO"];
$inv_date_db =$ginvmast["DC_DATE"];//YYYY-MM-DD
// $delivery_to=$ginvmast["DELIVERY_TO"];
$delivery_to=$ginvmast["SUPPLIER_CENTER_SL_NO"];
$inv_date=date("d/m/Y",strtotime($inv_date_db));
$sale_amt =$ginvmast["TOTAL_AMT"];
$frieght_amt =$ginvmast["TOTAL_FREIGHT"];
$insurance_amt =$ginvmast["TOTAL_INSURANCE"];
// $igst_amt =$ginvmast["AddIGST"];
// $cgst_amt =$ginvmast["AddCGST"];
// $sgst_amt =$ginvmast["AddSGST"];
$tot_tax_amt =$ginvmast["TOTAL_AMT_GST"];
$transporter_no=$ginvmast["TRANSPORTER_NO"];
// $discount =$ginvmast["discount"];
$inv_amt_tot =$ginvmast["TOTAL_DC_AMT"];
$account_id =$ginvmast["CUS_NAME"];
$roundoff=$ginvmast["TOTAL_ROUNDING"];
$company_code=$ginvmast["COMPANY_CODE"];
//$lrrr_no=$ginvmast["LRRR_NO"];
//$lrrr_date=$ginvmast["LRRR_DATE"];
}
$q59="SELECT * FROM [COMPANY] WHERE [COMPANY_CODE]='$company_code'";
$gcd=sqlsrv_query($conn,$q59);
while($gcr=sqlsrv_fetch_array($gcd,SQLSRV_FETCH_ASSOC)) {
$co_gstin=$gcr[""];
$co_name=$gcr["COMPANY_NAME"];
$co_add1=$gcr["ADD_1"];
$co_add2=$gcr["ADD_2"];
$co_loc=$gcr["ADD_3"];
$co_pin=$gcr["PIN"];
$co_state_code=$gcr["ADD_4"];
$co_ph=$gcr["PHONE"];
$co_em=$gcr["EMAIL"];
}
$q72="SELECT TOP (1) [DRCR_NAME] FROM [ACCOUNT_MASTER] WHERE [DRCR_CODE]='$account_id' ";
// $q72="SELECT TOP (1) [DRCR_NAME] FROM [ACCOUNT_MASTER] WHERE [DRCR_CODE]='$account_id' ";
// echo $q72."
";//exit;
$gam=sqlsrv_query($conn,$q72);
while($gar=sqlsrv_fetch_array($gam,SQLSRV_FETCH_ASSOC)) {
$buyer_name=$gar["DRCR_NAME"];
$q101="SELECT * FROM [CUS_SUP_ADDRESS_D] WHERE [DRCR_CODE]='$account_id' AND [SL_NO]='$delivery_to'";
// $q101="SELECT * FROM [CUS_SUP_ADDRESS_D] WHERE [DRCR_CODE]='$account_id'";
$gamres=sqlsrv_query($conn,$q101 );
while($gamr=sqlsrv_fetch_array($gamres,SQLSRV_FETCH_ASSOC)) {
$address1=$gamr["ADD1"].$gamr["ADD2"];
$address2=$gamr["ADD3"].$gamr["ADD4"];
$address3=$gamr["ADD5"];
$city=$gamr["LOCATION"];
$pin=$gamr["PINCODE"];
$phone1=$gamr["PHONE_NO"];
// $phone2=$gamr["phone2"];
$mob1=$gamr["MOBILE_NO"];
// $mob2=$gamr["mob2"];
$gstin=$gamr["GST_NO"];
// $buyer_state_code=substr($gstin,0,2);
$buyer_state_code=$gamr["STATE"];
}
}
// echo "exint $q101
$buyer_name $address1.,$address2, ";
// exit;
// $pin="260301";
// $gstin="05AAACG4414B1ZE";
// $buyer_state_code="05";
//exit("exiint $gstin");
// $buyerDtls='
// "gstin": "'.$gstin.'",
// "lglNm": "'.$buyer_name.'",
// "trdNm": "'.$buyer_name.'",
// "addr1": "'.$address1.'",
// "addr2": "'.$address2.'",
// "loc": "'.$city.'",
// "pin": "'.$pin.'",
// "stcd": "'.$buyer_state_code.'",
// "pos": "'.$buyer_state_code.'",
// "ph": "'.$phone1.'",
// "em": "test@einv.com"
// ';
// $docDtls='
// "typ": "INV",
// "no": "'.$inv_no_db.'",
// "dt": "'.$inv_date.'"
// ';
$doc_details='
"supplyType": "O",
"subSupplyType": "8",
"subSupplyDesc": "Supply",
"docType": "CHL",
"docNo": "'.$inv_no_db.'",
"docDate": "'.$inv_date.'"
';
/*
//subSupplyType
1 Supply
2 Import
3 Export
4 Job Work
5 For Own Use
6 Job work Returns
7 Sales Return
8 Others
9 SKD/CKD
10 Line Sales
11 Recipient Not Known
12 Exhibition or Fairs
//docType
INV Tax Invoice
BIL Bill of Supply
BOE Bill of Entry
CHL Delivery Challan
CNT Credit Note
OTH Others
//Transportation Mode
1 Road
2 Rail
3 Air
4 Ship
*/
//$co_name="Test 163 sample";
$from_details='
"fromGstin": "'.$co_gstin.'",
"fromTrdName": "'.$co_name.'",
"fromAddr1": "'.$co_add1.'",
"fromAddr2": "'.$co_add2.'",
"fromPlace": "'.$co_loc.'",
"fromPincode": "'.$co_pin.'",
"actFromStateCode": "'.$co_state_code.'",
"fromStateCode": "'.$co_state_code.'"
';
if($tv=='y'){
$gstin="27AACCK4472B1ZS";
$buyer_state_code="27";
$pin="411052";
echo "LNO 193 :: Test BUYER DETAILS GSTIN-$gstin, tostatecode-$buyer_state_code & PINcode-$pin
";
}
$to_details='
"toGstin": "'.$gstin.'",
"toTrdName": "'.$buyer_name.'",
"toAddr1": "'.$address1.'",
"toAddr2": "'.$address2.'",
"toPlace": "'.$city.'",
"toPincode": "'.$pin.'",
"actToStateCode":"'.$buyer_state_code.'",
"toStateCode": "'.$buyer_state_code.'"
';
$filecontents.="=====buyerDtls=====\n".$from_details."\n";
$filecontents.="=====docDtls=====\n".$doc_details."
";
$filecontents.="=====sellerDtls=====\n".$to_details."\n";
// $shipto_gstin=$gstin;
$shipto_gstin="";
$shipto_name="";
$txn_details='
"transactionType":"1",
"dispatchFromGSTIN":"'.$co_gstin.'",
"dispatchFromTradeName":"'.$co_name.'",
"shipToGSTIN":"'.$shipto_gstin.'",
"shipToTradeName":"'.$shipto_name.'"
';
/*
//TransactionType
1 Regular
2 Bill To Ship To
3 Bill From Dispatch From
4 Combination of 2 and 3
For type 2, shipToGSTIN, , shipToTradeName may be passed, for type 3,
dispatchFromGSTIN , dispatchFromTradeName may be passed and for type 4, both may
be passed
*/
// $q159="SELECT * FROM [SALES_D] WHERE [DOC_NO]='$inv_id'";
$q159="SELECT * FROM [DC_D] WHERE [DOC_NO]='$inv_id'";
// echo $q159."
";
$git=sqlsrv_query($conn,$q159);
if(!$git){echo "Err: ";}
while($gitr=sqlsrv_fetch_array($git,SQLSRV_FETCH_ASSOC)){
$temp_item_id=$gitr["I_CODE"];
$temp_qty=$gitr["QTY"];
$temp_rate=$gitr["RATE"];
// echo "$temp_qty, $temp_rate
";
// $discount_amt=$gitr["DISCOUNT"];
$temp_item_unit=$gitr["UNIT"];
if($tv=='y')
{
$temp_item_unit="KGS";
echo "UNIT Changed to KGS. Change in master if not done
" ;
}
$other_charges=$gitr["othersamt"];
$tot_other_charges+=sprintf('%01.2f',$other_charges);
// $temp_item_name1=$gitr["item_name"];
$temp_tax_per=($gitr["IGST"]+$gitr["CGST"]+$gitr["SGST"]);
if((substr($gstin,0,2))==(substr($co_gstin,0,2))){
$cgst_amt=$temp_qty*$temp_rate*$temp_tax_per/200;
$sgst_amt=$temp_qty*$temp_rate*$temp_tax_per/200;
$igst_amt=0;
// $temp_tax_per=$temp_tax_per_c+$temp_tax_per_s;
// echo "Intrastate";
$cgst_rate=$temp_tax_per/2;
$sgst_rate=$temp_tax_per/2;
$igst_rate=0;
$tot_cgst_amt=$tot_tax_amt/2;
$tot_sgst_amt=$tot_tax_amt/2;
$tot_igst_amt=0;
}else{
$cgst_amt=0;
$sgst_amt=0;
// $temp_tax_per=$gitr["IGST"];
$igst_amt=$temp_qty*$temp_rate*$temp_tax_per/100;
// echo "Interstate";
$cgst_rate=0;
$sgst_rate=0;
$igst_rate=$temp_tax_per;
$tot_igst_amt=$tot_tax_amt;
$tot_cgst_amt=0;
$tot_sgst_amt=0;
}
// echo "
TTP$tax_amt $temp_tax_per SGSTA $sgst_amt, CGSTA$cgst_amt , IGST A$igst_amt
";
// echo "$tot_tax_amt, $tot_igst_amt, $tot_cgst_amt,$tot_sgst_amt
";
// $temp_discount_amt=$gitr["discount_amt"];
// $gitdet=sqlsrv_query($conn, "SELECT [I_NAME],[UNIT],[HSN_SAC_CODE] FROM [ITEM_MASTER] WHERE [I_CODE]='$temp_item_id'");
$q267= "SELECT [I_NAME],[HSN_SAC_CODE] FROM [ITEM_MASTER] WHERE [I_CODE]='$temp_item_id'";
// echo "$q267;
";
$gitdet=sqlsrv_query($conn, $q267);
while($gitdetr=sqlsrv_fetch_array($gitdet,SQLSRV_FETCH_ASSOC)){
$temp_item_name=$gitdetr["I_NAME"];
//$temp_item_unit=$gitdetr["UNIT"];
$temp_vat_code=$gitdetr["HSN_SAC_CODE"];
}
// echo "iid $temp_item_id $temp_vat_code $temp_item_unit
";
//$temp_item_unit=$mysqli->result($gitdet,0,"unit");
// if($tt==0){}
if($tt>0){
$item_data_details.=",";
}
$tt++;
$temp_line=sprintf('%01.2f',($temp_qty*$temp_rate));
// $temp_tax_amt=sprintf('%01.2f',($temp_qty*$temp_rate*$temp_tax_per/100));
$sub_total=$sub_total+$temp_line;
$ald=sprintf('%01.2f',($temp_line-$temp_discount_amt));
$tot_ald+=$ald;
//$ald=sprintf('%01.2f',$ald);
//$tot_tax_amt=$tot_tax_amt+$temp_tax_amt;
// $tot_discount=$tot_discount+$temp_discount_amt;
$l_st=$ald+$temp_tax_amt;
$tot_st=$tot_st+$l_st;
// $tot_cgst_amt+=$cgst_amt;;
// $tot_sgst_amt+=$sgst_amt;
// $tot_igst_amt+=$igst_amt;;
$totItemVal=sprintf('%01.2f',(($temp_qty*$temp_rate)+($temp_qty*$temp_rate*$temp_tax_per/100)+$other_charges));
$item_data_details.=' {
"productName":"'.ucwords(strtolower($temp_item_name)).'",
"productDesc":"'.ucwords(strtolower($temp_item_name)).'",
"hsnCode": "'.$temp_vat_code.'",
"quantity": "'.$temp_qty.'",
"qtyUnit": "'.strtoupper($temp_item_unit).'",
"cgstRate": "'.$cgst_rate.'",
"sgstRate": "'.$sgst_rate.'",
"igstRate": "'.$igst_rate.'",
"cessRate": "0",
"cessNonAdvol":"0",
"taxableAmount":"'.sprintf('%01.2f',($temp_rate*$temp_qty)).'"
}';
}
$filecontents.="=====itemList=====\n".$itemList."\n
";
$value_details='
"otherValue":"'.($frieght_amt+$insurance_amt).'",
"totalValue": "'.sprintf('%01.2f',($sale_amt)).'",
"cgstValue": "'.sprintf('%01.2f',$tot_cgst_amt).'",
"sgstValue": "'.sprintf('%01.2f',$tot_sgst_amt).'",
"igstValue": "'.sprintf('%01.2f',$tot_igst_amt).'",
"cessValue": "0",
"cessNonAdvolValue":"0",
"totInvValue": "'.sprintf('%01.2f',$inv_amt_tot).'"
';
// echo "$item_data_details
// value details $value_details
//
";//exit;
/*
GETTING TRANSPORTER NAME
*/
$q363="SELECT * FROM [TRANSPORTER_H] WHERE [TRANSPORTER_NO]='$transporter_no'";
$get_tr_det=sqlsrv_query($conn, $q363);
if(!$get_tr_det){
echo "APE : Error in Getting Transporter details.";;
}//else{echo "ok";}
while($gtransmast=sqlsrv_fetch_array($get_tr_det, SQLSRV_FETCH_ASSOC)){
$transporter_name =$gtransmast["TRANSPORTER_NAME"];
$transporter_gstin =$gtransmast["GST_NO"];
}
// echo $q363;
//$transporter_doc_no="";//to be fetched
//$transporter_doc_date="";//to be fetched
$transporter_details='
"transporterId":"'.$transporter_gstin.'",
"transporterName": "'.$transporter_name.'",
"transDocNo": "'.$lrrr_no.'",
"transMode": "1",
"transDistance": "'.$transport_distance.'",
"transDocDate": "'.$lrrr_date.'",
"vehicleNo": "'.$vehicle_no.'",
"vehicleType": "'.$vehicle_type.'"
';
//TranMode
$filecontents.="=====TxnDtls=====\n".$txn_details."\n";
$filecontents.="=====valDtls=====\n".$value_details."\n";
$filecontents.="=====transporterDtls=====\n$q363\n".$trasporter_details."\n";
//saving JSON
//$file_path ='json_files'.DIRECTORY_SEPARATOR.date('Ym').DIRECTORY_SEPARATOR.date('d');
$file_path ='json_files/dc/'.date('Ymd');
//$set_qr_code_path = 'qr_assets/';
// If directory is not created, the create a new directory
if(!file_exists($file_path)){
mkdir($file_path);
}
//Set a file name
$filename = $file_path."/EWB-DC-".$inv_id."-".time().'.log';
append_file($filename,$filecontents);
function write_file($filename,$newdata)
{
$f=fopen($filename,"w");
fwrite($f,$newdata);
fclose($f);
}
function append_file($filename,$newdata)
{
$f=fopen($filename,"a");
fwrite($f,$newdata);
fclose($f);
}
function read_file($filename)
{
$f=fopen($filename,"r");
$data=fread($f,filesize($filename));
fclose($f);
return $data;
}
// echo "here 359";
//!saving JSON
?>