<?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;
