";
$gam=sqlsrv_query($conn,$q72);
while($gar=sqlsrv_fetch_array($gam,SQLSRV_FETCH_ASSOC)) {
$buyer_name=$gar["DRCR_NAME"];
$gamres=sqlsrv_query($conn, "SELECT * FROM [CUS_SUP_ADDRESS_D] WHERE [DRCR_CODE]='$account_id' AND [SL_NO]='$delivery_to'");
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"];
$em=$gamr["EMAIL_ID"];
$gstin=$gamr["GST_NO"];
$temp_sup_type=$gamr["GST"];
$buyer_state_code=$gamr["STATE"];
if($temp_sup_type=='A'){$sup_type="B2B";}
elseif($temp_sup_type=="C"){$sup_type="EXPWP";}
elseif($temp_sup_type=="I"){$sup_type="EXPWOP";}
elseif($temp_sup_type=="D"){$sup_type="SEZWP";}
elseif($temp_sup_type=="K"){$sup_type="SEZWOP";}
elseif($temp_sup_type=="J"){$sup_type="DEXP";}
// if(strtoupper($gstin)!="URP"){
// $buyer_state_code=substr($gstin,0,2);
// }else{
// $buyer_state_code=96; // For Exports
// } //$buyer_state_code=substr($gstin,0,2);
}
}
$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": "'.$em.'"
';
$q114="SELECT * FROM [SALES_CATEGORY_MASTER] WHERE [DOC_NO]='$SALES_CATEGORY_DOC_NO' ";
$get_typ=sqlsrv_query($conn,$q114);
if(!$get_typ){echo "APE: ERR LNO 116";}
while($gettyp_ro=sqlsrv_fetch_array($get_typ,SQLSRV_FETCH_ASSOC)){
$doc_typ=$gettyp_ro["TYPE"];
}
$docDtls='
"typ": "'.$doc_typ.'",
"no": "'.$inv_no_db.'",
"dt": "'.$inv_date.'"
';
$filecontents.="=====sellerDtls=====\n".$sellerDtls."\n
";
$filecontents.="=====docDtls=====\n".$docDtls."\n
";
$filecontents.="=====buyerDtls=====\n".$buyerDtls."\n
";
$q159="SELECT * FROM [SALES_D] WHERE [DOC_NO]='$inv_id'";
$git=sqlsrv_query($conn,$q159);
if(!$git){echo "APE:Err: LNO132";}//else{echo "e128 $q159";}
while($gitr=sqlsrv_fetch_array($git,SQLSRV_FETCH_ASSOC)){
$temp_item_id=$gitr["I_CODE"];
$temp_qty=$gitr["BALANCEAMOUNT"];
$temp_rate=$gitr["RATE"];
//$discount_amt=$gitr["DISCOUNTAMT"];// MOVED TO TEMP_DISC_AMT 14-Nov-2022
$temp_item_unit=$temp_item_unit="Nos";
$temp_disc_amt=$gitr["QTY_DISC_VALUE"]+$gitr["DISCOUNTAMT"];
$other_charges=$gitr["othersamt"];
//$other_charges+=$gitr["INSURANCE"];//added on 14-Nov-2022
//$other_charges+=$gitr["FREIGHT"];//added on 14-Nov-2022
$tot_other_charges+=sprintf('%01.2f',$other_charges);
$temp_tax_per=($gitr["IGST"]+$gitr["CGST"]+$gitr["SGST"]);
$igst_amt=$gitr["IGSTAMT"];
$cgst_amt=$gitr["CGSTAMT"];
$sgst_amt=$gitr["SGSTAMT"];
// echo "
TTP$tax_amt $temp_tax_per SGSTA $sgst_amt, CGSTA$cgst_amt , IGST A$igst_amt
";
// echo "dis $temp_disc_amt"; exit;
$filecontents.="=====itemList-Qry=====\nSELECT [I_NAME],[HSN_SAC_CODE],[RDPF],[ISSUE_UNIT] FROM [ITEM_MASTER] WHERE [I_CODE]='$temp_item_id'\n
";
// $gitdet=sqlsrv_query($conn, "SELECT [I_NAME],[UNIT],[HSN_SAC_CODE] FROM [ITEM_MASTER] WHERE [I_CODE]='$temp_item_id'");
$gitdet=sqlsrv_query($conn, "SELECT [I_NAME],[HSN_SAC_CODE],[RDPF],[ISSUE_UNIT] FROM [ITEM_MASTER] WHERE [I_CODE]='$temp_item_id'");
while($gitdetr=sqlsrv_fetch_array($gitdet,SQLSRV_FETCH_ASSOC)){
$temp_item_name=$gitdetr["I_NAME"];
$temp_srvce_chk=$gitdetr["RDPF"];
$rdpf=$temp_srvce_chk;
if($rdpf=='F'){
$temp_item_unit="NOS";
}else{
$temp_item_unit=$gitdetr["ISSUE_UNIT"];
}
//$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){
$itemList.=",";
}
$tt++;
$temp_line=sprintf('%01.2f',($temp_qty*$temp_rate));
// $temp_tax_amt=sprintf('%01.2f',($temp_qty*$temp_rate*$temp_tax_per/100));
$temp_tax_amt=sprintf('%01.2f',(($temp_qty*$temp_rate)-$temp_disc_amt)*$temp_tax_per/100);
$sub_total=$sub_total+$temp_line;
$ald=sprintf('%01.2f',($temp_line-$temp_disc_amt));
$tot_ald+=$ald;
$tot_tax_amt=$tot_tax_amt+$temp_tax_amt;
$tot_discount=$tot_discount+$temp_disc_amt;
$l_st=$ald+$temp_tax_amt;
$tot_st=$tot_st+$l_st;
if(strtoupper($temp_srvce_chk)=='SR'){$isServc="Y";}else{$isServc="N";}
$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));
$totItemVal=sprintf('%01.2f',(($temp_qty*$temp_rate)+$temp_tax_amt+$other_charges-$temp_disc_amt));
// exit("ald $ald ($temp_qty*$temp_rate)-$temp_disc_amt $igst_amt, $cgst_amt, $sgst_amt docNo$inv_id");
$itemList.='{
"slNo": "'.$tt.'",
"prdDesc": "'.ucwords(strtolower($temp_item_name)).'",
"isServc": "'.$isServc.'",
"hsnCd": "'.$temp_vat_code.'",
"qty": "'.sprintf('%01.3f',$temp_qty).'",
"unit": "'.strtoupper($temp_item_unit).'",
"unitPrice": "'.$temp_rate.'",
"totAmt": "'.(sprintf('%01.2f',($temp_qty*$temp_rate))).'",
"discount": "'.sprintf('%01.2f',$temp_disc_amt).'",
"assAmt": "'.(sprintf('%01.2f',$ald)).'",
"gstRt": "'.sprintf('%01.2f',$temp_tax_per).'",
"igstAmt": "'.sprintf('%01.2f',$igst_amt).'",
"cgstAmt":"'.sprintf('%01.2f',$cgst_amt).'",
"sgstAmt":"'.sprintf('%01.2f',$sgst_amt).'",
"cesRt": 0,
"cesAmt": 0,
"cesNonAdvlAmt": 0,
"stateCesRt": 0,
"stateCesAmt": 0,
"stateCesNonAdvlAmt": 0,
"othChrg": "'.sprintf('%01.2f',$other_charges).'",
"totItemVal":"'.$totItemVal.'"
}';
}
$filecontents.="=====itemList=====\n".$itemList."\n
";
//echo "GST TYPE =$gst_type
$inv_date>= $gst_imple_date";
$sub_total4=$sub_total-$tot_discount+$fwd+$tot_tax_amt+$fwd_tax_amt+$tot_other_charges;
// $roundoff=$inv_amt-$sub_total4;
// $roundoff=round($inv_amt)-$inv_amt;
// echo "tot_st : $tot_st Sto 4 $sub_total4, $roundoff roundoff=$inv_amt-$sub_total4
";
//$inv_amt_tot
// $inv_amt_tot=round($inv_amt)+$roundoff;
// echo "
$tot_ald+$tot_other_charges+$roundoff
";
$valDtls='
"assVal": '.sprintf('%01.2f',($tot_ald)).',
"cgstVal":'.sprintf('%01.2f',$tot_cgst_amt).',
"sgstVal":'.sprintf('%01.2f',$tot_sgst_amt).',
"igstVal":'.sprintf('%01.2f',$tot_igst_amt).',
"cesVal": 0,
"stCesVal": 0,
"totInvVal": '.sprintf('%01.2f',($sub_total4+$roundoff)).',
"rndOffAmt": '.sprintf('%01.2f',$roundoff).'';
$filecontents.="=====valDtls=====\n".$valDtls."\n
";
//saving JSON
//$file_path ='json_files'.DIRECTORY_SEPARATOR.date('Ym').DIRECTORY_SEPARATOR.date('d');
$file_path ='json_files/'.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."/".$inv_id."-".time().'.log';
append_file($filename,$filecontents);
// echo $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
?>