<?php require_once "../../class/Utils.php"; require_once "../../class/DBWork.php"; $iWork = new DBWork(); $toWork = new DBWork(); //kimgj1212 //choice4410 //localhost/FarmSaver/proc/DataConvert/gycode_fix_proc.php?id=kimgj1212 //http://localhost/FarmSaver/proc/DataConvert/data_convert_proc.php?id=choice4410 //localhost/proc/DataConvert/gycode_fix_proc.php?id=choice4410 try { $login_id = $_GET['id']; $fromWork->createWork($_GET, $login_id); $toWork->createWork($_GET, false); $toWork->querySql("SELECT co_id FROM farmsaver.company_member A , user_info B WHERE B.user_id='{$login_id}' AND A.uid=B.uid;"); $uid = 0; while ($row = $toWork->fetchMixedRow()) { $uid = (int) $row['uid']; $co_list['001'] = (int) $row['co_id']; } //계정 ->덮어쓰는 것 가능 echo "--> convertGycode<br>"; $result['gycode'] = ConvertUtils::convertGycode($fromWork, $toWork, $co_list, $uid); $fromWork->destoryWork(); $toWork->destoryWork(); } catch (Exception $e) { $toWork->rollback(); $fromWork->destoryWork(); $toWork->destoryWork(); echo $e->getMessage();
<?php require_once "../../class/Utils.php"; require_once "../../class/DBWork.php"; $listWork = new DBWork(); $updateWork = new DBWork(); //localhost/FarmSaver/proc/DataConvert/junpyo_fix_proc.php try { $co_id = $_GET['co_id']; $listWork->createWork(-1, $login_id); $updateWork->createWork(-1, $login_id); $listWork->querySql("SELECT * FROM junpyo where co_id={$co_id} AND jp_view_gubun>4 AND jp_view='y';"); $idx = 0; while ($row = $listWork->fetchMapRow()) { $jp_rem = $row['jp_rem']; if ($jp_rem == '') { continue; } $jp_id = $row['jp_match_id']; $updateWork->updateSql("UPDATE junpyo SET `jp_rem` = '{$jp_rem}' WHERE co_id={$co_id} AND jp_id={$jp_id};"); $idx++; } $listWork->destoryWork(); $updateWork->destoryWork(); echo $idx; } catch (Exception $e) { $listWork->destoryWork(); $updateWork->destoryWork(); echo $e->getMessage(); Util::serverLog($e); exit;
<?php require_once "../../class/Utils.php"; require_once "../../class/DBWork.php"; $listWork = new DBWork(); $updateWork = new DBWork(); //localhost/FarmSaver/proc/DataConvert/junpyo_fix_customer_proc.php //localhost/proc/DataConvert/junpyo_fix_customer_proc.php try { $co_id = $_GET['co_id']; $listWork->createWork(-1, $login_id); $updateWork->createWork(-1, $login_id); $listWork->querySql("SELECT * FROM junpyo WHERE jp_view = 'y' and jp_view_gubun>4;"); $idx = 0; $updateWork->startTransaction(); while ($row = $listWork->fetchMapRow()) { $customer_id = $row['customer_id']; if ($customer_id == 0) { continue; } $jp_id = $row['jp_match_id']; if ($jp_id == 0) { throw new Exception($row['jp_id']); } $updateWork->updateSql("UPDATE junpyo SET `customer_id` = {$customer_id} WHERE jp_id={$jp_id};"); $idx++; } $updateWork->commit(); $listWork->destoryWork(); $updateWork->destoryWork(); echo $idx;