function selectEmp()
{
$where = " eh.PersonID = :PID ";
$whereParam = array();
$whereParam[":PID"] = $_GET["Q0"];
$field = isset($_GET["fields"]) ? $_GET["fields"] : "";
if (isset($_GET["query"]) && $_GET["query"] != "") {
switch ($field) {
case "organization":
$where .= " AND organization LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
case "unit":
$where .= " AND unit LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
case "from_date":
$where .= " AND from_date = :qry1 ";
$whereParam[":qry1"] = $_GET["query"];
break;
case "to_date":
$where .= " AND to_date = :qry1 ";
$whereParam[":qry1"] = $_GET["query"];
break;
case "org_title":
$where .= " AND org_title = :qry1 ";
$whereParam[":qry1"] = $_GET["query"];
break;
case "unempTitle":
$where .= " AND unempTitle = :qry1 ";
$whereParam[":qry1"] = $_GET["query"];
break;
case "title":
$where .= " AND title LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
}
}
$no = manage_person_employment::CountEmp($where, $whereParam);
$where .= dataReader::makeOrder();
$where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : "";
$temp = manage_person_employment::GetAllEmp($where, $whereParam);
echo dataReader::getJsonData($temp, $no, $_GET["callback"]);
die;
}
$total_year += $year;
$total_month += $month;
$total_day += $day;
}
}
//....................... سربازی .......................................
$query = " select military_from_date , military_to_date , military_duration\n\t\t\t\t\t\tfrom persons where PersonID = " . $res[$i]['PersonID'];
$Mrow = PdoDataAccess::runquery($query);
if (isset($Mrow[0]["military_duration"]) && $Mrow[0]["military_duration"] > 0) {
$total_year += floor($Mrow[0]["military_duration"] / 12);
$total_month += $Mrow[0]["military_duration"] - floor($Mrow[0]["military_duration"] / 12) * 12;
$total_day += 0;
}
//.......................... سابقه کاری ......................
require_once "../../../personal/persons/class/employment.class.php";
$temp = manage_person_employment::GetAllEmp("PersonID=" . $res[$i]['PersonID']);
for ($k = 0; $k < count($temp); $k++) {
if ($temp[$k]["retired_duration_year"] != 0 || $temp[$k]["retired_duration_month"] != 0 || $temp[$k]["retired_duration_day"] != 0) {
$total_year += $temp[$k]["retired_duration_year"];
$total_month += $temp[$k]["retired_duration_month"];
$total_day += $temp[$k]["retired_duration_day"];
}
}
//..........................................................
$TotalDay = DateModules::ymd_to_days($total_year, $total_month, $total_day);
//DateModules::day_to_ymd($TotalDay, $Tyear, $Tmonth, $Tday);
//................ ذخیره مقدارنهایی
$query = " insert into YearRedemption (PersonID,duration,value,year,writ_id,writ_ver) values \n\t\t\t (" . $res[$i]['PersonID'] . "," . round($TotalDay / 360, 2) . "," . $res[$i]['sv'] . " ," . $_REQUEST['pay_year'] . "," . $res2[$j - 1]['writ_id'] . "," . $res2[$j - 1]['writ_ver'] . "); ";
}
PdoDataAccess::runquery($query);
//.....................................................................
continue;
}
$row_index = $i;
$valid_writs[] = $data[$i];
//if($i == $index && $data[$i][all_annual_effect] == 3 && $data[$i][all_show_in_summary_doc] == 0)
// continue;
if ($index == $i) {
if ($data[$i][military_from_date] != "" && $data[$i][military_to_date] != "" && $data[$i][military_duration] != "") {
$history_row[DateModules::miladi_to_shamsi($data[$i][military_from_date]) . "_1"] = "<tr>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($data[$i][military_from_date]) . "</td>\n\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($data[$i][military_to_date]) . "</td>\n\t\t\t\t\t<td>" . floor($data[$i][military_duration] / 12) . "</td>\n\t\t\t\t\t<td>" . ($data[$i][military_duration] - floor($data[$i][military_duration] / 12) * 12) . "</td>\n\t\t\t\t\t<td>0</td>\n\t\t\t\t\t<td>قابل قبول</td>\n\t\t\t\t\t<td>سربازی</td>\n\t\t\t\t\t<td>سربازی</td>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td> </td>\n\t\t\t\t</tr>";
$total_year += floor($data[$i][military_duration] / 12);
$total_month += $data[$i][military_duration] - floor($data[$i][military_duration] / 12) * 12;
$total_day += 0;
}
//......................................................................
require_once "../../personal/persons/class/employment.class.php";
$temp = manage_person_employment::GetAllEmp("PersonID=" . $data[$i][PersonID]);
$history2 = "";
for ($j = 0; $j < count($temp); $j++) {
if ($temp[$j]["retired_duration_year"] != 0 || $temp[$j]["retired_duration_month"] != 0 || $temp[$j]["retired_duration_day"] != 0) {
$history_row[DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "_2"] = "<tr>\n\t\t\t\t\t\t<td>" . $temp[$j]["title"] . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["to_date"]) . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["retired_duration_year"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["retired_duration_month"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["retired_duration_day"] . "</td>\n\t\t\t\t\t\t<td>قابل قبول</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["organization"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["empstateTitle"] . "</td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>";
$total_year += $temp[$j]["retired_duration_year"];
$total_month += $temp[$j]["retired_duration_month"];
$total_day += $temp[$j]["retired_duration_day"];
}
//------------------------------------------------------------------
$year = floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25);
$month = floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"]) - floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25) * 365.25) / 30.4375);
$day = ($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"]) - floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25) * 365.25 - round(floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"]) - floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25) * 365.25) / 30.4375) * 30.4375);
if ($year != 0 || $month != 0 || $day != 0) {
$history_row[DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "_3"] = "<tr>\n\t\t\t\t\t\t<td>" . $temp[$j]["title"] . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["to_date"]) . "</td>\n\t\t\t\t\t\t<td>" . $year . "</td>\n\t\t\t\t\t\t<td>" . $month . "</td>\n\t\t\t\t\t\t<td>" . round($day) . "</td>\n\t\t\t\t\t\t<td>غیر قابل قبول</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["organization"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["empstateTitle"] . "</td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>";
$total_non_year += $year;
$row_index_all_annual_effect = $row[all_annual_effect];
continue;
}
$row_index = $i;
$row_index_all_annual_effect = $row[all_annual_effect];
$valid_writs[$cwrt] = $row;
if ($index == $i) {
if ($row[military_from_date] != "" && $row[military_from_date] != "0000-00-00" && ($row[military_to_date] != "" && $row[military_to_date] != "0000-00-00") && ($row[military_duration] != "" && $row[military_duration] != "0000-00-00")) {
$history_row[DateModules::miladi_to_shamsi($row[military_from_date]) . "_1"] = "<tr>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($row[military_from_date]) . "</td>\n\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($row[military_to_date]) . "</td>\n\t\t\t\t\t<td>" . floor($row[military_duration] / 12) . "</td>\n\t\t\t\t\t<td>" . ($row[military_duration] - floor($row[military_duration] / 12) * 12) . "</td>\n\t\t\t\t\t<td>0</td>\n\t\t\t\t\t<td>قابل قبول</td>\n\t\t\t\t\t<td>سربازی</td>\n\t\t\t\t\t<td>سربازی</td>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td> </td>\n\t\t\t\t</tr>";
$total_year += floor($row[military_duration] / 12);
$total_month += $row[military_duration] - floor($row[military_duration] / 12) * 12;
$total_day += 0;
}
//......................................................................
require_once "../../personal/persons/class/employment.class.php";
$temp = manage_person_employment::GetAllEmp("PersonID=" . $row[PersonID]);
for ($j = 0; $j < count($temp); $j++) {
if ($temp[$j]["retired_duration_year"] != 0 || $temp[$j]["retired_duration_month"] != 0 || $temp[$j]["retired_duration_day"] != 0) {
$history_row[DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "_2"] = "<tr>\n\t\t\t\t\t\t<td>" . $temp[$j]["title"] . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["to_date"]) . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["retired_duration_year"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["retired_duration_month"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["retired_duration_day"] . "</td>\n\t\t\t\t\t\t<td>قابل قبول</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["organization"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["empstateTitle"] . "</td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>";
$total_year += $temp[$j]["retired_duration_year"];
$total_month += $temp[$j]["retired_duration_month"];
$total_day += $temp[$j]["retired_duration_day"];
}
//------------------------------------------------------------------
$year = floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25);
$month = floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"]) - floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25) * 365.25) / 30.4375);
$day = ($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"]) - floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25) * 365.25 - round(floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"]) - floor((($temp[$j]["duration_year"] - $temp[$j]["retired_duration_year"]) * 365.25 + ($temp[$j]["duration_month"] - $temp[$j]["retired_duration_month"]) * 30.4375 + ($temp[$j]["duration_day"] - $temp[$j]["retired_duration_day"])) / 365.25) * 365.25) / 30.4375) * 30.4375);
if ($year != 0 || $month != 0 || $day != 0) {
$history_row[DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "_3"] = "<tr>\n\t\t\t\t\t\t<td>" . $temp[$j]["title"] . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["from_date"]) . "</td>\n\t\t\t\t\t\t<td>" . DateModules::miladi_to_shamsi($temp[$j]["to_date"]) . "</td>\n\t\t\t\t\t\t<td>" . $year . "</td>\n\t\t\t\t\t\t<td>" . $month . "</td>\n\t\t\t\t\t\t<td>" . round($day) . "</td>\n\t\t\t\t\t\t<td>غیر قابل قبول</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["organization"] . "</td>\n\t\t\t\t\t\t<td>" . $temp[$j]["empstateTitle"] . "</td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>";
$total_non_year += $year;
$total_non_month += $month;
$total_not_rasmi_year += $year;
$total_not_rasmi_month += $month;
$total_not_rasmi_day += $day;
}
}
//..........................................................................
$total_not_rasmi_year += floor($temp[$i]['military_duration'] / 12);
$total_not_rasmi_month += ($temp[$i]['military_duration'] - (floor($temp[$i]['military_duration'] / 12) * 12));
$total_not_rasmi_day += 0;
//..........................................................................
require_once $address_prefix . "/HumanResources/personal/persons/class/employment.class.php";
// $temp[$i]['PersonID'] = '100000' ;
$empRes = manage_person_employment::GetAllEmp("PersonID=" . $temp[$i]['PersonID']);
for ($j = 0; $j < count($empRes); $j++) {
if ($empRes[$j]["retired_duration_year"] != 0 || $empRes[$j]["retired_duration_month"] != 0 ||
$empRes[$j]["retired_duration_day"] != 0) {
if ($empRes[$j]["emp_state"] == 3 || $empRes[$j]["emp_state"] == 4) {
$total_year += $empRes[$j]["retired_duration_year"];
$total_month += $empRes[$j]["retired_duration_month"];
$total_day += $empRes[$j]["retired_duration_day"];
} /*else {
$total_not_rasmi_year += $empRes[$j]["retired_duration_year"];
$total_not_rasmi_month += $empRes[$j]["retired_duration_month"];
$total_not_rasmi_day += $empRes[$j]["retired_duration_day"];
