提前声明,本人也是第一次使用ecshop,公司临时有需求,所以才花了很短的时间写的这个脚本,如有好的修好建议可以评论或者私聊我,大家一起成长。上代码:
<?php
/**
* ECSHOP 批量插入商家订单 user:高
* ============================================================================
* 版权所有 2022 北京普信微芯,并保留所有权利。
* 网站地址: http://www.ecshop.com;
* ----------------------------------------------------------------------------
* 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用;不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* @author: webboy <laupeng@163.com>
* @version: v2.1
* ---------------------------------------------
*/
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
// var_dump($_REQUEST['start_at']);die;
//查找出关联有收货地址的用户及其地址信息
$addressSql = "SELECT u.user_name,u.user_id,a.* FROM " .$GLOBALS['ecs'] ->table('users'). " AS u LEFT JOIN ".$GLOBALS['ecs'] ->table('user_address')." AS a ON u.user_id = a.user_id WHERE a.user_id > 0";
//每天固定的下单
// $addressSql = "SELECT u.user_name,u.user_id,a.* FROM " .$GLOBALS['ecs'] ->table('users'). " AS u LEFT JOIN ".$GLOBALS['ecs'] ->table('user_address')." AS a ON u.user_id = a.user_id WHERE a.user_id > 100";
$addressRes = $db->getAll($addressSql);
//取出商品的id
$gsql = "SELECT goods_id,shop_price,supplier_id,supplier_status,goods_name,goods_sn,market_price FROM " .$GLOBALS['ecs'] ->table('goods'). " WHERE is_delete = 0 AND supplier_status=1";
$goods_ids = $db -> getAll($gsql);
// var_dump(get_order_sn());die;
//根据商品id进行循环插入订单信息
foreach ($addressRes as $key =&