elseif ( $res[$i]["person_type"] == 3 && $res[$i]["execute_date"] < '2013-02-19') {
echo "<td>";
echo "<a href='worker_writ_detailv8.php?writ_id=".$res[$i]["writ_id"]."&writ_ver=".$res[$i]["writ_ver"]."&p_type=".$p_type."&wkind=".$writk."&reportType=full&reportRowCount=2&exeapp=employees&ownapp=staff'>";
echo $res[$i]["writ_id"]."</a></td>";
}
elseif($res[$i]["person_type"] == 3 && $res[$i]["execute_date"] >= '2013-02-19'){
echo "<td>";
echo "<a target='_blank' href='http://sadaf.um.ac.ir/HumanResources/personal/writs/ui/print_writ.php?writ_id=".$res[$i]["writ_id"]."&writ_ver=".$res[$i]["writ_ver"]."&staff_id=".$res[$i]["staff_id"]."&transcript_no=pooya'>";
echo $res[$i]["writ_id"]."</a></td>";
} */
echo "<td>".$res[$i]["writ_ver"]."</td>";
echo "<td>".($res[$i]["wt_title"]." - ".$res[$i]["wst_title"])."</td>";
echo "<td>".shdate($res[$i]["execute_date"])."</td>";
echo "<td>".shdate($res[$i]["issue_date"])."</td>";
echo "<td align='center' >";
/*echo "<a target='_blank' href='http://pooya.um.ac.ir/hrms_portal/profs/professor_writ_detailv8_pdf.php?writ_id=".$res[$i]["writ_id"]."&writ_ver=".$res[$i]["writ_ver"]."&staff_id=".$res[$i]["staff_id"]."&transcript_no=pooya'>";
echo $res[$i]["writ_id"]."</a></td>";*/
if($res[$i]["person_type"]=='2'){
echo "<a target='_blank' href='/HumanResources/personal/writs/ui/PrintPdf.php?writ_id=".$res[$i]["writ_id"]."&writ_ver=".$res[$i]["writ_ver"]."&staff_id=".$res[$i]["staff_id"]."&transcript_no=pooya'>
<img src='/HumanResources/img/print.gif' align='center'></a>";
}
elseif($res[$i]["person_type"]=='5'){
echo "<a target='_blank' href='/HumanResources/personal/writs/ui/PrintPdf1.php?writ_id=".$res[$i]["writ_id"]."&writ_ver=".$res[$i]["writ_ver"]."&staff_id=".$res[$i]["staff_id"]."&transcript_no=pooya'>
<img src='/HumanResources/img/print.gif' align='center'></a>";
while ($rec = $insure_res->fetch()) {
$i++;
$typeInsure_query = " select case insure_type\r\n\t\t when 1 then 'عادي' \r\n\t\t when 2 then 'مازاد1'\r\n\t\t when 3 then 'مازاد2'\r\n\t\t when 4 then 'تامين اجتماعي'\r\n\t\t end insureTyp \r\n\t\t \r\n\t\t from hrmstotal.person_dependent_supports pds \r\n\t\t where PersonID = " . $HrmsPersonID . " AND\r\n\t\t\t\t\t\t \t master_row_no = " . $rec['row_no'] . " AND\r\n\t\t\t\t\t\t \t (pds.from_date <='" . date('Y-m-d') . "' AND\r\n\t\t\t\t\t\t \t (pds.to_date >= '" . date('Y-m-d') . "' OR pds.to_date IS NULL) ) and \r\n\t\t\t\t\t\t \t pds.status IN (1,2) ";
// echo $typeInsure_query ; die();
$typeInsure_res = $mysql->Execute($typeInsure_query);
$typeInsure_rec = $typeInsure_res->fetch();
if ($i % 2 == 0) {
echo "<tr class=OddRow>";
} else {
echo "<tr class=EvenRow>";
}
echo "<td>" . $rec['fname'] . "</td>";
echo "<td>" . $rec['lname'] . "</td>";
echo "<td>" . $rec['dependency'] . "</td>";
echo "<td>" . $rec['idcard_no'] . "</td>";
echo "<td>" . shdate($rec['birth_date']) . "</td>";
echo "<td>" . $rec['father_name'] . "</td>";
echo "<td>" . $typeInsure_rec['insureTyp'] . "</td>";
echo "</tr>";
}
echo "</table>";
echo "<br><br>";
?>
<script>
validChars = ' abcdefghijklmnopqrstuvwxyz';
function JustAlphaNBlank(str) {
for(var i = 0; i < str.length; ++i)
if(validChars.indexOf(str.charAt(i).toLowerCase()) == -1) {
alert('تنها حروف الفباي انگليسي و فضاي خالي مجاز است');
return false;
}
