/**
* 插入订单快递描述的方法，key为fedexRemark,现在只有独立商城会用到
* 以下为demo
* @param array $data 为一个二维数组，至少是一条快递描述记录
* @return bool
* @author zqt
* @modify 20140807 修改方法名，同时订单大数组键改为了declarationContent,表也换了
*/
public function insertOrderDeclarationContent($data)
{
$data = array_filter($data);
if (empty($data)) {
//如果$data为空，则不支持操作，直接返回,因为订单跟踪号是非必须的
return true;
}
//检测订单号是否插入成功
if ($this->_orderid == 0) {
return false;
} else {
foreach ($data as $key => $value) {
$data[$key]['omOrderId'] = $this->_orderid;
$data[$key]['datetime'] = time();
}
}
$table = C('DB_PREFIX') . 'declaration_content';
foreach ($data as $value) {
$fdata = $this->formatInsertField($table, $value);
if ($fdata === false) {
self::$errMsg = $this->validatemsg;
return false;
}
if (!$this->sql("INSERT INTO {$table} SET " . array2sql($fdata))->insert()) {
return false;
}
}
return true;
}
function act_addExpressRemark($omOrderId, $post)
{
global $memc_obj;
//调用memcache获取sku信息
$addUser = $_SESSION['sysUserId'];
$data = array();
//var_dump($post); exit;
$action = $post['action'];
switch ($action) {
case 'adddhl':
if (isset($post['price2'])) {
foreach ($post['price2'] as $key => $priceValue) {
$data[$key]['omOrderId'] = $omOrderId;
$data[$key]['price'] = trim(round($post['price2'][$key], 2));
$data[$key]['amount'] = trim($post['amount2'][$key]);
$data[$key]['description'] = trim(mysql_real_escape_string($post['description2'][$key]));
$data[$key]['creatorId'] = $addUser;
$data[$key]['createdTime'] = time();
}
}
break;
case 'addfedex':
if (isset($post['price'])) {
//var_dump($post);
foreach ($post['description'] as $key => $tempDesc) {
$ret = preg_match('/^(.|\\n|\\r)*\\((.|\\n|\\r){3,}\\)(.|\\n|\\r)*$/', $tempDesc);
if (!$ret) {
self::$errCode = 05;
self::$errMsg = " -[<font color='#FF0000'>操作记录: 数据保存失败,描述一栏必须包含\"(材质)\"字样! 且必须全为英文字符(包括标点符号)，<br> 不要有回车或换行，建议先在记事本里编辑好再拷贝到此描述栏!</font>]";
return false;
}
}
foreach ($post['price'] as $key => $priceValue) {
$branddescrips = trim(mysql_real_escape_string($post['branddescrip'][$key]));
if (empty($branddescrips)) {
$isBrand = 2;
$descriptions = "[No Brand]" . trim(mysql_real_escape_string($post['description'][$key]));
} else {
$isBrand = 1;
$descriptions = "[" . $branddescrips . "]" . trim(mysql_real_escape_string($post['description'][$key]));
}
$data[$key]['omOrderId'] = $omOrderId;
$data[$key]['price'] = trim(round($post['price'][$key], 2));
$data[$key]['amount'] = trim($post['amount'][$key]);
$data[$key]['hamcodes'] = trim($post['hamcodes'][$key]);
$data[$key]['isBrand'] = $isBrand;
//$data[$key]['branddescrip'] = $branddescrips;
$data[$key]['description'] = $descriptions;
$data[$key]['creatorId'] = $addUser;
$data[$key]['createdTime'] = time();
}
//var_dump($data);
}
break;
default:
}
$rtn = ExpressRemarkModel::addExpressRemark($omOrderId, $data);
self::$errCode = ExpressRemarkModel::$errCode;
self::$errMsg = ExpressRemarkModel::$errMsg;
return $rtn;
}
public static function deleteExpressRemark($omOrderId)
{
!self::$dbConn ? self::initDB() : null;
$sql = "DELETE FROM " . self::$Table . " WHERE omOrderId = " . $omOrderId;
//echo $sql;
if (!self::$dbConn->query($sql)) {
self::$errCode = "002";
self::$errMsg = " 插入数据失败！ ";
return false;
//失败则设置错误码和错误信息， 返回false
} else {
self::$errCode = "200";
self::$errMsg = " 插入数据成功！ ";
return true;
//失败则设置错误码和错误信息， 返回true
}
}
