$(function(){ toast("저장되었습니다."); }); '; }else{ echo ''; } /* if ($_POST['term']=='당일' && $_POST['search_opt']==''){ $_POST['pro_order_type'] = ''; } */ //echo $_POST['search_opt']; /* if ($member['mb_id']=='munhun') { echo $_POST['pro_order_type'].'/'.$_POST['term'].'/'.$_POST['date1'].'/'.$_POST['date2'].'/'.$_POST['search_opt']; echo '
'.$_POST['siud'].'
'; echo $_POST['pro_car_codeimg'].'
'; } */ /* onclick="tog_view('id_search')" */ ?>
검색되었습니다.
= 0) //Reference is required for PHP 5.3+ { $refs = array(); foreach($arr as $key => $value) $refs[$key] = &$arr[$key]; return $refs; } return $arr; } function resizePng($im, $dst_width, $dst_height) { $width = imagesx($im); $height = imagesy($im); $newImg = imagecreatetruecolor($dst_width, $dst_height); imagealphablending($newImg, false); imagesavealpha($newImg, true); $transparent = imagecolorallocatealpha($newImg, 255, 255, 255, 127); imagefilledrectangle($newImg, 0, 0, $width, $height, $transparent); imagecopyresampled($newImg, $im, 0, 0, 0, 0, $dst_width, $dst_height, $width, $height); return $newImg; } if ($_POST['siud'] == 'u'){ if (isset($_POST['sangcha']) && $_POST['sangcha']=='all'){ $upload_directory = '../data/car_img/'.date("Ym").'/'.date("d").'/'; $upload_dir = 'http://182.162.216.105/data/car_img/'.date("Ym").'/'.date("d").'/'; if(!is_dir($upload_directory)) { mkdir($upload_directory,0777,true); } $arr = array(); if ($_POST['onlymemo'] == 'on'){ $query = 'update g5_order_list set pro_driver_etc = ? '; $arr[0] = $_POST['pro_driver_etc']; $dType = 's'; $i=1; }else{ $query = 'update g5_order_list set pro_complete_date = ? '; $arr[0] = date("Y-m-d H:i:s"); $dType = 's'; $i=1; if (isset($_POST['pro_sign']) && $_POST['pro_sign']!=''){ if (strpos($_POST['pro_sign'], 'ata:image')>0){ $path4 = 'sign_'.$member['mb_id'] . '_time_' . date('His') . '.png'; $_POST['pro_sign'] = str_replace('data:data:', 'data:', $_POST['pro_sign']); $im = imageCreateFromString(base64_decode(substr($_POST['pro_sign'],22))); imagepng(resizePng($im,290,150), $upload_directory.$path4); $query = $query . ', pro_sign = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path4; $i = $i + 1; } } if (isset($_POST['pro_car_numimg']) && $_POST['pro_car_numimg']!=''){ $img = $_POST['pro_car_numimg']; if (strpos($img, 'ata:image')>0){ if (strpos($img, 'data:image/jpeg;base64,') === 0 or strpos($img, 'data:image/jpg;base64,') === 0) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'data:image/png;base64,') === 0) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'data:image/gif;base64,') === 0) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } //if ($_POST['pro_car_code']!=''){ // $path2 = $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_' . date('His') . $ext; // }else{ $path2 = 'car_code_2x2_' . $member['mb_id'] . '_' . date('His') . $ext; //} $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); if ($ext=='.png') { imagepng($im, $upload_directory.$path2); // resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path2); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path2); } $query = $query . ', pro_car_numimg = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path2; $i = $i + 1; } } } $whr = ' where pro_driver_date is not null and pro_complete_date is null and pro_driver = "'.$member['mb_id'].'" '; // and batch_ck = 0 '; if ($_POST['pro_car_code_s'] != '') { $whr = $whr.' and pro_car_code like "%'.$_POST['pro_car_code_s'].'%"'; }else{ if ($_POST['pro_request_name'] != '') $whr = $whr.' and pro_request_name like "%'.$_POST['pro_request_name'].'%"'; if ($_POST['date1'] != '' and $_POST['date2'] != '') $whr = $whr.' and pro_consign_hopedate between "'.$_POST['date1'].'" and "'.$_POST['date2'].'"'; } if ($_POST['onlymemo'] != 'on'){ $getShipRet = sql_query('select s_start, s_arrive, pro_order_code, pro_claim_code, pro_claim_name, pro_car_type, pro_car_code from g5_order_list ' . $whr); for ($gs=0;$getShip = sql_fetch_array($getShipRet);$gs++){ if ($getShip['s_start'] != ''){ $getLiftShipRet = sql_query('select count(*) as cnt from g5_lift_ship where pro_order_code = '.$getShip['pro_order_code']); $getLiftShip = sql_fetch_array($getLiftShipRet); /* $fd = fopen( "err.txt", "a" ); fwrite( $fd, "111111111111" ); fwrite( $fd, "\r\n" ); fwrite( $fd, 'insert into g5_lift_ship(pro_order_code, cust_code, cust_name, car_type, car_code, ipgo_date, start_area, arri_area ) values('.$getShip['pro_order_code'].', "'.$getShip['pro_claim_code'].'", "'.$getShip['pro_claim_name'].'", "'.$getShip['pro_car_type'].'", "'.$getShip['pro_car_code'].'", "'.date('Y-m-d').'", "'.$getShip['s_start'].'", "'.$getShip['s_arrive'].'")'); fwrite( $fd, "\r\n" ); fwrite( $fd, 'update g5_lift_ship set cust_code = "'.$getShip['pro_claim_code'].'", cust_name = "'.$getShip['pro_claim_name'].'", car_type = "'.$getShip['pro_car_type'].'", car_code = "'.$getShip['pro_car_code'].'", ipgo_date = "'.date('Y-m-d').'", start_area = "'.$getShip['s_start'].'", arri_area = "'.$getShip['s_arrive'].'" where chul_hang is null and pro_order_code = '.$getShip['pro_order_code'] ); fwrite( $fd, "\r\n" ); fclose( $fd ); */ if ($getLiftShip['cnt'] == 0){ sql_query('insert into g5_lift_ship(pro_order_code, cust_code, cust_name, car_type, car_code, ipgo_date, start_area, arri_area ) values('.$getShip['pro_order_code'].', "'.$getShip['pro_claim_code'].'", "'.$getShip['pro_claim_name'].'", "'.$getShip['pro_car_type'].'", "'.$getShip['pro_car_code'].'", "'.date('Y-m-d').'", "'.$getShip['s_start'].'", "'.$getShip['s_arrive'].'")'); }else { sql_query('update g5_lift_ship set cust_code = "'.$getShip['pro_claim_code'].'", cust_name = "'.$getShip['pro_claim_name'].'", car_type = "'.$getShip['pro_car_type'].'", car_code = "'.$getShip['pro_car_code'].'", ipgo_date = "'.date('Y-m-d').'", start_area = "'.$getShip['s_start'].'", arri_area = "'.$getShip['s_arrive'].'" where chul_hang is null and pro_order_code = '.$getShip['pro_order_code']); } } } } $query = $query . $whr; // echo '쿼리1-->'.$query; if ($member['mb_id']=='900111') exit; $db_con = new mysqli('localhost', 'user', 'ddon5005', 'taksong'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } mysqli_query($db_con, 'set session character_set_connection=utf8;'); mysqli_query($db_con, 'set session character_set_results=utf8;'); mysqli_query($db_con, 'set session character_set_client=utf8;'); $stmt = $db_con->prepare($query); call_user_func_array(array($stmt, "bind_param"), refValues(array_merge((array) $dType, $arr))); $stmt->execute(); $stmt->close(); $db_con->close(); /* if ($_POST['pro_sign']!=''){ $shoring_list = explode('||', $_POST['shoring_code']); for ($s=1;$s0){ if (strpos($img, 'data:image/jpeg;base64,') === 0 or strpos($img, 'data:image/jpg;base64,') === 0) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'data:image/png;base64,') === 0) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'data:image/gif;base64,') === 0) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } // if ($_POST['pro_car_code']!=''){ // $path2 = $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_2_' . date('His') . $ext; // }else{ $path2 = 'car_code_x2_' . $member['mb_id'] . '_' . date('His') . $ext; //} $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); if ($ext=='.png') { imagepng($im, $upload_directory.$path2); // resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path2); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path2); } } } if (isset($_POST['pro_car_codeimg']) && $_POST['pro_car_codeimg']!=''){ $img = $_POST['pro_car_codeimg']; if (strpos($img, 'ata:image')>0){ if (strpos($img, 'ata:image/jpeg;base64,') == 1 or strpos($img, 'ata:image/jpg;base64,') === 1) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'ata:image/png;base64,') == 1) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'ata:image/gif;base64,') == 1) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } //if ($_POST['pro_car_code']!=''){ // $path1 = $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_' . date('His') . $ext; // }else{ $path1 = 'car_code_x_' . $member['mb_id'] . '_' . date('His') . $ext; //} $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); // chmod($upload_directory,0777); if ($ext=='.png') { imagepng($im, $upload_directory.$path1); //resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path1); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path1); } /* if ($member['mb_id'] == 'dA038') { $error = $_FILES['pro_car_codeimg']['error']; $name = $_FILES['pro_car_codeimg']['name']; $ext = array_pop(explode('.', $name)); move_uploaded_file( $_FILES['pro_car_codeimg']['tmp_name'], '../data/car_img/202303/car_code_x_dA038_115747.jpg'); echo $error; echo '
'; echo $name; echo '
'; echo $ext; echo '
'; echo '
'; echo '
'; echo $img; echo '
'; echo '
'; echo $upload_directory.$path1; echo '
'; echo $im; exit; } */ } } // echo '6 ... '; if (isset($_POST['pro_shipping']) && $_POST['pro_shipping']!=''){ $img = $_POST['pro_shipping']; if (strpos($img, 'ata:image')>0){ if (strpos($img, 'ata:image/jpeg;base64,') == 1 or strpos($img, 'ata:image/jpg;base64,') === 1) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'ata:image/png;base64,') == 1) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'ata:image/gif;base64,') == 1) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } //if ($_POST['pro_car_code']!=''){ // $path3 = 'mark_' . $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_' . date('His') . $ext; // }else{ $path3 = 'mark_' . $member['mb_id'] . '_' . date('His') . $ext; //} $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); if ($ext=='.png') { imagepng($im, $upload_directory.$path3); //resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path3); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path3); } } } // echo '7 ... '; /* $max_file_size = 10242880; if(isset($_FILES['pro_car_codeimg']) && $_FILES['pro_car_codeimg'] != "") { // ['name'] $file1 = $_FILES['pro_car_codeimg']; $ext = substr($file1['name'], strrpos($file1['name'], '.') + 1); if ($_POST['pro_car_code']!=''){ $path1 = $_POST['pro_car_code'] . '_time_' . date('His') . '.' . $ext; }else{ $path1 = 'date_'.date('YmdHis') . '.' . $ext; } move_uploaded_file($file1['tmp_name'], $upload_directory.$path1); } if(isset($_FILES['pro_car_numimg']) && $_FILES['pro_car_numimg'] != "") { // ['name'] $file2 = $_FILES['pro_car_numimg']; $ext = substr($file2['name'], strrpos($file2['name'], '.') + 1); if ($_POST['pro_car_num']!=''){ $path2 = $_POST['pro_car_num'] . '_time_' . date('His') . '.' . $ext; }else{ $path2 = 'date_'.date('YmdHis') . '.' . $ext; } move_uploaded_file($file2['tmp_name'], $upload_directory.$path2); } */ // echo '8 ... '.$_POST['onlymemo']; $arr = array(); if ($_POST['onlymemo'] == 'on'){ $query = 'update g5_order_list set pro_driver_etc = ? '; $arr[0] = $_POST['pro_driver_etc']; $dType = 's'; $i=1; }else{ $query = 'update g5_order_list set pro_car_code = ? '; $dType = 's'; $arr[0] = strtoupper($_POST['pro_car_code']); $i=1; if(isset($_POST['pro_car_codeimg']) && $_POST['pro_car_codeimg'] != '') { // ['name'] if (strpos($_POST['pro_car_codeimg'], 'ata:image')>0){ $query = $query . ', pro_car_codeimg = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path1; $i = $i + 1; $query = $query . ', pro_driver_date = ? '; $dType = $dType . 's'; $arr[$i] = date("Y-m-d H:i:s"); $i = $i + 1; } } if(isset($_POST['pro_shipping']) && $_POST['pro_shipping'] != '') { // ['name'] if (strpos($_POST['pro_shipping'], 'ata:image')>0){ $query = $query . ', pro_shipping = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path3; $i = $i + 1; } } if (isset($_POST['pro_car_num']) && $_POST['pro_car_num']!=''){ $query = $query . ', pro_car_num = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_car_num']; $i = $i + 1; } if(isset($_POST['pro_car_numimg']) && $_POST['pro_car_numimg'] != '') { // ['name'] if (strpos($_POST['pro_car_numimg'], 'ata:image')>0){ $query = $query . ', pro_car_numimg = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path2; $i = $i + 1; } } if (isset($_POST['pro_car_type']) && $_POST['pro_car_type']!=''){ $query = $query . ', pro_car_type = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_car_type']; $i = $i + 1; /* $danga = sql_fetch('select send_cost, gisa_cost from car_type where car_type = "'.$_POST['pro_car_type'].'"'); if ($danga['send_cost']!=''){ // $dbdanga = new mysqli('localhost', 'user', 'ddon5005', 'taksong'); sql_query('update g5_order_list set danga = 1, pro_consign_cost = '.$danga['send_cost'].', pro_consign_tax = '.($danga['send_cost'] * 0.1).', pro_consign_hab = '.($danga['send_cost'] * 1.1).', pro_driver_cost = '.$danga['gisa_cost'].', pro_driver_tax = '.($danga['gisa_cost'] * 0.1).', pro_driver_hab = '.($danga['gisa_cost'] * 1.1).' where danga = 0 and pro_order_code = '.$_POST['pro_order_code']); } */ } // echo '9 ... '.$query; /* if (isset($_POST['pro_driver_date']) && $_POST['pro_driver_date']!=''){ $query = $query . ', pro_driver_date = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_driver_date']; $i = $i + 1; } if (isset($_POST['pro_complete_date']) && $_POST['pro_complete_date']!=''){ $query = $query . ', pro_complete_date = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_complete_date']; $i = $i + 1; } if (isset($_POST['pro_consign_input']) && $_POST['pro_consign_input']!=''){ $query = $query . ', pro_consign_input = ? '; $dType = $dType . 'i'; $arr[$i] = $_POST['pro_consign_input']; $i = $i + 1; } */ if (isset($_POST['pro_driver_etc']) && $_POST['pro_driver_etc']!=''){ $query = $query . ', pro_driver_etc = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_driver_etc']; $i = $i + 1; } // echo '10 ... '.$query; if (isset($_POST['pro_sign']) && $_POST['pro_sign']!=''){ if (strpos($_POST['pro_sign'], 'ata:image')>0){ $path4 = 'sign_'.$member['mb_id'] . '_' . date('His') . '.png'; $_POST['pro_sign'] = str_replace('data:data:', 'data:', $_POST['pro_sign']); $im = imageCreateFromString(base64_decode(substr($_POST['pro_sign'],22))); imagepng(resizePng($im,290,150), $upload_directory.$path4); $query = $query . ', pro_sign = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path4; $i = $i + 1; $query = $query . ', pro_complete_date = ? '; $dType = $dType . 's'; $arr[$i] = date("Y-m-d H:i:s"); $i = $i + 1; /* $fd = fopen( "err.txt", "a" ); fwrite( $fd, "0000" ); fwrite( $fd, "\r\n" ); fwrite( $fd, 'select s_start, s_arrive from g5_order_list where pro_order_code = '.$_POST['pro_order_code'] ); fwrite( $fd, "\r\n" ); fclose( $fd ); */ $getShipRet = sql_query('select s_start, s_arrive, pro_order_code, pro_claim_code, pro_claim_name, pro_car_type, pro_car_code from g5_order_list where pro_order_code = '.$_POST['pro_order_code']); $getShip = sql_fetch_array($getShipRet); if ($getShip['s_start'] != ''){ $getLiftShipRet = sql_query('select count(*) as cnt from g5_lift_ship where pro_order_code = '.$_POST['pro_order_code']); $getLiftShip = sql_fetch_array($getLiftShipRet); /* $fd = fopen( "err.txt", "a" ); fwrite( $fd, "22222222222" ); fwrite( $fd, "\r\n" ); fwrite( $fd, 'insert into g5_lift_ship(pro_order_code, cust_code, cust_name, car_type, car_code, ipgo_date, start_area, arri_area ) values('.$getShip['pro_order_code'].', "'.$getShip['pro_claim_code'].'", "'.$getShip['pro_claim_name'].'", "'.$getShip['pro_car_type'].'", "'.$getShip['pro_car_code'].'", "'.date('Y-m-d').'", "'.$getShip['s_start'].'", "'.$getShip['s_arrive'].'")'); fwrite( $fd, "\r\n" ); fwrite( $fd, 'update g5_lift_ship set cust_code = "'.$getShip['pro_claim_code'].'", cust_name = "'.$getShip['pro_claim_name'].'", car_type = "'.$getShip['pro_car_type'].'", car_code = "'.$getShip['pro_car_code'].'", ipgo_date = "'.date('Y-m-d').'", start_area = "'.$getShip['s_start'].'", arri_area = "'.$getShip['s_arrive'].'" where chul_hang is null and pro_order_code = '.$_POST['pro_order_code']); fwrite( $fd, "\r\n" ); fclose( $fd ); */ if ($getLiftShip['cnt'] == 0){ sql_query('insert into g5_lift_ship(pro_order_code, cust_code, cust_name, car_type, car_code, ipgo_date, start_area, arri_area ) values('.$getShip['pro_order_code'].', "'.$getShip['pro_claim_code'].'", "'.$getShip['pro_claim_name'].'", "'.$getShip['pro_car_type'].'", "'.$getShip['pro_car_code'].'", "'.date('Y-m-d').'", "'.$getShip['s_start'].'", "'.$getShip['s_arrive'].'")'); }else { sql_query('update g5_lift_ship set cust_code = "'.$getShip['pro_claim_code'].'", cust_name = "'.$getShip['pro_claim_name'].'", car_type = "'.$getShip['pro_car_type'].'", car_code = "'.$getShip['pro_car_code'].'", ipgo_date = "'.date('Y-m-d').'", start_area = "'.$getShip['s_start'].'", arri_area = "'.$getShip['s_arrive'].'" where chul_hang is null and pro_order_code = '.$_POST['pro_order_code']); } } } } } // echo '11 ... '.$query; $query = $query . ' where pro_order_code = ? '; // and batch_ck = 0 '; $dType = $dType . 'i'; $arr[$i] = $_POST['pro_order_code']; // echo '쿼리2-->'.$query; //if ($member['mb_id']=='900111') exit; $db_con = new mysqli('localhost', 'user', 'ddon5005', 'taksong'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } mysqli_query($db_con, 'set session character_set_connection=utf8;'); mysqli_query($db_con, 'set session character_set_results=utf8;'); mysqli_query($db_con, 'set session character_set_client=utf8;'); $stmt = $db_con->prepare($query); /* // $data = array_merge((array) $dType, $arr); echo $query; print_r($arr); print_r($dType); print_r(array_merge((array) $dType, $arr)); */ call_user_func_array(array($stmt, "bind_param"), refValues(array_merge((array) $dType, $arr))); $stmt->execute(); $stmt->close(); $db_con->close(); // printf("%d Row inserted.\n", $stmt->affected_rows); // || $_POST['pro_arrive_area2'] == '머스크(CY)') /* if ($_POST['pro_arrive_area1'] == '인천신항' && $_POST['pro_arrive_area2'] == 'CY(쇼링)' && $_POST['pro_sign']!=''){ $query = 'select id from shoring_t where pro_request_code = "'.$_POST['pro_claim_code'].'" and bk_no = "'.$_POST['bk_no'].'" '; $id_result = sql_fetch($query); if (empty($id_result['id'])) { $cfRes = sql_query('select cf_1 from g5_config limit 1 '); $cfRow = sql_fetch_array($cfRes); $cnfRes = sql_query('select sangho, mb_7 from g5_member where mb_id = "'.$cfRow['cf_1'].'"'); $cnf = sql_fetch_array($cnfRes); /* $fd = fopen( "update.txt", "a" ); fwrite( $fd, "222222222222222222222222222" ); fwrite( $fd, "\r\n" ); fwrite( $fd, 'select sangho, mb_7 from g5_member where mb_id = "'.$cfRow['cf_1'].'"'); fwrite( $fd, "\r\n" ); /* fwrite( $fd, 'insert into shoring_t (saup, pro_claim_code, pro_claim_name, pro_claim_manager, pro_request_code, pro_request_name, pro_request_manager, pro_request_tel, bk_no ) select 1, "'.$cfRow['cf_1'].'", "'.$cnf['sangho'].'", "'.$cnf['mb_7'].'", pro_claim_code, pro_claim_name, pro_claim_manager, pro_claim_tel, bk_no from g5_order_list where pro_order_code = '.$_POST['pro_order_code'] ); * / fwrite( $fd, "\r\n" ); fclose( $fd ); ************ / $query = 'insert into shoring_t (saup, pro_claim_code, pro_claim_name, pro_claim_manager, pro_request_code, pro_request_name, pro_request_manager, pro_request_tel, bk_no ) select 1, "'.$cfRow['cf_1'].'", "'.$cnf['sangho'].'", "'.$cnf['mb_7'].'", pro_claim_code, pro_claim_name, pro_claim_manager, pro_claim_tel, bk_no from g5_order_list where pro_order_code = '.$_POST['pro_order_code']; sql_query($query); $m_id = sql_insert_id(); }else{ $m_id = $id_result['id']; } $query = 'select cost from shoring_cost_t where pro_car_type = trim("'.$_POST['pro_car_type'].'")'; $cost_result = sql_fetch($query); if (!isset($cost_result['cost']) || empty($cost_result['cost'])) { $cost = 0; }else{ $cost = $cost_result['cost']; } $query = 'insert into shoring_sub_t (saup, m_id, pro_car_type, pro_car_code, pro_order_code, cost, vat, amt ) select 1, '.$m_id.', trim(pro_car_type), pro_car_code, pro_order_code, '.$cost.', '.floor($cost*0.1).', '.($cost + floor($cost*0.1)).' from g5_order_list where pro_order_code = '.$_POST['pro_order_code']; sql_query($query); } */ /* *** }else{ echo '쿼리???-->'.$query; } */ } } }elseif ($_POST['siud'] == 'i'){ $upload_directory = '../data/car_img/'.date("Ym").'/'.date("d").'/'; $upload_dir = 'http://182.162.216.105/data/car_img/'.date("Ym").'/'.date("d").'/'; if(!is_dir($upload_directory)) { mkdir($upload_directory,0777,true); } if (isset($_POST['pro_car_codeimg']) && $_POST['pro_car_codeimg']!=''){ $img = $_POST['pro_car_codeimg']; if (strpos($img, 'ata:image')>0){ if (strpos($img, 'ata:image/jpeg;base64,') == 1 or strpos($img, 'ata:image/jpg;base64,') === 1) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'ata:image/png;base64,') == 1) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'ata:image/gif;base64,') == 1) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } //if ($_POST['pro_car_code']!=''){ // $path1 = $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_' . date('His') . $ext; // }else{ $path1 = 'car_code_x_' . $member['mb_id'] . '_' . date('His') . $ext; //} $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); if ($ext=='.png') { imagepng($im, $upload_directory.$path1); //resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path1); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path1); } /* if ($member['mb_id'] == 'dA038') { echo '222222'; echo $img; echo '
'; echo $im; exit; } */ } } if (isset($_POST['pro_shipping']) && $_POST['pro_shipping']!=''){ $img = $_POST['pro_shipping']; if (strpos($img, 'ata:image')>0){ if (strpos($img, 'ata:image/jpeg;base64,') == 1 or strpos($img, 'ata:image/jpg;base64,') === 1) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'ata:image/png;base64,') == 1) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'ata:image/gif;base64,') == 1) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } //if ($_POST['pro_car_code']!=''){ // $path3 = 'mark_' . $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_' . date('His') . $ext; // }else{ $path3 = 'mark_' . $member['mb_id'] . '_' . date('His') . $ext; //} $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); if ($ext=='.png') { imagepng($im, $upload_directory.$path3); //resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path3); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path3); } } } if (isset($_POST['pro_car_numimg']) && $_POST['pro_car_numimg']!=''){ $img = $_POST['pro_car_numimg']; if (strpos($img, 'ata:image')>0){ if (strpos($img, 'data:image/jpeg;base64,') === 0 or strpos($img, 'data:image/jpg;base64,') === 0) { $img = str_replace('data:image/jpeg;base64,', '', $img); $ext = '.jpg'; } if (strpos($img, 'data:image/png;base64,') === 0) { $img = str_replace('data:image/png;base64,', '', $img); $ext = '.png'; } if (strpos($img, 'data:image/gif;base64,') === 0) { $img = str_replace('data:image/gif;base64,', '', $img); $ext = '.gif'; } // if ($_POST['pro_car_code']!=''){ // $path2 = $_POST['pro_car_code'] . '_' . $member['mb_id'] . '_' . date('His') . $ext; // }else{ $path2 = 'car_code_2x_' . $member['mb_id'] . '_' . date('His') . $ext; // } $img = str_replace(' ', '+', $img); $im = imageCreateFromString(base64_decode($img)); if ($ext=='.png') { imagepng($im, $upload_directory.$path2); // resizePng($im,300,300) }elseif ($ext=='.gif') { imagegif($im, $upload_directory.$path2); }elseif ($ext=='.jpg') { ImageJpeg($im, $upload_directory.$path2); } } } $arr = array(); $query = 'insert into g5_order_list set insert_ck = 1, pro_car_code = ? '; $dType = 's'; $arr[0] = strtoupper($_POST['pro_car_code']); $i=1; if(isset($_POST['pro_car_codeimg']) && $_POST['pro_car_codeimg'] != '') { // ['name'] if (strpos($_POST['pro_car_codeimg'], 'ata:image')>0){ $query = $query . ', pro_car_codeimg = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path1; $i = $i + 1; $query = $query . ', pro_driver_date = ? '; $dType = $dType . 's'; $arr[$i] = date("Y-m-d H:i:s"); $i = $i + 1; } } if(isset($_POST['pro_shipping']) && $_POST['pro_shipping'] != '') { // ['name'] if (strpos($_POST['pro_shipping'], 'ata:image')>0){ $query = $query . ', pro_shipping = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path3; $i = $i + 1; } } if (isset($_POST['pro_request_name']) && $_POST['pro_request_name']!=''){ $query = $query . ', pro_request_name = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_request_name']; $i = $i + 1; } if(isset($_POST['pro_car_numimg']) && $_POST['pro_car_numimg'] != '') { // ['name'] if (strpos($_POST['pro_car_numimg'], 'ata:image')>0){ $query = $query . ', pro_car_numimg = ? '; $dType = $dType . 's'; $arr[$i] = $upload_dir.$path2; $i = $i + 1; } } /* if (isset($_POST['pro_car_num']) && $_POST['pro_car_num']!=''){ $query = $query . ', pro_car_num = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_car_num']; $i = $i + 1; } */ if (isset($_POST['pro_start_area1']) && $_POST['pro_start_area1']!=''){ $query = $query . ', pro_start_area1 = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_start_area1']; $i = $i + 1; } if (isset($_POST['pro_start_area2']) && $_POST['pro_start_area2']!=''){ $query = $query . ', pro_start_area2 = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_start_area2']; $i = $i + 1; } if (isset($_POST['pro_start_tel']) && $_POST['pro_start_tel']!=''){ $query = $query . ', pro_start_tel = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_start_tel']; $i = $i + 1; } if (isset($_POST['pro_arrive_area1']) && $_POST['pro_arrive_area1']!=''){ $query = $query . ', pro_arrive_area1 = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_arrive_area1']; $i = $i + 1; } if (isset($_POST['pro_arrive_area2']) && $_POST['pro_arrive_area2']!=''){ $query = $query . ', pro_arrive_area2 = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_arrive_area2']; $i = $i + 1; } if (isset($_POST['pro_arrive_tel']) && $_POST['pro_arrive_tel']!=''){ $query = $query . ', pro_arrive_tel = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_arrive_tel']; $i = $i + 1; } if (isset($_POST['pro_dispatch_etc']) && $_POST['pro_dispatch_etc']!=''){ $query = $query . ', pro_dispatch_etc = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_dispatch_etc']; $i = $i + 1; } if (isset($_POST['pro_car_type']) && $_POST['pro_car_type']!=''){ $query = $query . ', pro_car_type = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_car_type']; $i = $i + 1; } if (isset($_POST['pro_consign_type']) && $_POST['pro_consign_type']!=''){ $query = $query . ', pro_consign_type = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_consign_type']; $i = $i + 1; } if (isset($_POST['pro_consign_cost']) && $_POST['pro_consign_cost']!=''){ $query = $query . ', pro_consign_cost = ? , pro_consign_tax = ' . ($_POST['pro_consign_cost'] * 0.1) . ' '; $dType = $dType . 'i'; $arr[$i] = $_POST['pro_consign_cost']; $i = $i + 1; } if (isset($_POST['pro_consign_hopedate']) && $_POST['pro_consign_hopedate']!=''){ $query = $query . ', pro_consign_hopedate = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_consign_hopedate']; $i = $i + 1; } if (isset($_POST['pro_dispatch_date']) && $_POST['pro_dispatch_date']!=''){ $query = $query . ', pro_dispatch_date = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_dispatch_date']; $i = $i + 1; } if (isset($_POST['pro_driver']) && $_POST['pro_driver']!=''){ $query = $query . ', pro_driver = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_driver']; $i = $i + 1; } if (isset($_POST['pro_driver_nm']) && $_POST['pro_driver_nm']!=''){ $query = $query . ', pro_driver_nm = ? '; $dType = $dType . 's'; $arr[$i] = $_POST['pro_driver_nm']; $i = $i + 1; } // echo '쿼리3-->'.$query; $db_con = new mysqli('localhost', 'user', 'ddon5005', 'taksong'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } mysqli_query($db_con, 'set session character_set_connection=utf8;'); mysqli_query($db_con, 'set session character_set_results=utf8;'); mysqli_query($db_con, 'set session character_set_client=utf8;'); $stmt = $db_con->prepare($query); call_user_func_array(array($stmt, "bind_param"), refValues(array_merge((array) $dType, $arr))); $stmt->execute(); $stmt->close(); $db_con->close(); } if (($_POST['term'] == '당일' && $_POST['search_opt'] == '탁송의뢰') || ($_POST['term'] == '') ){ $strSQL = 'select al_up, bk_no, pro_claim_code, pro_order_code, pro_request_code, pro_request_name, pro_start_area1, pro_start_area2, pro_start_tel, pro_arrive_area1, pro_arrive_area2, pro_arrive_tel, pro_car_type, pro_car_code, pro_car_codeimg, pro_shipping, pro_car_num, pro_car_numimg, pro_consign_hopedate, pro_dispatch_date, pro_driver_date, pro_complete_date, pro_consign_type, pro_consign_cost, pro_dispatch_etc, pro_driver_etc, pro_sign, pro_driver_cost, pro_consign_hab, pro_car_info, pro_car_cancel from g5_order_list where pro_useable = 1 and pro_consign_hopedate = "'.date("Y-m-d").'" and pro_driver = "'.$member['mb_id'].'" and pro_driver_date is null'; // $strSQL1 = 'select count(*) from where pro_consign_hopedate = "'.date("Y-m-d").'" and pro_driver = "'.$member['mb_id'].'"'; }else if (($_POST['term'] != '당일' && $_POST['search_opt'] == '탁송의뢰') ){ $strSQL = 'select al_up, bk_no, pro_claim_code, pro_order_code, pro_request_code, pro_request_name, pro_start_area1, pro_start_area2, pro_start_tel, pro_arrive_area1, pro_arrive_area2, pro_arrive_tel, pro_car_type, pro_car_code, pro_car_codeimg, pro_shipping, pro_car_num, pro_car_numimg, pro_consign_hopedate, pro_dispatch_date, pro_driver_date, pro_complete_date, pro_consign_type, pro_consign_cost, pro_dispatch_etc, pro_driver_etc, pro_sign, pro_driver_cost, pro_consign_hab, pro_car_info, pro_car_cancel from g5_order_list where pro_useable = 1 and pro_consign_hopedate between "'.$_POST['date1'].'" and "'.$_POST['date2'].'" and pro_driver = "'.$member['mb_id'].'" and pro_driver_date is null'; // $strSQL1 = 'select count(*) from where pro_consign_hopedate = "'.date("Y-m-d").'" and pro_driver = "'.$member['mb_id'].'"'; }else { $strSQL = 'select al_up, bk_no, pro_claim_code, pro_order_code, pro_request_code, pro_request_name, pro_start_area1, pro_start_area2, pro_start_tel, pro_arrive_area1, pro_arrive_area2, pro_arrive_tel, pro_car_type, pro_car_code, pro_car_codeimg, pro_shipping, pro_car_num, pro_car_numimg, pro_consign_hopedate, pro_dispatch_date, pro_driver_date, pro_complete_date, pro_consign_type, pro_consign_cost, pro_dispatch_etc, pro_driver_etc, pro_sign, pro_driver_cost, pro_consign_hab, pro_car_info, pro_car_cancel from g5_order_list where pro_useable = 1 and pro_driver = "'.$member['mb_id'].'"'; // if ($_POST['pro_order_type'] != '' and $_POST['pro_order_type'] != '전체') $strSQL = $strSQL.' and pro_order_type = "'.$_POST['pro_order_type'].'"'; if ($_POST['pro_car_code_s'] != '') { $strSQL = $strSQL.' and pro_car_code like "%'.$_POST['pro_car_code_s'].'%"'; }else{ if ($_POST['pro_request_name'] != '') $strSQL = $strSQL.' and pro_request_name like "%'.$_POST['pro_request_name'].'%"'; if ($_POST['date1'] != '' and $_POST['date2'] != '') $strSQL = $strSQL.' and pro_consign_hopedate between "'.$_POST['date1'].'" and "'.$_POST['date2'].'"'; } if ($_POST['search_opt'] == '탁송의뢰') { $strSQL = $strSQL.' and pro_driver_date is null'; } if ($_POST['search_opt'] == '상 차') { $strSQL = $strSQL.' and pro_driver_date is not null and pro_complete_date is null'; } if ($_POST['search_opt'] == '하 차') { $strSQL = $strSQL.' and pro_complete_date is not null'; }} $result = sql_query($strSQL,false); $result1 = sql_num_rows($result); echo '
검색된 레코드 수 :
'.$result1.'

