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