function registerDoc()
{
require_once '../../../../accountancy/import/salary/salary.class.php';
$AccDocObj = new ImportSalary($_POST["pay_year"], $_POST["pay_month"]);
if ($AccDocObj->InitialImportance($_POST["PersonType"] == "contract") === false) {
echo Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("<br>"));
die;
}
$query = "\t\n\t\tselect c.CostCenterID,\n\t\t\t\tc.Title,\n\t\t\t\tsit.CostID,\n\t\t\t\tsit.CostType,\n\t\t\t\tcase s.person_type when 1 then if(w.emp_state=11, 'ConditionalProf', 'Prof')\n\t\t\t\t\t\t\t\t when 2 then 'Staff'\n\t\t\t\t\t\t\t\t when 3 then 'Worker'\n\t\t\t\t\t\t\t\t when 5 then 'Contract' end PersonType, \n\t\t\t\ts.last_retired_pay,\n\t\t\t\tw.emp_state,\n\t\t\t\tc.AccUnitID,\t\t\t\t\n\t\t\t\tpit.salary_item_type_id,\n\t\t\t\tsum(pit.pay_value) pay_value,\n\t\t\t\tsum(pit.diff_value_coef * pit.diff_pay_value) diff_pay_value,\n\t\t\t\tsum(param7) param7,\n\t\t\t\tsum(diff_param7_coef * diff_param7) diff_param7,\n\t\t\t\tsum(param2) param2,\n\t\t\t\tsum(diff_param2_coef * diff_param2) diff_param2,\n\t\t\t\tsum(param3) param3,\n\t\t\t\tsum(diff_param3_coef * diff_param3) diff_param3\n\t\t\t\t\n\t\tFROM payments p \n\t\t\tJOIN staff s ON s.staff_id = p.staff_id\n\t\t\tJOIN writs w\n\t\t\t\tON(p.writ_id = w.writ_id AND\n\t\t\t\t p.writ_ver = w.writ_ver AND\n\t\t\t\t p.staff_id = w.staff_id AND w.state=3)\n\n\t\t\tJOIN payment_items pit \n\t\t\t\tON(p.pay_year = pit.pay_year AND p.pay_month = pit.pay_month AND\n\t\t\t\t p.staff_id = pit.staff_id AND p.payment_type = pit.payment_type)\n\n\t\t\tJOIN persons per ON (per.personid = s.personid )\n\t\t\tJOIN banks b ON b.bank_id = p.bank_id\n\t\t\tJOIN CostCenterPlan c ON c.CostCenterID = w.CostCenterID\n\t\t\tJOIN salary_item_types sit using(salary_item_type_id)\n\t\t\t\n\t\tWHERE p.pay_year = :py and p.pay_month = :pm and p.payment_type = 1 \n\t\t\tand s.person_type in(" . ($_POST["PersonType"] == "contract" ? "5" : "1,2,3") . ") AND sit.CostID>0\n\n\t\tgroup by c.CostCenterID , s.person_type , p.payment_type , pit.salary_item_type_id\n\t\torder by c.CostCenterID,pit.salary_item_type_id";
$dt = PdoDataAccess::runquery_fetchMode($query, array(":py" => $_POST["pay_year"], ":pm" => $_POST["pay_month"]));
$AccError = "";
while ($row = $dt->fetch()) {
$amount = 0;
switch ($row["salary_item_type_id"]) {
case 44:
if ($row["PersonType"] == "ConditionalProf") {
$row["CostID"] = 19023;
}
$amount = $row["pay_value"] + $row["diff_pay_value"];
break;
//..................................................................
//..................................................................
case 143:
case 38:
$coef_dolat = 1.7 / 1.65;
$amount = $row["param7"] + $row["diff_param7"] + ($row["param7"] + $row["diff_param7"]) * $coef_dolat;
break;
//..................................................................
//..................................................................
case 9920:
case 144:
$amount = $row["param2"] + $row["diff_param2"];
break;
case 145:
$amount = $row["param2"] + $row["diff_param2"] + $row["param3"] + $row["diff_param3"];
break;
case 744:
$amount = $row["param2"] + $row["diff_param2"];
break;
//..................................................................
//..................................................................
case 149:
case 150:
case 750:
$amount = $row["param3"] + $row["diff_param3"];
break;
//..................................................................
//..................................................................
case 9931:
if ($row["PersonType"] == "Staff" || $row["PersonType"] == "Contract") {
$row["CostID"] = 341;
}
if ($row["PersonType"] == "Worker") {
$row["CostID"] = 342;
}
$amount = $row["pay_value"] + $row["diff_pay_value"];
break;
//..................................................................
//..................................................................
default:
$amount = $row["pay_value"] + $row["diff_pay_value"];
}
$AccDocObj->AddItem($row["AccUnitID"], $row["CostID"], $amount, $row["PersonType"]);
if (ExceptionHandler::GetExceptionCount() > 0) {
$AccError .= "مرکز هزینه : " . $row["Title"] . "<br><hr><br>";
$AccError .= "<span style=color:red><h3>" . ExceptionHandler::GetExceptionsToString("<br>") . "</h3></span>";
}
ExceptionHandler::PopAllExceptions();
}
$AccDocObj->CommitImportance();
echo Response::createObjectiveResponse($AccError == "", $AccError);
die;
}
$OverTimeRoozMozd + $OverTimeGharardadi ) . '</td>
<td>' . (round($mp_bimeh_dastgah) + round($p_bimeh_dastgah) + round($e_bimeh_dastgah) + round($r_bimeh_dastgah) + round($gh_bimeh_dastgah) + $rowPlanItem ) . '</td>
<td>' . ($mp_bimeh_dolat + $p_bimeh_dolat + $e_bimeh_dolat + $r_bimeh_dolat + $gh_bimeh_dolat ) . '</td>
<td>' . ($mp_made_kharej_Az_shomool + $p_made_kharej_Az_shomool + $e_made_kharej_Az_shomool +
$r_made_kharej_Az_shomool27 + $r_made_kharej_Az_shomool38 + $gh_made_kharej_Az_shomool27 + $gh_made_kharej_Az_shomool38 + $ExtraMProf + $ExtraProf + $ExtraEmp +
$ExtraRoozMozd + $ExtraGharardadi ) . '</td>
<td>' . ($mp_jazb_omana + $p_jazb_omana + $e_jazb_omana + $r_jazb_omana + $gh_jazb_omana) . '</td>
<td>' . ($mp_sum + $p_sum + $e_sum + $r_sum + $gh_sum + $ExtraMProf + $ExtraProf + $ExtraEmp + $ExtraRoozMozd + $ExtraGharardadi +
$OverTimeMProf + $OverTimeProf + $OverTimeEmp + $OverTimeRoozMozd + $OverTimeGharardadi + $rowPlanItem ) . '</td>
</tr></table><br>';
echo "</center>";
if($regAccDoc)
{
$AccDocObj->CommitImportance();
?>
<script>
var elems = document.getElementsByClassName("reportGenerator");
for(i=0; i < elems.length; i++)
elems[i].style.visibility = "hidden";
</script>
<?
if(!$AccError)
{
ob_get_clean();
echo "<h3>" . "پیش سند حقوق مربوط به این ماه با موفقیت صادر گردید." . "</h3>";
}
}
