$arr = array(); foreach ($ebayaccounts_array as $account) { //$account = trim($accountinfo['account']); $sql = "SELECT * FROM om_account WHERE is_delete = 0 and account = '{$account}' "; $query = $dbConn->query($sql); $ret = $dbConn->fetch_array($query); if ($ret) { $platformId = $ret['platformId']; $id = $ret['id']; $arr[$platformId][] = $id; } } if ($arr) { $data = array(); $data['visible_platform_account'] = json_encode($arr); OmAccountModel::addUserCompense($global_user_id, $data); } /*$sql = "SELECT * FROM om_account WHERE is_delete = 0 and account = '{$account}' "; $query = $dbConn->query($sql); $ret = $dbConn->fetch_array($query); if($ret){ $sql = "update om_account set appname='{$appname}',platformId=2,suffix='{$suffix}' where account='{$account}'"; if($dbConn->query($sql)){ echo $account." update success!\n"; }else{ echo $account." update error!\n"; } }else{ $sql = "insert into om_account set account='{$account}',appname='{$appname}',platformId=1,suffix='{$suffix}'"; if($dbConn->query($sql)){ echo $account." add success!\n";
function act_updateOrderEditOptions() { //global $memc_obj; //调用memcache获取sku信息 $idArr = $_POST['idArr']; $uid = $_POST['uid']; $data = array(); $idStr = implode(',', $idArr); $data['visible_editorder'] = $idStr; $rtn = OmAccountModel::addUserCompense($uid, $data); self::$errCode = OmAccountModel::$errCode; self::$errMsg = OmAccountModel::$errMsg; return $rtn; }
public static function showOrderAPI($purchaseId, $storeId = 1) { // 提供超大订单数据 !self::$dbConn ? self::initDB() : null; //echo time(); echo "<br>"; //!self::$dbConn ? self::initDB() : null; //取出两个where 下的所有订单 /*if(!empty($whereDetail)){ $orderIdStr =implode(",",self::api_getOrdIdByDetWhe($whereDetail)); } if(!empty($whereOrder)){ $whereOrder = "AND ".$whereOrder; }*/ /*if(!empty($orderIdStr)){ $whereOrder .= " AND id in ({$orderIdStr})"; }*/ $showOrder = array(); $ordersql = 'SELECT a.id as orderid, a.accountId, b.sku, b.amount FROM om_unshipped_order AS a LEFT JOIN om_unshipped_order_detail AS b ON b.omOrderId = a.id WHERE a.orderStatus = ' . C('STATEOVERSIZEDORDERS') . ' AND a.orderType != ' . C('STATEOVERSIZEDORDERS_CONFIRM') . ' AND a.is_delete=0 AND b.is_delete=0 AND a.storeId= ' . $storeId; //echo $ordersql; echo "<br>"; exit; $query = self::$dbConn->query($ordersql); $orders = self::$dbConn->fetch_array_all($query); //echo count($orders); exit; //echo time(); echo "<br>"; exit; foreach ($orders as $ordervalue) { $orderid = $ordervalue['orderid']; $sku = $ordervalue['sku']; //$amount = $ordervalue['amount']; //echo $sku; echo "<br>"; $skus = GoodsModel::get_realskuinfo($sku); //var_dump($skus); echo "<br>"; exit; foreach ($skus as $_sku => $_num) { $_skuinfo = GoodsModel::getSkuinfoByPurchaseId($_sku, $purchaseId); //var_dump($_skuinfo); echo "<br>"; exit; if ($_skuinfo) { $auditRecord = CommonModel::getRecordsOrderAudit($orderid, $_sku); $accountInfo = OmAccountModel::accountInfo($accountId); //var_dump($accountInfo); echo "<br>"; exit; //echo $_sku; echo "<br>"; $nosaleand = CommonModel::getpartsaleandnosendall($_sku); //var_dump($nosaleand); echo "<br>"; exit; $ordervalue['accountId'] = $accountInfo['account']; $ordervalue['sku'] = $_skuinfo; $ordervalue['auditRecord'] = $auditRecord; $ordervalue['nosaleand'] = $nosaleand; //var_dump($ordervalue); echo "<br>"; $showOrder[] = $ordervalue; } } } if (!empty($showOrder)) { return json_encode($showOrder); } else { return false; } }
public function view_exportsToXls1() { error_reporting(E_ALL); /*$searchPlatformId = isset($_GET['platformId']) ? $_GET['platformId'] : ''; //搜索平台 $searchAccountId = isset($_GET['accountId']) ? $_GET['accountId'] : ''; //搜索账号 $searchIsNote = isset($_GET['isNote']) ? $_GET['isNote'] : ''; //是否有留言 $searchTransportationType = isset($_GET['transportationType']) ? $_GET['transportationType'] : '';//运输类型 $searchTransportation = isset($_GET['transportation']) ? $_GET['transportation'] : ''; //运输方式 $searchIsBuji = isset($_GET['isBuji']) ? $_GET['isBuji'] : ''; //是否补寄订单 $searchIsLock = isset($_GET['isLock']) ? $_GET['isLock'] : ''; //是否锁定 $searchOrderTime1 = isset($_GET['OrderTime1']) ? $_GET['OrderTime1'] : ''; //搜索下单初始时间 $searchOrderTime2 = isset($_GET['OrderTime2']) ? $_GET['OrderTime2'] : ''; //搜索下单结束时间 //order_detail表 $searchReviews = isset($_GET['reviews']) ? $_GET['reviews'] : ''; //是否评价 $searchSku = isset($_GET['sku']) ? $_GET['sku'] : ''; //sku $searchOmOrderId = ''; //订单编号 $searchOrderType = isset($_GET['selectOrderType']) ? $_GET['selectOrderType'] : '';*/ //foreach($_GET as $k=>$v){ // //if(isset($_)) // } $type = isset($_GET['type']) ? trim($_GET['type']) : ""; $order = isset($_GET['order']) ? trim($_GET['order']) : ""; $where = " WHERE "; $where_arr = array(); $accountList = $_SESSION['accountList']; $platformList = $_SESSION['platformList']; //echo "<pre>"; print_r($accountList); exit; $platformsee = array(); for ($i = 0; $i < count($platformList); $i++) { $platformsee[] = $platformList[$i]; } if ($platformsee) { $where_arr[] = ' da.platformId IN ( ' . join(',', $platformsee) . ' ) '; } $accountsee = array(); for ($i = 0; $i < count($accountList); $i++) { $accountsee[] = $accountList[$i]; } if ($accountsee) { $where_arr[] = ' da.accountId IN ( ' . join(",", $accountsee) . ' ) '; } if ($type == 1) { $arr = explode(",", $order); $ostatus = $arr[0]; $otype = $arr[1]; $where_arr[] = " da.is_delete=0 "; if ($ostatus) { $where_arr[] = " da.orderStatus='{$ostatus}' "; } if ($otype) { $where_arr[] = " da.orderType='{$otype}' "; } //$where = "where da.orderStatus='{$ostatus}' and da.orderType='{$otype}' and da.is_delete=0"; } elseif ($type == 2) { $where_arr[] = " da.id in({$order}) "; } $where .= join(' AND ', $where_arr); //echo $where; exit; $orderarr = OrderindexModel::showSearchOrderList("om_unshipped_order", $where); //echo count($orderarr); exit; $exporter = new ExportDataExcel("browser", "xls1" . $date . ".xls"); //echo "<pre>"; print_r($orderarr[98]);exit; $exporter->initialize(); // starts streaming data to web browser $exporter->addRow(array("日期", "账号", "订单编号", "重量", "邮费", "运输方式", "交易号", "客户ID", "仓位号", "料号", "数量", "国家", "包裹总价值", "币种", "包装员", "挂号条码", "是/否")); foreach ($orderarr as $key => $value) { $paymentTime = date("Y-m-d", $value['orderData']['paymentTime']); $accountArr = OmAccountModel::accountInfo($value['orderData']['accountId']); $account = $accountArr['account']; //$account = $account['account']; $orderid = $key; $weight = $value['orderWarehouse']['actualWeight']; $shipfee = $value['orderWarehouse']['actualShipping']; $packagerId = $value['orderWarehouse']['packagerId']; $packager = UserModel::getUsernameById($packagerId); $transportation = CommonModel::getCarrierList(); //所有的 $transportationList = array(); foreach ($transportation as $tranValue) { if ($tranValue['id'] == $value['orderData']['transportId']) { $transport = $tranValue['carrierNameCn']; break; } //$transportationList[$tranValue['id']] = $tranValue['carrierNameCn']; } //$plateform = exportsToXlsModel::plateformIdToName($value['orderData']['platformId']); $plateformArr = OmAccountModel::platformListById($value['orderData']['platformId']); $plateform = $plateformArr[$value['orderData']['platformId']]; //$plateform = $plateform['platform']; $transId = $value['orderExtenData']['transId']; $currency = $value['orderExtenData']['currency']; $userId = $value['orderUserInfoData']['platformUsername']; $countryName = $value['orderUserInfoData']['countryName']; $actualTotal = $value['orderData']['actualTotal']; $recordNumber = $value['orderData']['recordNumber']; $trackNumber = $value['orderTracknumber'][0]['tracknumber']; $orderDetails = $value['orderDetail']; if (count($orderDetails) == 1) { foreach ($value['orderDetail'] as $key => $detail) { $skuId = $key; } $exporter->addRow(array($paymentTime, $account, $orderid, $weight, $shipfee, $transport, $recordNumber, $userId, "", $orderDetails[$skuId]['orderDetailData']['sku'], $orderDetails[$skuId]['orderDetailData']['amount'], $countryName, $actualTotal, $currency, $packager, $trackNumber, "")); } else { $exporter->addRow(array($paymentTime, $account, $orderid, $weight, $shipfee, $transport, $recordNumber, $userId, "", "", "", $countryName, $actualTotal, $currency, $packager, $trackNumber, "")); foreach ($orderDetails as $detail) { $exporter->addRow(array($paymentTime, $account, $orderid, "", "", $transport, "", "", "", $detail['orderDetailData']['sku'], $detail['orderDetailData']['amount'], $countryName, "", "", "", "", "")); } } } $exporter->finalize(); // writes the footer, flushes remaining data to browser. exit; }
function act_addUserCompense($post) { global $memc_obj; //调用memcache获取sku信息 $addUser = $_SESSION['sysUserId']; $data = array(); //var_dump($post); exit; $action = $post['action']; $uid = $post['uid']; switch ($action) { case 'accountpower': $visible_platform_account = array(); /*echo "<pre>"; var_dump($post); exit;*/ foreach ($post as $key => $valueArray) { if (strpos($key, 'checkboxes_account_') !== false) { $strarr = explode('checkboxes_account_', $key); $pid = $strarr[1]; $visible_platform_account[$pid] = $valueArray; } } /*if(!$post['checkboxes_platform']){ $post['checkboxes_platform'] = array(); }else{ foreach($post['checkboxes_platform'] as $pid){ if($post['checkboxes_account_'.$pid]){ $visible_platform_account[$pid] = $post['checkboxes_account_'.$pid]; } } }*/ /*if(!$post['checkboxes_account']){ $post['checkboxes_account'] = array(); }*/ /*echo "<pre>"; var_dump($uid); echo "<br>"; var_dump($visible_platform_account); exit;*/ $data['visible_platform_account'] = json_encode($visible_platform_account); /*$data['visible_platform'] = join(',', $post['checkboxes_platform']); $data['visible_account'] = join(',', $post['checkboxes_account']);*/ $rtn = OmAccountModel::addUserCompense($uid, $data); break; default: } self::$errCode = OmAccountModel::$errCode; self::$errMsg = OmAccountModel::$errMsg; return $rtn; }