send_cmd($cmd); // $db_dpis->show_error(); $data = $db_dpis->get_array(); $data = array_change_key_case($data, CASE_LOWER); $count_data = $data[count_data]; $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); $limit_data = ""; ?>

:   :      ข้อมูล  * ชื่อรูปภาพ :   "; $PIC_PATH_NAME = ($PIC_PATH_IP)?($PIC_PATH_IP):"images/my_preview.gif"; }else{ if ($http_server) { // echo "1.".$http_server."/".$PIC_PATH.$PIC_NAME." ($PERSONAL_PIC) "; $fp = @fopen($http_server."/".$PIC_PATH.$PIC_NAME, "r"); if ($fp !== false) $PIC_PATH_NAME = $http_server."/".$PIC_PATH.$PIC_NAME; else $PIC_PATH_NAME = "images/my_preview.gif"; fclose($fp); } else { // echo "2.".$PIC_PATH.$PIC_NAME." ($PERSONAL_PIC) "; $fp = @fopen($PIC_PATH.$PIC_NAME, "r"); if ($fp !== false) $PIC_PATH_NAME = $PIC_PATH.$PIC_NAME; else $PIC_PATH_NAME = "images/my_preview.gif"; fclose($fp); // $PIC_PATH_NAME = file_exists($PIC_PATH.$PIC_NAME)?($PIC_PATH.$PIC_NAME):"images/my_preview.gif"; // $PIC_PATH_NAME = file_exists($PIC_PATH.$PIC_NAME)?($PIC_PATH.$PIC_NAME):"images/my_preview.gif"; } } ?> ขนาดไฟล์ที่อัพโหลดได้ต้องไม่เกิน $maxsize_up_file MB"; } ?> ขนาดภาพถ่ายควรเป็น 110x132 (wxh) > ปี พ.ศ. :  ที่เก็บแฟ้ม :   >  ลายเซ็น (ขนาดรูปควรเป็น 110x132 (wxh)) ลำดับที่ :   แสดงภาพ :   > :   ><?=$PIC_REMARK?> วันที่ Upload :   :     :       พบข้อมูลประวัติรูปภาพทั้งสิ้น รายการ 1){ if($DPISDB=="odbc"){ $cmd = " select top $start_record trim(PER_PICSEQ) as concat_pk from PER_PERSONALPIC where PER_ID=$PER_ID order by PER_PICSEQ "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_exclude[] = "'".$data[concat_pk]."'"; $limit_data = (trim($search_condition)?" and ":" where ")." trim(PER_PICSEQ) not in (". implode(", ", $arr_exclude) .")"; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; } } if($DPISDB=="odbc"){ $cmd = " SELECT top $data_per_page * FROM PER_PERSONALPIC WHERE PER_ID=$PER_ID $search_condition $limit_data ORDER BY PER_PICSEQ "; }elseif($DPISDB=="oci8"){ $rec_start = (($current_page-1) * $data_per_page) + 1; $rec_end = ($current_page > 1)? ($current_page * $data_per_page) : $data_per_page; $cmd = "select * from ( select rownum rnum, q1.* from ( select * from PER_PERSONALPIC where PER_ID=$PER_ID $search_condition order by PER_PICSEQ ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = " SELECT * FROM PER_PERSONALPIC WHERE PER_ID=$PER_ID $search_condition ORDER BY PER_PICSEQ $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); // echo "count_page_data=$count_page_data-->$cmd "; if ($count_page_data) { ?> get_array()) { $data_count++; if ($PER_ORDER_BY==1) $num_order++; else $num_order--; if($data_count > $data_per_page) break; $TMP_PIC_SEQ = $data[PER_PICSEQ]; $current_list .= ((trim($current_list))?",":"") . $TMP_PIC_SEQ; $T_PIC_SEQ = substr("000",0,3-strlen("$TMP_PIC_SEQ"))."$TMP_PIC_SEQ"; $TMP_SERVER = $data[PIC_SERVER_ID]; $TMP_PIC_SIGN= $data[PIC_SIGN]; $TMP_AUDIT_FLAG = $data[AUDIT_FLAG]; $server_keep = ""; if ($TMP_SERVER > 0) { if($TMP_SERVER==99){ // $TMP_SERVER 99 = ip จากตั้งค่าระบบ C06 ใช้ \ $IMG_PATH_DISPLAY = IP ONLY $tmp_http_server = $IMG_PATH_DISPLAY; $symbol_path = "#"; $server_keep = "($tmp_http_server)"; }else{ // other server $cmd1 = " SELECT * FROM OTH_SERVER WHERE SERVER_ID=$TMP_SERVER "; $db_dpis2->send_cmd($cmd1); $data2 = $db_dpis2->get_array(); $tmp_SERVER_NAME = trim($data2[SERVER_NAME]); $tmp_ftp_server = trim($data2[FTP_SERVER]); $tmp_ftp_username = trim($data2[FTP_USERNAME]); $tmp_ftp_password = trim($data2[FTP_PASSWORD]); $tmp_main_path = trim($data2[MAIN_PATH]); $tmp_http_server = trim($data2[HTTP_SERVER]); } } else { $TMP_SERVER = 0; $tmp_SERVER_NAME = ""; $tmp_ftp_server = ""; $tmp_ftp_username = ""; $tmp_ftp_password = ""; $tmp_main_path = ""; $tmp_http_server = ""; } $SIGN_NAME = ""; if($TMP_PIC_SIGN==1){ $SIGN_NAME = "SIGN"; } if (trim($data[PER_CARDNO]) && trim($data[PER_CARDNO]) != "NULL") { $TMP_PIC_NAME = $data[PER_PICPATH].$data[PER_CARDNO]."-".$SIGN_NAME.$T_PIC_SEQ.".jpg".($tmp_SERVER_NAME ? " [".$tmp_SERVER_NAME."]" : ""); $TMP_SHOW_PIC = ($tmp_http_server ? $tmp_http_server.$symbol_path : "").$data[PER_PICPATH].$data[PER_CARDNO]."-".$SIGN_NAME.$T_PIC_SEQ.".jpg"; } else { $TMP_PIC_NAME = $data[PER_PICPATH].$data[PER_GENNAME]."-".$SIGN_NAME.$T_PIC_SEQ.".jpg".($tmp_SERVER_NAME ? " [".$tmp_SERVER_NAME."]" : ""); $TMP_SHOW_PIC = ($tmp_http_server ? $tmp_http_server.$symbol_path : "").$data[PER_PICPATH].$data[PER_CARDNO]."-".$SIGN_NAME.$T_PIC_SEQ.".jpg"; } //echo "1 $tmp_http_server ====> $TMP_SHOW_PIC "; $TMP_SHOW_PIC = str_replace("#","'",$TMP_SHOW_PIC); $TMP_SHOW_PIC = addslashes($TMP_SHOW_PIC); $TMP_SHOW_PIC = str_replace("'","",$TMP_SHOW_PIC); $TMP_PIC_NAME = str_replace("#","'",$TMP_PIC_NAME); $TMP_PIC_NAME = addslashes($TMP_PIC_NAME); $TMP_PIC_NAME = str_replace("'","",$TMP_PIC_NAME); $FILE_TMP_SHOW_PIC = file_exists($TMP_SHOW_PIC); //echo is_file($TMP_SHOW_PIC)."-2 ( $FILE_TMP_SHOW_PIC )====> $TMP_SERVER + $tmp_http_server + $TMP_SHOW_PIC "; /***** if ($tmp_http_server) { $fp = @fopen($TMP_SHOW_PIC, "r"); if ($fp === false) $TMP_SHOW_PIC = "images/my_preview.gif"; fclose($fp); } else { if (!$FILE_TMP_SHOW_PIC) $TMP_SHOW_PIC = "images/my_preview.gif"; } ****/ if(!$TMP_SHOW_PIC) $TMP_SHOW_PIC = "images/my_preview.gif"; $TMP_SAVEDATE = show_date_format($data[PER_PICSAVEDATE], 1); $TMP_PIC_SHOW = ($data[PIC_SHOW]=="1"?"แสดงภาพ":""); $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($PIC_SEQ==$TMP_PIC_SEQ){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?> > รูปภาพ ชื่อ วันที่ Upload ลายเซ็น   >  "">  "">    "> >                   1) : ?>