=10){
$wheis.=" AND ac_code LIKE '%".mysql_real_escape_string(str_replace(" ","%",$ac_code))."%' ";
}
if($ac_name!=""){
$wheis.=" AND ac_name LIKE '%".mysql_real_escape_string(str_replace(" ","%",$ac_name))."%' ";
}
if($item_name!=""){
$wheis.=" AND item_name LIKE '%".mysql_real_escape_string(str_replace(" ","%",$item_name))."%' ";
}
if(strlen($job_start)==8 and strlen($job_end)==8){
$wheis.=" AND pay_date BETWEEN '".mysql_real_escape_string($job_start)."' AND '".mysql_real_escape_string($job_end)."' ";
}else if(strlen($job_start)==0 and strlen($job_end)==8){
$wheis.=" AND pay_date<= ".$job_end ;
}else if(strlen($job_start)==8 and strlen($job_end)==0){
$wheis.=" AND pay_date >= ".$job_start ;
}else{
//$wheis.=" AND pay_date LIKE '".date("Y")."%' ";
}
if(session_is_registered("u_name") and session_is_registered("u_mail") and session_is_registered("u_code") and session_is_registered("privilege_mn") and $_SESSION['privilege_mn']<5 ){
$linkto="pay_report.php?ac_code=".$ac_code."&ac_name=".$ac_name."&item_name=".$item_name."&st_yy=".$st_yy."&st_mm=".$st_mm."&ed_mm=".$ed_mm."&ed_yy=".$ed_yy ;
}else{
if($ac_code!="" and strlen($ac_code)>=10 and is_numeric($ac_code) ){
$wheis.=" AND ac_code LIKE '%".mysql_real_escape_string(str_replace(" ","%",$ac_code))."%' ";
}
$linkto="pay_report.php?ac_code=".$ac_code ;
}
?>
ระบบฐานข้อมูล รายการเงินโอน [ARCH KKU]
รายงาน >> 
รายการเงินโอน
