public function act_unLock()
{
$id = $_REQUEST['id'];
$sysUserId = $_SESSION['sysUserId'];
if (!is_array($id)) {
$id = explode(",", $id);
}
foreach ($id as $k => $v) {
$set = ' SET isLock = "" , lockUser = "" , lockTime = "" ';
$where = ' WHERE id = ' . $v . ' AND lockUser = '******'om_unshipped_order', $set, $where);
if (!$ret) {
self::$errCode = OrderModifyModel::$errCode;
self::$errMsg = OrderModifyModel::$errMsg;
return false;
}
}
return true;
}
public function InsertOrderDetailExtensionEbay($detailId, $orderDetailExtend)
{
$table = C('DB_PREFIX') . 'unshipped_order_detail_extension_ebay';
$orderDetailExtend['omOrderdetailId'] = $detailId;
$orderDetailExtend['transactionID'] = '360863697815';
$orderDetailExtend['itemURL'] = '0';
$orderDetailExtend['conditionID'] = '1000';
$orderDetailExtend['conditionDisplayName'] = 'Brand New';
$orderDetailExtend['finalValueFeeCurrency'] = 'GBP';
$orderDetailExtend['finalValueFee'] = '0.59';
$orderDetailExtend['handlingFee'] = '0.59';
$fdata = $this->formatInsertField($table, $orderDetailExtend);
if ($fdata === false) {
self::$errMsg = $this->validatemsg;
return false;
}
echo "INSERT " . $table . " SET " . array2sql($fdata);
//return $this->sql("INSERT ".$table." SET ".array2sql($fdata))->insert();
}
/**
*修改指定表记录(只要sql运行成功就算成功)
*/
public static function batchMove($data, $where)
{
self::initDB();
$string = array2sql($data);
$tName = 'om_unshipped_order';
$sql = "UPDATE {$tName} SET {$string} {$where}";
//echo $sql; exit;
$query = self::$dbConn->query($sql);
if ($query) {
self::$errCode = "200";
self::$errMsg = "修改成功";
return true;
//成功， 返回真
} else {
self::$errCode = "003";
self::$errMsg = "修改失败";
return false;
//失败则设置错误码和错误信息， 返回false
}
}
