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