コード例 #1
0
ファイル: baichuan.api.php プロジェクト: lqlstudio/ttae_open
 function get_goods($ids, $open_iid)
 {
     global $_G;
     $req = new TaeItemsListRequest();
     $field = 'title,num,nick,pic_url,price,location,shop_name,post_fee';
     if (is_string($ids)) {
         $ids = trim($ids, ',');
     } else {
         if (is_array($ids)) {
             $ids = implode(',', $ids);
         }
     }
     $req->setFields($field);
     $req->setNumIids($ids);
     $req->setOpenIids($open_iid);
     $resp = $_G['TOP']->execute($req);
     top_check_error($resp, true);
     $arr = array();
     $item = $resp->items->x_item;
     if (count($resp->items->x_item) == 1) {
         $rs = $resp->items->x_item[0];
         $arr = $this->parse_goods($rs);
         return $arr;
     } else {
         $arr = array();
         foreach ($resp->items->x_item as $k => $v) {
             $numiid = (string) $v->open_id;
             $arr[$numiid] = $this->parse_goods($v);
         }
         return $arr;
     }
     return false;
 }
コード例 #2
0
ファイル: demo.php プロジェクト: yyueshui/taobaokedemo
function justDemo()
{
    /*
     * 第一步: 接收页面提交上来的参数,简单校验一下
     */
    //    $itemUrl = $_REQUEST['itemUrl'];
    //    $appKey = $_REQUEST['appKey'];
    //    $appSecret = $_REQUEST['appSecret'];
    $itemUrl = 'https://detail.tmall.com/item.htm?id=520360573194&skuId=3101727199054';
    $appKey = '23285002';
    $appSecret = '0559365a08a6c5c71c321df373591512';
    if (empty($itemUrl) && empty($appKey) && empty($appSecret)) {
        Ajax::error('请求参数错误!');
    }
    $itemId = getIdInUrl($itemUrl);
    if (empty($itemId)) {
        Ajax::error('url错误,未能获取到商品id!');
    }
    /*
     * 第二步: 调用top接口拿到商品数据
     * 接口说明文档地址:
     * http://api.taobao.com/apidoc/api.htm?path=scopeId:11471-apiId:23731
     */
    $c = new TopClient();
    $c->appkey = $appKey;
    $c->secretKey = $appSecret;
    $req = new TaeItemsListRequest();
    $req->setFields('num,title,nick,pic_url,location,cid,price,post_fee,promoted_service');
    $req->setNumIids($itemId);
    $resp = $c->execute($req);
    if (!isset($resp['items'])) {
        //缺少权限包,则跳转到权限申请页面
        if (isset($resp['msg']) && isset($resp['sub_code']) && $resp['msg'] == 'Insufficient isv permissions' && $resp['sub_code'] == 'isv.permission-api-package-limit') {
            Ajax::error('isv.permission-api-package-limit');
        }
        Ajax::error('top接口获取商品失败');
    }
    /*
     * 第三步: 整理数据入库
     */
    $DB = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USERNAME, DB_PASSWORD);
    $table = DB_TABLE;
    if (isset($resp['items']) && isset($resp['items']['x_item']) && isset($resp['items']['x_item'][0])) {
        $tmp = $resp['items']['x_item'][0];
    }
    //检查一下是否存在表
    $sql = "SHOW TABLES LIKE '%{$table}%';";
    $rc = $DB->query($sql)->rowCount();
    if (!$rc) {
        $sqlFile = file_get_contents('items.sql');
        $DB->exec($sqlFile);
    }
    //检查是否存在该商品
    $openId = $tmp['open_auction_iid'];
    $sql = "SELECT * FROM `{$table}` WHERE `tb_item_id` LIKE '{$openId}'";
    $query = $DB->query($sql);
    $query->setFetchMode(PDO::FETCH_ASSOC);
    $rs = $query->fetchAll();
    if ($rs) {
        Ajax::error('已经存在该商品.');
    } else {
        $sql = "INSERT INTO `{$table}`\n        (`id`, `pic`, `reserve_price`, `price`, `tb_item_id`,`tb_iid`, `name`, `is_mall`)\n        VALUES\n        (NULL,\n        '" . $tmp['pic_url'] . "',\n        '" . $tmp['reserve_price'] * 100 . "',\n        '" . $tmp['price'] * 100 . "',\n        '" . $tmp['open_auction_iid'] . "',\n        '" . $itemId . "',\n        '" . $tmp['title'] . "',\n        '" . ($tmp['mall'] ? 1 : 0) . "');";
        $rs = $DB->exec($sql);
        if (!$rs) {
            Ajax::error('数据入库失败.');
        }
    }
    /*
     * 最后: 返回数据,前端可以通过控制台查看数据结果.
     */
    Ajax::go($resp);
}