'; if ($_POST['search_opt'] == '하 차'){ /* if ($_POST['term']!='전월' && $_POST['term']!='전전월' && $_POST['term']!='3전월'){ $strSQL = 'select sum(pro_driver_cost) as cost, count(*) as cnt from g5_order_list where pro_useable = 1 and pro_driver = "'.$member['mb_id'].'" and pro_consign_hopedate between "'.$_POST['date1'].'" and "'.$_POST['date2'].'" and pro_complete_date is not null'; }else{ $strSQL = 'select sum(pro_driver_cost) as cost, count(*) as cnt from g5_order_list where pro_useable = 1 and pro_driver = "'.$member['mb_id'].'" and pro_driver_jobDate = "'.substr($_POST['date1'],0,7).'-01" and pro_complete_date is not null'; } */ $strSQL = 'select sum(pro_driver_cost) as cost '.substr($strSQL, strpos($strSQL, 'from')); // pro_consign_type="청구" and $result2 = sql_fetch($strSQL); /* echo '전산팀에서 잠시 확인 작업합니다......
'; echo $strSQL; */ /* if ($_POST['term']!='전월' && $_POST['term']!='전전월' && $_POST['term']!='3전월'){ $strSQL = 'select sum(pro_consign_hab) as hab, count(*) as cnt from g5_order_list where (pro_consign_type="선불" or pro_consign_type="착불") and pro_useable = 1 and pro_driver = "'.$member['mb_id'].'" and pro_consign_hopedate between "'.$_POST['date1'].'" and "'.$_POST['date2'].'" and pro_complete_date is not null'; }else{ $strSQL = 'select sum(pro_consign_hab) as hab, count(*) as cnt from g5_order_list where (pro_consign_type="선불" or pro_consign_type="착불") and pro_useable = 1 and pro_driver = "'.$member['mb_id'].'" and pro_driver_jobDate = "'.substr($_POST['date1'],0,7).'-01" and pro_complete_date is not null'; } */ $strSQL = 'select sum(pro_consign_hab) as hab '.str_replace('where', 'where (pro_consign_type="선불" or pro_consign_type="착불") and ',substr($strSQL, strpos($strSQL, 'from'))); $result3 = sql_fetch($strSQL); /* echo '전산팀에서 잠시 확인 작업합니다......
'; echo $strSQL; */ /* if ($_POST['term']=='전월' || $_POST['term']=='전전월' || $_POST['term']=='3전월'){ echo '
이월 건수 :
'.number_format($result1 - $result2['cnt']).'
    ( '.number_format($result1).' - '.number_format($result2['cnt']).' )

