5) { sleep(1); header("Location:" . $WebSite . "login/login_form.php"); exit; } include $_SERVER['DOCUMENT_ROOT'] . '/load_header.php'; $title_message = '작업 List'; $title_prefix = '절곡'; ?> <?=$title_prefix?> <?=$title_message?> '1' or devMode IS NULL) and steel = '1' " . $orderby; $searchwhere = " where " . $SettingDate . " between date('$fromdate') and date('$Transtodate') and is_deleted = '0' AND (devMode <> '1' or devMode IS NULL) and steel = '1' and searchtag like '%$search%' " . $orderby; } else if ($existing_status == '미출고') { $where = " where " . $SettingDate . " between date('$fromdate') and date('$Transtodate') and is_deleted = '0' AND (devMode <> '1' or devMode IS NULL) and steel = '1' and bend_state != '완료' " . $orderby; $searchwhere = " where " . $SettingDate . " between date('$fromdate') and date('$Transtodate') and is_deleted = '0' AND (devMode <> '1' or devMode IS NULL) nd steel = '1' and bend_state != '완료' and searchtag like '%$search%' " . $orderby; } else { $where = " where " . $SettingDate . " between date('$fromdate') and date('$Transtodate') and is_deleted = '0' AND (devMode <> '1' or devMode IS NULL) and steel = '1' and bend_state = '$existing_status' " . $orderby; $searchwhere = " where " . $SettingDate . " between date('$fromdate') and date('$Transtodate') and is_deleted = '0' AND (devMode <> '1' or devMode IS NULL) and steel = '1' and bend_state = '$existing_status' and searchtag like '%$search%' " . $orderby; } if($search==""){ $sql="select * from $DB.$tablename " . $where; } else if($search!="") { // 각 필드별로 검색어가 있는지 쿼리주는 부분 $sql ="select * from $DB.$tablename " . $searchwhere ; } $today=date("Y-m-d"); // 현재일자 변수지정 // print $sql; // print ' existing_status : ' . $existing_status; try { $stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh $total_row = $stmh->rowCount(); $total_sum=0; $total_m2=0; ?>
()
     
▷     ~    
 
 
fetch(PDO::FETCH_ASSOC)) { $item_num=$row["num"]; $outdate=$row["outdate"]; $item_indate=$row["indate"]; $item_orderman=$row["orderman"]; $item_outworkplace=$row["outworkplace"]; $item_outputplace=$row["outputplace"]; $item_receiver=$row["receiver"]; $item_phone=$row["phone"]; $comment=$row["comment"]; $updatecomment=$row["updatecomment"]; $root=$row["root"]; $steel=$row["steel"]; $motor=$row["motor"]; $delivery=$row["delivery"]; $regist_state=$row["regist_state"]; $bend_state=$row["bend_state"]; $secondord=$row["secondord"]; $warranty=$row["warranty"]; if($bend_state==null) $bend_state="1"; $date_font="text-dark"; // 현재일자 Red 색상으로 표기 if($today==$outdate) { $date_font="text-danger"; } $font="text-dark"; switch ($delivery) { case "상차(선불)" : $font="text-dark"; break; case "상차(착불)" :$font="color-grey" ; break; case "경동화물(선불)" :$font="color-brown"; break; case "경동화물(착불)" :$font="color-brown"; break; case "경동택배(선불)" :$font="color-brown"; break; case "경동택배(착불)" :$font="color-brown"; break; case "직접배차" :$font="color-purple"; break; case "직접수령" :$font="text-danger"; break; case "대신화물(선불)" :$font="color-blue"; break; case "대신화물(착불)" :$font="color-blue"; break; case "대신택배(선불)" :$font="color-blue"; break; case "대신택배(착불)" :$font="color-blue"; break; } // switch ($bend_state) { // case "1" : $font_state="text-danger"; $regist_word="등록"; break; // case "2" : $font_state="color-green" ; $regist_word="접수"; break; // case "3" : $font_state="color-green" ; $regist_word="제작중"; break; // case "4" : $font_state="text-dark" ; $regist_word="완료"; break; // default: $regist_word="등록"; break; // } if($outdate!="") { $week = array("(일)" , "(월)" , "(화)" , "(수)" , "(목)" , "(금)" ,"(토)") ; $outdate = $outdate . $week[ date('w', strtotime($outdate) ) ] ; } ?> getMessage(); } ?>
번호 출고일 접수일 출고리스트 절곡진행 발주처 현장명 수신자 수신 주소 수신처 운송 담당 인정 비고
' .$regist_word . ''; break; case "수정" : $regist_word="수정"; echo '' .$regist_word . ''; break; case "접수" : $regist_word="접수"; echo '' .$regist_word . ''; break; case "완료" : $regist_word="완료"; echo '' .$regist_word . ''; break; } ?> ' .$regist_word . ''; break; case "접수" : $regist_word="접수"; echo '' .$regist_word . ''; break; case "제작중" : $regist_word="제작중"; echo '' .$regist_word . ''; break; case "완료" : $regist_word="완료"; echo '' .$regist_word . ''; break; } ?> ' . $delivery . ''; } else if (strpos($delivery, '대신') !== false) { echo '' . $delivery . ''; } else { switch ($delivery) { case "직접배차": echo '' . $delivery . ''; break; case "직접수령": echo '' . $delivery . ''; break; case "상차(선불)": echo '' . $delivery . ''; break; case "상차(착불)": echo '' . $delivery . ''; break; default: echo '' . $delivery . ''; break; } } ?>