require_once "../../class/Utils.php"; require_once "../../class/DBWork.php"; $listWork = new DBWork(); $updateWork = new DBWork(); //localhost/FarmSaver/proc/DataConvert/junpyo_fix_rem_proc.php //localhost/proc/DataConvert/junpyo_fix_rem_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_gubun>4 AND jp_view='y';"); $idx = 0; while ($row = $listWork->fetchMapRow()) { $jp_rem = $row['jp_rem']; if ($jp_rem == '') { continue; } $jp_match_id = $row['jp_match_id']; $updateWork->updateSql("UPDATE junpyo SET `jp_rem` = '{$jp_rem}' WHERE jp_id={$jp_match_id};"); $idx++; } $listWork->destoryWork(); $updateWork->destoryWork(); echo $idx; } catch (Exception $e) { $listWork->destoryWork(); $updateWork->destoryWork(); echo $e->getMessage(); Util::serverLog($e); exit; }
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; }
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; } catch (Exception $e) { $listWork->destoryWork(); $updateWork->rollback(); $updateWork->destoryWork(); echo $e->getMessage(); Util::serverLog($e); exit; }