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>
<?
}
