| Server IP : 27.254.152.13 / Your IP : 216.73.217.38 Web Server : Apache/2 System : Linux ns1-252017.dragonhispeed.com 5.2.0 #1 SMP Fri Mar 29 22:50:14 MSK 2024 x86_64 User : coloflew ( 1072) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/coloflew/domains/fulltion.com/public_html/administrator/ |
Upload File : |
<html>
<head>
</head>
<body>
<?php
//require('../FPDF/fpdf.php');
//define('FPDF_FONTPATH','font/');
@$where_lang = " lang_code = '".@$lang_code."'";
if(@$_POST['Fromdate']){@$fromdate = @$_POST['Fromdate'];}
$EmpID = $_SESSION['member']['userid'] ? $_SESSION['member']['userid'] :@$_POST['EmpID'] ;
@$dt_fi = @$objMaster->getdateformat(@$fromdate);
@$where_f = "";
@$getreport = @$db->getJoin("DISTINCT a.InvoiceDetailID,b.*","tasoft_hist a left outer join tasoft_invoice b on a.InvoiceID = b.InvoiceID "," a.status = '1' And b.InvoiceEmpID = '".@$EmpID."' and HistDatetime between '".@$objMaster->getdateformat(@$fromdate)." 00:00:00'and '".@$objMaster->getdateformat(@$fromdate)." 23:59:59' and b.InvoiceID not in (select InvoiceID from tasoft_invoice where InvoiceStatus = 6)");
@$getempname = @$db->getOne("admin","*","EmpID = '".@$EmpID."'");
@$getpointname = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$getempname['DeliveryPointID']."'");
@$nm_emp = @$getempname['EmpName']." ".@$getempname['EmpSurName'];
@$fi_nmemp = @$getempname['EmpID'];
@$ae = @$getpointname['DeliveryPointName'];
$pdf->AliasNbPages( 'tp' );
$_SESSION['header_tb']['0'] = @$lang_set['routexpoint_sequence'];
$_SESSION['header_tb']['1'] = @$lang_set['recvdetailproduct'];
$_SESSION['header_tb']['2'] = @$lang_set['invoice_code'];
$_SESSION['header_tb']['3'] = @$lang_set['invoice_end'];
$_SESSION['header_tb']['4'] = @$lang_set['txt_price'];
$_SESSION['header_tb']['5'] = @$lang_set['txt_discount'];
$_SESSION['header_tb']['6'] = @$lang_set['txt_net'];
$_SESSION['txt_page'] = @$lang_set['txt_page'];
$_SESSION['header_fromdate'] = $fromdate;
$_SESSION['date_print'] = @$objMaster->getdbdateformat(date("Y-m-d"));
$_SESSION['txt_nm_coparate'] = @$lang_set['txt_nm_coparate'];
$_SESSION['txt_date'] = @$lang_set['txt_date'];
$_SESSION['txt_address_coperate'] = @$lang_set['txt_address_coperate'];
$_SESSION['txt_report_sum_emp'] = @$lang_set['txt_report_sum_emp'];
$_SESSION['emp_name'] = @$lang_set['emp_name'];
$_SESSION['emp_deliverypoint'] = @$lang_set['emp_deliverypoint'];
$_SESSION['update_date'] = @$lang_set['update_date'];
$_SESSION['nm_emp'] = @$nm_emp;
$_SESSION['ae'] = @$ae;
$pdf->AddPage($orientation='',$format='','0');
//$pdf->AddPage('','','0');
//$pdf->Header('1');
$pdf->SetFont('angsa','',12);
@$summoney = 0;
@$discount = 0;
//@$getproduct = array();
if(@$getreport){
foreach(@$getreport as $key => $va){
@$getreport[$key]['i_summoney'] = 0;
@$getreport[$key]['i_discount'] = 0;
$getNameProduct = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$va['InvoiceEndPoint']."' ");
@$getreport[$key]['DeliveryPointName'] = $getNameProduct['DeliveryPointName'];
@$getproduct = @$db->getOne("invoicedetail","*","InvoiceDetailID = '".@$va['InvoiceDetailID']."'");
@$getreport[$key]['totalmoney'] = @$getproduct['totalmoney'];
@$getreport[$key]['Saleper'] = @$getproduct['Saleper'];
@$getreport[$key]['ProductName'] = $getproduct['ProductName'];
//@$discount = @$discount + floor((@$getproduct['totalmoney'] * @$getproduct['Saleper'] / 100));
@$getreport[$key]['i_summoney'] = @$getreport[$key]['i_summoney'] + floor(@$getreport[$key]['totalmoney'] * 100 / (100 - @$getreport[$key]['Saleper']));
//@$i_summoney = @$i_summoney + floor(@$getreport[$key]['totalmoney'] * 100 / (100 - @$getreport[$key]['Saleper']));
@$getreport[$key]['i_discount'] = @$getreport[$key]['i_discount'] + floor(@$getreport[$key]['totalmoney'] * 100 / (100 - @$getreport[$key]['Saleper'])) - @$getreport[$key]['totalmoney'];
@$summoney = @$summoney + @$getproduct['totalmoney'];
@$discount = @$discount + @$getreport[$key]['i_discount'];
//@$i_discount = @$i_discount + floor(@$getreport[$key]['totalmoney'] * 100 / (100 - @$getreport[$key]['Saleper'])) - @$getreport[$key]['totalmoney'];
//;
} //foreach($getreport as $key => $va)
} // if(@$getreport)
@$word_sum = @$lang_set['sum'];
//$pdf->BasicTable(@$header,@$getreport,@$getproduct,@$summoney,@$discount,@$word_sum);
$pdf->BasicTable(@$getreport,@$summoney,@$discount,@$word_sum);
//@$b_mnm = $_SESSION['member']['username'];
@$b_mnm = $_SESSION['member']['userid'];
//$pdf->Output("../FPDF/report_saleemp_".$b_mnm."_".@$fi_nmemp."_".@$dt_fi.".pdf","F");
$pdf->Output("../ReportFilePDF/report_saleemp_".$b_mnm."_".@$fi_nmemp."_".@$dt_fi.".pdf","F");
?>
<?php //echo "<pre>"; print_r($ba); ?>
<!-- PDF Created Click <a href="../FPDF/MyPDF_nui.pdf">here</a> to Download -->
<meta http-equiv="refresh" content="0;URL=<?php echo URL;?>ReportFilePDF/report_saleemp_<?php echo @$b_mnm;?>_<?php echo @$fi_nmemp;?>_<?php echo @$dt_fi;?>.pdf">
<?PHP echo "<script>t = 3*1000;
setTimeout('window.close()',t);
</script>";?>
</body>
</html>