'; // - $result3['cnt'] + $result3['cnt'] echo '
당월 건수 :
'.number_format($result2['cnt']).'

'; // + $result3['cnt'] } */ echo '
기사수금액 :
'.number_format($result3['hab']).'

'; echo '
기사 금액 :
'.number_format($result2['cost']).'

'; $tax = substr($result2['cost'],0,-1); $hab = $result2['cost'] + $tax; echo '
부 가 세 :
'.number_format($tax).'

'; echo '
합계 금액 :
'.number_format($hab).'

'; echo '
세금계산서 발행시 합계 금액을 정확하게 일치시켜 주세요.
'; /* if ($hab == 0){ echo '
전월을 검색했을 때 합계금액이 표시되지 않으면
담당자가 아직 마감을 하지 않은 것입니다.
'; echo '
담당자에게 문의를 하시기 바랍니다.
'; } */ } echo '
 

'; if ($_POST['search_opt'] == '하 차'){ echo ''; echo ''; $colspan_val = 6; }else{ echo ''; echo ''; $colspan_val = 4; } $code_whr = ' 1=2 '; $shoring_code = ''; for($i= 0; $row = sql_fetch_array($result); $i++){ $code_whr = $code_whr.' or pro_order_code = '.$row['pro_order_code']; // || $row['pro_arrive_area2'] == '머스크(CY)') if ($row['pro_arrive_area1'] == '인천신항' && $row['pro_arrive_area2'] == 'CY(쇼링)' ) $shoring_code = $shoring_code.'||'.$row['pro_order_code']; $color_num = '8'; if ($_POST['search_opt'] == '탁송의뢰') { $color_num = '0'; } if ($_POST['search_opt'] == '상 차') { $color_num = '2'; } if ($_POST['search_opt'] == '하 차') { $color_num = '5'; } if ($row['pro_consign_type']=='착불' or $row['pro_consign_type']=='선불'){ $color_num = '9'; } echo ''; if ($_POST['search_opt'] == '하 차'){ echo ''; }else { echo ''; } echo ''; //
 

// '; } if ($_POST['search_opt'] == '하 차'){ echo ''; } echo '
No의뢰업체차종출발도착기사금액
No의뢰업체출발도착
'.($i+1).''.$row['pro_request_name'].''.$row['pro_car_type'].''.mb_substr($row['pro_start_area1'],0,10).'
'.mb_substr($row['pro_start_area2'],0,10).'		'.mb_substr($row['pro_arrive_area1'],0,10).'
'.mb_substr($row['pro_arrive_area2'],0,10).'		'.number_format($row['pro_driver_cost']).'
'.mb_substr($row['pro_start_area1'],0,10).'
'.mb_substr($row['pro_start_area2'],0,10).'		'.mb_substr($row['pro_arrive_area1'],0,10).'
'.mb_substr($row['pro_arrive_area2'],0,10).'
합 계'.number_format($result2['cost']).'
'; if ($_POST['search_opt'] === '상 차' && $result1 > 0) { echo '


'; echo ''; echo '
하차 전체
하차 후
이미지

'; }else{ echo '" />

고객사인

고객사인 -- (하차 전체)



'; }else { echo '" style="width:0px;" />

'; } echo '
'; } echo '


'; // /////////////////////////////////////////////////////////////////////////////////////// ?>