public static function addProvider(Provider $provider) { $result = DBClass::execute('INSERT INTO AWS_GCP (Provider_Name,Description, Provider_Image,Service_Model,Deployment_Model,Server_Location,Criteria, Subscription_Method,Suitability,Industry,cloud_id) VALUES (?, ?,?,?,?,?,?,?,?,?,?)', array($provider->name, $provider->description, $provider->image, $provider->service_model, $provider->deploy_model, $provider->location, $provider->criteria, $provider->sub_method, $provider->suitability, $provider->industry, $provider->cloud_id)); //if (count($provider->services) > 0) { //echo $provider->services; foreach ($provider->services as $service) { self::addService($service, $provider); //echo $result; } //} //echo $result; return $result; }
##############电子类产品SKU(指定国家的订单直接走香港小包)#############START //add by Herman.Xi 2012-10-26 $__elecsku_countrycn_array = array('阿尔巴尼亚','奥地利','比利时','保加利亚','白俄罗斯','捷克','爱沙尼亚','希腊','克罗地亚','匈牙利','爱尔兰','冰岛','立陶宛','卢森堡','拉脱维亚','摩尔多瓦','马耳他','葡萄牙','罗马尼亚','塞尔维亚','瑞典','斯洛文尼亚','斯洛伐克'); $__liquid_items_elecsku=array('7769_1','7769_2','7769_3','166','869','312','24','298','329','1039','1378','4243','4276','947','361','269','819','1114','1406','1897','1992','6342','1407','1992','4124','4766','4878','5884','5885','5886','734','1602','1603','1631','1632','1634','2351','3620_B','50','195','207','TK0014','TK0015','TK0016','TK0017','TK0018','TK0023','TK0025','TK0026','TK0049','TK0050','TK0051','TK0052','TK0053','TK0054','TK0055','TK0080','TK0087','TK0091','TK0092','TK0131','TK0132','TK0133','TK0134','TK0135','TK0136','TK0137','TK0138','TK0139','TK0140','TK0151','TK0152','TK0160','TK0163','TK0164','TK0165','TK0183','TK0187','TK0189','TK0193','TK0201','TK0213','TK0215','TK0217','TK0224','TK0230','TK0231','TK0233','TK0239','TK0244','TK0245','TK0246','TK0269'); ##############电子类产品SKU(指定国家的订单直接走香港小包)#############END*/ ///////////////some global configuration////////////////// include_once SCRIPT_ROOT . 'config_row/config_database_row_scripts.php'; include_once SCRIPT_ROOT . "dbconnect.php"; include_once SCRIPT_ROOT . "xmlhandle.php"; include_once SCRIPT_ROOT . "cls_page.php"; //include_once "ebay_order_cron_func.php"; //include_once "shipping_calc_fun.php"; $dbcon = new DBClass(); $sql = "select category,skulist,original_transport,current_transport,country from ebay_adjust_transport "; //特殊料号数据库 $result = $dbcon->execute($sql); $ebay_adjust_transport = $dbcon->getResultArray($result); $dbcon->free_result($result); $__liquid_items_postbyhkpost = explode(",", $ebay_adjust_transport[0]['skulist']); //液体产品 $__liquid_items_postbyfedex = explode(",", $ebay_adjust_transport[1]['skulist']); //贵重物品走联邦 $__liquid_items_cptohkpost = explode(",", $ebay_adjust_transport[2]['skulist']); //指甲油转香港小包 $__liquid_items_elecsku = explode(",", $ebay_adjust_transport[3]['skulist']); //电子类产品走香港小包 $__elecsku_countrycn_array = explode(",", $ebay_adjust_transport[3]['country']); //电子类产品指定国家 $__liquid_items_fenmocsku = explode(",", $ebay_adjust_transport[4]['skulist']); //粉末状SKU $__liquid_items_BuiltinBattery = explode(",", $ebay_adjust_transport[5]['skulist']);
public static function addWidget(Widget $widget) { $widget_data = json_encode($widget->widget_data); return DBClass::execute('INSERT INTO uf_widgets (wid, stitle, fSid, wtitle, num_cards, link_text, purl, sharer, textnotes, data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array($widget->wid, $widget->stitle, $widget->fSid, $widget->wtitle, $widget->num_cards, $widget->link_text, $widget->purl, $widget->sharer, $widget->textnotes, $widget_data)); }
<?php set_time_limit(0); ini_set('memory_limit', '800M'); if (strpos($_SERVER['HTTP_HOST'], '113')) { include "../../include/dbconnect.php"; $agency_host = "http://113.108.97.88:90/glv3/"; } else { include "db_connect.php"; $agency_host = "http://" . $_SERVER['HTTP_HOST'] . "/"; } $dbcon = new DBClass(); $defaultstoreid = 12; $user = "******"; $ss = "select ebay_account from ebay_account where ebay_account like '%@%' and ebay_user ='******' "; $ss = $dbcon->execute($ss); $ss = $dbcon->getResultArray($ss); $options_str = ""; //$agency_host = "http://113.108.97.88:90/glv3/"; foreach ($ss as $key => $val) { $options_str .= '<option value="' . $val['ebay_account'] . '">' . $val['ebay_account'] . '</option>'; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Amazon订单同步</title> <script language="javascript" type="text/javascript" src="../../My97DatePicker/WdatePicker.js"></script>
set_time_limit(0); header("Content-type:text/html;charset=utf-8"); include "db_connect.php"; $dbcon = new DBClass(); /** $ss = "show tables;"; $ss = $dbcon->execute($ss); $ss = $dbcon->getResultArray($ss); var_dump($ss);exit; /**/ $content = file_get_contents("ebay_order.sql"); $preg = "/;;;ordersn:([^\\s]+)\\s/i"; preg_match_all($preg, $content, $arr); foreach ($arr[1] as $key => $val) { $ordersn = trim($val); $sql = "select ebay_account from ebay_order where ebay_ordersn='{$ordersn}' and ebay_account='*****@*****.**' limit 1"; $sql = $dbcon->execute($sql); $sql = $dbcon->getResultArray($sql); if (!empty($sql)) { $account = $sql[0]['ebay_account']; if (!empty($account) && $account == '*****@*****.**') { $update_sql = "update ebay_order set ebay_account='*****@*****.**' where ebay_ordersn='{$ordersn}' and ebay_account='*****@*****.**' limit 1"; //echo $update_sql."<br>"; $dbcon->execute($update_sql); echo '$ordersn:' . $ordersn . "<br>"; //exit; } } } echo 'finish<pre>';
<?php $mctime = time(); echo "脚本开始时间" . date('Y-m-d H:i:s', $mctime) . "\n"; include "include/dbconnect.php"; $dbcon = new DBClass(); include "include/function_general.php"; include "include/function_purchase.php"; $url = 'http://idc.gw.open.valsun.cn/router/rest?'; //idc开放系统入口地址 $token = 'a6c94667ab1820b43c0b8a559b4bc909'; //用户finejo token error_reporting(-1); $carriersql = "SELECT * FROM ebay_carrier "; $carriersql = $dbcon->execute($carriersql); $carrierList = $dbcon->getResultArray($carriersql); $carrierArr = array(); $transportList = getCarrierListById(); $flip_transportList = array_flip($transportList); foreach ($carrierList as $value) { $carrier = $value['name']; if ($carrier == '海运运输') { continue; } //echo $carrier; echo "\n"; if ($carrier == "英国专线挂号") { $carrier = "英国专线挂号"; $id = 63; } else { if ($carrier == "天天快递") { $carrier = "天天快递";
header("Content-type:text/html;charset=utf-8"); echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> '; include "db_connect.php"; $dbcon = new DBClass(); $defaultstoreid = 12; $user = "******"; $account = "*****@*****.**"; /**************************************/ $account = $_REQUEST['account']; $update_addr = $_REQUEST['update_addr']; if (empty($account)) { die("Please select amazon account."); } if (!empty($update_addr)) { $sql = "select ebay_id,ebay_street,ebay_street1,ebay_city,ebay_state from ebay_order where ebay_status=822 and ebay_account='{$account}' and ( ebay_countryname='France' or ebay_countryname='Germany' )"; $sql = $dbcon->execute($sql); $sql = $dbcon->getResultArray($sql); if (!empty($sql)) { foreach ($sql as $key => $val) { $ebay_street = $val['ebay_street']; $ebay_street1 = $val['ebay_street1']; $ebay_city = $val['ebay_city']; $ebay_state = $val['ebay_state']; $ebay_id = $val['ebay_id']; $is_update = false; if (empty($ebay_street) && !empty($ebay_street1)) { $ebay_street = $ebay_street1; $is_update = true; } if (!empty($ebay_street) && empty($ebay_street1)) { $ebay_street1 = $ebay_street;
$detail_id = $_POST['detail_id']; $sku = $_POST['sku']; $type = $_POST['type']; $check_status = $_POST['check_status']; $notecontent = isset($_POST['pcontent']) ? $_POST['pcontent'] : ''; //强制拦截时输入拦截理由 add by guanyongjun 2013-09-17 if ($check_status == '2') { $notecontent = ",notecontent='{$notecontent}'"; } //审核检查 add by rdh 2013-11-04 if ($check_status == '1') { $realStore = 0; $needSend = 0; $orderSkuNum = 0; $sql = "select goods_count from ebay_onhandle where goods_sn='{$sku}' and store_id='76' "; $sql = $dbcon->execute($sql); $sql = $dbcon->getResultArray($sql); $realStore = $sql[0]['goods_count']; //实际库存 $needSend = getpartsaleandnosendall($sku, '76'); //待发货 $sql2 = "select ebay_amount from ebay_orderdetail where ebay_id='{$detail_id}' "; $sql2 = $dbcon->execute($sql2); $sql2 = $dbcon->getResultArray($sql2); $orderSkuNum = $sql2[0]['ebay_amount']; //订单数量 $diffNum = $realStore - $needSend - $orderSkuNum; if ($diffNum < 0) { $res['code'] = '002'; $res['data']['msg'] = "该料号的实际库存{$realStore} - 待发货{$needSend} 小于 订购数量{$orderSkuNum} 审核不通过!"; echo json_encode($res);
[ 'client' => 'awesome' ], // ← document [ 'w' => 0 ] // ← don't acknowledge writes for this insert ); */ $dbcon = new DBClass(); $MemcacheObj = new Memcache(); /* $sql = "SELECT * FROM `ebay_ordergrossrate` WHERE `is_effectiveorder` = 1 AND `is_delete` = 0 AND `order_scantime` BETWEEN '1404748800' AND '1404835199' ORDER BY `order_scantime` DESC limit 50,50000"; $sql = $dbcon->execute($sql); $skuinfo = $dbcon->getResultArray($sql); foreach($skuinfo as $item){ $m->bigdata->ebay->insert($item); } */ $sql = "SELECT ebay_account,ebay_platform FROM ebay_account WHERE ebay_platform!='' ORDER BY ebay_platform ASC"; $sql = $dbcon->execute($sql); $eaccounts = $dbcon->getResultArray($sql); $accounts = array(); $cn2enarr = array('ebay平台' => 'ebay', '亚马逊' => 'amazon', '出口通' => 'chukoutong', '国内销售部' => 'guonei', '天猫哲果' => 'zegoo', '天猫芬哲' => 'fenjo', '海外仓' => 'oversea', '线下结算客户' => 'offline'); foreach ($eaccounts as $eaccount) { $enAccount = $cn2enarr[$eaccount['ebay_platform']]; if (isset($enAccount)) { $accounts[$enAccount][] = $eaccount['ebay_account']; } else { $accounts[$eaccount['ebay_platform']][] = $eaccount['ebay_account']; } } $sql = "SELECT count(*) as total FROM `ebay_goods` "; $sql = $dbcon->execute($sql); $number = $dbcon->fetch_one($sql); $length = ceil($number['total'] / 1000);
public function deleteOneByName($nam, $val) { $sql = 'DELETE FROM ' . static::$table . ' WHERE ' . $nam . '=?'; $db = new DBClass(); return $db->execute($sql, array($val)); }
$start = "2013-08-20 02:00:00"; /**/ $account = "*****@*****.**"; //$account = "*****@*****.**"; $AWS_ACCESS_KEY_ID = "AKIAJWV3E4ZQGNEQH2FQ"; $AWS_SECRET_ACCESS_KEY = "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"; $MERCHANT_ID = "A11S9UEFFS8HNW"; $MARKETPLACE_ID = "ATVPDKIKX0DER"; $serviceUrl = 'https://mws.amazonservices.com/Orders/2011-01-01'; /**************************************/ $account = $_REQUEST['account']; if (empty($account)) { die("请选择账号"); } $ss = "select * from ebay_account where ebay_account ='{$account}' and ebay_user ='******' "; $ss = $dbcon->execute($ss); $ss = $dbcon->getResultArray($ss); $AWS_ACCESS_KEY_ID = $ss[0]['AWS_ACCESS_KEY_ID']; $AWS_SECRET_ACCESS_KEY = $ss[0]['AWS_SECRET_ACCESS_KEY']; $MERCHANT_ID = $ss[0]['MERCHANT_ID']; $MARKETPLACE_ID = $ss[0]['MARKETPLACE_ID']; $serviceUrl = $ss[0]['serviceUrl'] . '/Orders/2011-01-01'; /**************************************/ define('AWS_ACCESS_KEY_ID', $AWS_ACCESS_KEY_ID); define('AWS_SECRET_ACCESS_KEY', $AWS_SECRET_ACCESS_KEY); define('MERCHANT_ID', $MERCHANT_ID); define('MARKETPLACE_ID', $MARKETPLACE_ID); set_include_path(get_include_path() . PATH_SEPARATOR . '../../.'); function __autoload($className) { $filePath = str_replace('_', DIRECTORY_SEPARATOR, $className) . '.php';