public static function addExpressRemark($omOrderId, $data) { !self::$dbConn ? self::initDB() : null; BaseModel::begin(); //开始事务 if (!self::deleteExpressRemark($omOrderId)) { BaseModel::rollback(); self::$errCode = "001"; self::$errMsg = " 删除数据失败! "; return false; //失败则设置错误码和错误信息, 返回false } if (!empty($data)) { //var_dump($data); foreach ($data as $datavalue) { $string = array2sql_extral($datavalue); //$string = "('".$datavalue['omOrderId']."','". $datavalue['price']."','". $datavalue['amount']."','". $datavalue['hamcodes']."','". $datavalue['isBrand']."','". $datavalue['description']."','". $datavalue['creatorId']."','". $datavalue['createdTime'] ."'),"; $sql = "INSERT INTO " . self::$Table . " SET {$string} "; //echo $sql; if (!self::$dbConn->query($sql)) { BaseModel::rollback(); self::$errCode = "002"; self::$errMsg = " 插入数据失败! "; return false; //失败则设置错误码和错误信息, 返回false } } BaseModel::commit(); BaseModel::autoCommit(); self::$errCode = "200"; self::$errMsg = " 插入数据成功! "; return true; //失败则设置错误码和错误信息, 返回false } }
$user = $ebay_paypal['user']; $array = array(); $array['name'] = $name; $array['ebayaccount'] = $ebayaccount; $array['account1'] = $account; $array['pass1'] = $pass; $array['signature1'] = $signature; $array['account2'] = $account2; $array['pass2'] = $pass2; $array['signature2'] = $signature2; $array['fees'] = $fees; $array['user'] = $user; $sql = "select * from om_paypal where ebayaccount = '{$ebayaccount}' "; $query = $dbConn->query($sql); $result = $dbConn->fetch_array($query); $string = array2sql_extral($array); if ($result) { $sql = "update om_paypal set " . $string . " where ebayaccount = '{$ebayaccount}' "; if ($dbConn->query($sql)) { echo $ebayaccount . " update success!\n"; } else { echo $ebayaccount . " update error!\n"; } } else { $sql = "insert into om_paypal set " . $string; if ($dbConn->query($sql)) { echo $ebayaccount . " add success!\n"; } else { echo $ebayaccount . " add error!\n"; } }
error_reporting(-1); header("Content-type: text/html; charset=utf-8"); date_default_timezone_set('Asia/Shanghai'); require "/data/web/order.valsun.cn/framework.php"; Core::getInstance(); $sql = "select * from om_status_menu where groupId != 0 and is_delete = 0 "; $query = $dbConn->query($sql); $om_status_menu = $dbConn->fetch_array_all($query); //var_dump($om_status_menu); echo "\n"; exit; $array = array(); foreach ($om_status_menu as $status_menu) { $statusCode = $status_menu['statusCode']; if (!in_array($statusCode, array(C("STATESHIPPED"), C("STATESHIPPED_PRINTPEND"), C("STATESHIPPED_PRINTED"), C("STATESHIPPED_BEPICKING"), C("STATESHIPPED_PENDREVIEW"), C("STATESHIPPED_BEPACKAGED"), C("STATESHIPPED_BEWEIGHED"), C("STATEHASSHIPPED"), C("STATEHASSHIPPED_CONV")))) { //$username = $userinfo['username']; foreach ($om_status_menu as $value) { if (!in_array($value['statusCode'], array(C("STATESHIPPED"), C("STATESHIPPED_PRINTPEND"), C("STATESHIPPED_PRINTED"), C("STATESHIPPED_BEPICKING"), C("STATESHIPPED_PENDREVIEW"), C("STATESHIPPED_BEPACKAGED"), C("STATESHIPPED_BEWEIGHED"), C("STATEHASSHIPPED"), C("STATEHASSHIPPED_CONV")))) { $array[$statusCode][] = $value['statusCode']; } } } } //var_dump($array); exit; //$json_array = json_encode($array); if ($array) { $data = array(); $data['visible_movefolder'] = json_encode($array); $string = array2sql_extral($data); $sql = "UPDATE om_userCompetence SET {$string} "; $dbConn->query($sql); } exit;
public static function addUserCompense($uid, $data) { !self::$dbConn ? self::initDB() : null; BaseModel::begin(); //开始事务 //var_dump($data); $string = array2sql_extral($data); if (self::selectUserCompense($uid)) { $sql = "UPDATE " . self::$UserCompenseTable . " SET {$string} WHERE global_user_id = " . $uid; //echo $sql; if (!self::$dbConn->query($sql)) { BaseModel::rollback(); self::$errCode = "002"; self::$errMsg = " 插入数据失败!"; return false; //失败则设置错误码和错误信息, 返回false } } else { $data['global_user_id'] = $uid; //$data['type'] = 1; $string = array2sql($data); $sql = "INSERT INTO " . self::$UserCompenseTable . " SET {$string} "; //echo $sql; if (!self::$dbConn->query($sql)) { BaseModel::rollback(); self::$errCode = "002"; self::$errMsg = " 插入数据失败!"; return false; //失败则设置错误码和错误信息, 返回false } } BaseModel::commit(); BaseModel::autoCommit(); self::$errCode = "200"; self::$errMsg = " 插入数据成功!"; return true; //失败则设置错误码和错误信息, 返回false }
$osql = "select * from om_express_remark where omOrderId = '{$omOrderId}' "; $query = $dbConn->query($osql); $oldremarks = $dbConn->fetch_array_all($query); if ($oldremarks) { $usql = "delete from om_express_remark where omOrderId = '{$omOrderId}' "; if (!$dbConn->query($usql)) { echo $usql; echo "\n"; BaseModel::rollback(); } else { $osql = "select * from om_express_remark_bak where omOrderId = '{$omOrderId}' "; $query = $dbConn->query($osql); $remarkValues = $dbConn->fetch_array_all($query); foreach ($remarkValues as $info) { $info['lastModified'] = time(); $info['description'] = mysql_real_escape_string(trim($info['description'])); $string = array2sql_extral($info); $sql = "insert into om_express_remark set " . $string; //echo $sql; echo "\n"; if (!$dbConn->query($sql)) { echo $sql; echo "\n"; BaseModel::rollback(); } } } } BaseModel::commit(); BaseModel::autoCommit(); } exit;
//var_dump($om_status_menu); echo "\n"; exit; $array = array(); foreach ($eub_accounts as $eub_account) { unset($eub_account['id']); $account = $eub_account['ebay_account']; unset($eub_account['ebay_account']); $eub_account['account'] = $account; $eub_account['accountId'] = $eub_account['pid']; unset($eub_account['pid']); $sql = "select * from om_eub_account where account = '{$account}' "; $query = $dbConn->query($sql); $result = $dbConn->fetch_array($query); $string = array2sql_extral($eub_account); if ($result) { $sql = "update om_eub_account set " . $string . " where account='{$account}'"; if ($dbConn->query($sql)) { echo $account . " update success!\n"; } else { echo $account . " update error!\n"; } } else { $string = array2sql_extral($eub_account); $sql = "insert into om_eub_account set " . $string; if ($dbConn->query($sql)) { echo $account . " add success!\n"; } else { echo $account . " add error!\n"; } } } exit;
/** * 临时插入订单数据对比关系 * @para $data as array * return true */ public static function insertTempOrderRelation($data) { self::initDB(); $string = array2sql_extral($data); $sql = "INSERT INTO `om_temp_orderRelation` SET " . $string; $query = self::$dbConn->query($sql); if ($query) { //$orderid = $data['omOrderId']; return true; } else { self::$errCode = "003"; self::$errMsg = "error"; return false; } }