function ShowReport(){ global $tableQuery; $rpt = new ReportGenerator(); $rpt->mysql_resource = PrepareData(); ?> <html> <head> <META http-equiv=Content-Type content="text/html; charset=UTF-8" > </head> <body dir=rtl> <div style="display:none" > <? echo $tableQuery . "\n----------------------------------------------------\n";?> <? echo PdoDataAccess::GetLatestQueryString();?> </div> <? function moneyRender($row,$value){ return number_format($value, 0, '.', ','); } function pure_paymentRender($row){ return moneyRender(null,$row["pure_payment"]) . "<br>" . moneyRender(null,$row["diff_pure_payment"]); } function continus_paymentRender($row){ return moneyRender(null,$row["continus_payment"]) . "<br>" . moneyRender(null,$row["diff_continus_payment"]); } function totalRender($row){ return moneyRender(null, $row["normal_insure"] + $row["normal2_insure"] + $row["first_surplus_insure"] + $row["second_surplus_insure"]); } function insure_valueRender($row){ return moneyRender(null,$row["insure_value"]) . "<br>" . moneyRender(null,$row["diff_insure_value"]); } function org_insure_valueRender($row){ return moneyRender(null,$row["org_insure_value"]) . "<br>" . moneyRender(null,$row["diff_org_insure_value"]); } $rpt->addColumn("شماره<br> شناسایی", "staff_id"); $rpt->addColumn("نام خانوادگي", "plname"); $rpt->addColumn("نام", "pfname"); $rpt->addColumn("خالص دريافتي <br>تفاوت", "pure_payment", "pure_paymentRender"); $rpt->addColumn("مستمر<br>تفاوت", "continus_payment", "continus_paymentRender"); $rpt->addColumn("کل", "normal_insure", "totalRender"); $rpt->addColumn("مازاد2", "second_surplus_insure"); $rpt->addColumn("مازاد1", "first_surplus_insure"); $rpt->addColumn("معمولي2", "normal2_insure"); $rpt->addColumn("معمولي", "normal_insure"); $rpt->addColumn("مبلغ بيمه<br>تفاوت", "insure_value", "insure_valueRender"); $rpt->addColumn("سهم سازمان<br>تفاوت", "org_insure_value", "org_insure_valueRender"); $rpt->header_alignment = "center"; $rpt->headerContent = " <table width=100% border=0 style='font-family:b nazanin;'> <tr> <td width=120px><img src='/HumanResources/img/fum_symbol.jpg'></td> <td align=center style='font-weight:bold'>گزارش کارمندان استفاده کننده از بيمه</td> <td width=120px> شماره : <br> تاریخ : " . DateModules::shNow() . " </td> </tr> <tr bgcolor='#BDD3EF' > <td colspan=3 style='border: 1px solid black;font-weight:bold;color:#15428B;padding-right:5px'> " . DateModules::GetMonthName($_POST["pay_month"]) . " ماه " . $_POST["pay_year"] . " </td> </tr> </table>"; $rpt->page_size = 30; $rpt->paging = true; $rpt->generateReport(); die(); ?> </body> </html> <? }
function GetWorkTimeExcel(){ $param = array(); MakeWhere($where, $param); $rpt = new ReportGenerator(); $rpt->mysql_resource = PrepareData(); $rpt->addColumn("شماره شناسایی", "staff_id"); $rpt->addColumn("نام خانوادگي", "plname"); $rpt->addColumn("نام", "pfname"); $rpt->addColumn("واحد اصلی محل خدمت", "unit_title"); $rpt->addColumn("واحد فرعی محل خدمت", "sub_unit_title"); $rpt->addColumn("کارکرد", "work_time"); $rpt->excel = true; $rpt->generateReport(); die(); }
function ShowReport(){ global $GroupCostCenter; global $GroupPersonType; ?> <html> <head> <META http-equiv=Content-Type content="text/html; charset=UTF-8" > <style> .header { background-color: #D9EBFF; font-weight: bold; font-size: 10px !important; } .header td{ font-size: 11px !important; } /*-----------------------*/ #outer table { border : 0px; border-collapse: collapse; width : 100%; } #outer tr { border : 1px solid black; border-bottom: 0px; } #outer td { font-family: tahoma; font-size: 10px; height : 21px; } /*-----------------------*/ #inner table { border : 0px; border-collapse: collapse; width : 100%; } #inner td { font-family: tahoma; padding-right : 3px; font-size: 10px; height : 21px; border-collapse: collapse; border : 1px solid black; } </style> </head> <body dir=rtl> <? $person_count; $salaryItems = array(); global $MainQuery; $MainRows = PrepareData($person_count,$_GET['RepType']); $currentGroup = ""; for($i=0; $i < count($MainRows); $i++) { $row = $MainRows[$i]; $group = $GroupCostCenter ? $row["cost_center_id"] . "_" : "ALL_"; $group .= $GroupPersonType ? $row["person_type"] : "ALL"; if($currentGroup != $group) { if($currentGroup != "") { makeBody($salaryItems); makeFooter(); } makeHeader($row, $person_count); $currentGroup = $group; $i--; $salaryItems = array(); continue; } $salaryItems[ $row["salary_item_type_id"] ] = $row; $salaryItems[ $row["salary_item_type_id"] ]["value"] = ($row["effect_type"] == "1") ? $row["pay_sum"] : $row["get_sum"]; $salaryItems[ $row["salary_item_type_id"] ]["diff_value"] = ($row["effect_type"] == "1") ? $row["diff_pay_sum"] : $row["diff_get_sum"]; } //--------- for last costcenter -------------- makeBody($salaryItems); makeFooter(); ?> <div style="display:none"><?= $MainQuery ?></div> </body> </html> <? }