'1' OR devMode IS NULL) order by num desc"; // 개발자 모드 안나오게 수정 $nowday=date("Y-m-d"); // 현재일자 변수지정 $start_num=1; try{ $stmh = $pdo->query($sql); $total_row = $stmh->rowCount(); } catch (PDOException $Exception) { print "오류: ".$Exception->getMessage(); } ?>
query($sql); $total_row = $stmh->rowCount(); $start_num=$total_row; // 페이지당 표시되는 첫번째 글순번 $total_m2 = 0 ; $total_m2_formatted = 0 ; $total_egi_m2_formatted = 0 ; $total_screen_sum = 0; $total_screen_m2 = 0; $total_egi_sum = 0; $total_egi_m2 = 0; $total_sum = 0; $total_egi = 0; while($row = $stmh->fetch(PDO::FETCH_ASSOC)) { include $_SERVER['DOCUMENT_ROOT'] . "/output/_row.php"; // 콤마를 제거하고 숫자로 변환 $screen_su_cleaned = floatval(str_replace(',', '', $screen_su)); $screen_m2_cleaned = floatval(str_replace(',', '', $screen_m2)); $slat_su_cleaned = floatval(str_replace(',', '', $slat_su)); $slat_m2_cleaned = floatval(str_replace(',', '', $slat_m2)); $screenlists = json_decode($screenlist, true); // var_dump($screenlists["screen_m2"]); if($steel!="1") $bend_state=""; if($motor=="1") $motor="모터"; if($root=="주일") $root_font="text-dark"; else $root_font="text-primary"; $date_font="text-dark"; // 현재일자 Red 색상으로 표기 if($today==$outdate) { $date_font="text-danger"; } if($outdate!="") { $week = array("(일)" , "(월)" , "(화)" , "(수)" , "(목)" , "(금)" ,"(토)") ; $outdate = $outdate . $week[ date('w', strtotime($outdate) ) ] ; } ?> 0) print ''; else print ''; if ($row_m2_formatted > 0) print ''; else print ''; $total_sum += $screen_su_cleaned; $total_m2 += $screen_m2_cleaned; $total_egi += $slat_su_cleaned; $total_egi_m2 += $slat_m2_cleaned; // // 소수점 첫째자리까지만 포맷팅 $total_m2_formatted = number_format($total_m2, 1); $total_egi_m2_formatted = number_format($total_egi_m2, 1); ?> 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; } ?> ' . $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; } } ?> ' . $row_sum_formatted . ' ' . $row_m2_formatted . '