关于库存量 - adstat

 1 public function goods_number()
 2     {
 3         // 接收商品ID
 4         $id = I('get.id');
 5         $gnModel = D('goods_number');
 6         
 7         // 处理表单
 8         if(IS_POST)
 9         {
　　　　　　　　 //var_dump($_POST)die;
10             // 先删除原库存
11             $gnModel->where(array(
12                 'goods_id' => array('eq', $id),
13             ))->delete();
14             //var_dump($_POST);die;
15             $gaid = I('post.goods_attr_id');
16             $gn = I('post.goods_number');
17             // 先计算商品属性ID和库存量的比例
18             $gaidCount = count($gaid);
19             $gnCount = count($gn);
20             $rate = $gaidCount/$gnCount;
21             // 循环库存量
22             $_i = 0;  // 取第几个商品属性ID
23             foreach ($gn as $k => $v)
24             {
25                 $_goodsAttrId = array();  // 把下面取出来的ID放这里
26                 // 后来从商品属性ID数组中取出 $rate 个，循环一次取一个
27                 for($i=0; $i<$rate; $i++)
28                 {
29                     $_goodsAttrId[] = $gaid[$_i];
30                     $_i++;
31                 }
32                 // 先升序排列
33                 sort($_goodsAttrId, SORT_NUMERIC);  // 以数字的形式排序
34                 // 把取出来的商品属性ID转化成字符串
35                 $_goodsAttrId = (string)implode(',', $_goodsAttrId);
36                 $gnModel->add(array(
37                     'goods_id' => $id,
38                     'goods_attr_id' => $_goodsAttrId,
39                     'goods_number' => $v,
40                 ));
41             }
42             $this->success('设置成功！', U('goods_number?id='.I('get.id')));
43             exit;
44         }
45         
46         // 根据商品ID取出这件商品所有可选属性的值
47         $gaModel = D('goods_attr');
48         $gaData = $gaModel->alias('a')
49         ->field('a.*,b.attr_name')
50         ->join('LEFT JOIN __ATTRIBUTE__ b ON a.attr_id=b.id')
51         ->where(array(
52             'a.goods_id' => array('eq', $id),
53             'b.attr_type' => array('eq', '可选'),
54         ))->select();
55         // 处理这个二维数组：转化成三维：把属性相同的放到一起
56         $_gaData = array();
57         foreach ($gaData as $k => $v)
58         {
59             $_gaData[$v['attr_name']][] = $v;
60         }
61         
62         // 先取出这件商品已经设置过的库存量
63         $gnData = $gnModel->where(array(
64             'goods_id' => $id,
65         ))->select();
66         //var_dump($gnData);
67         
68         $this->assign(array(
69             'gaData' => $_gaData,
70             'gnData' => $gnData,
71         ));
72         
73         // 设置页面信息
74         $this->assign(array(
75             '_page_title' => '库存量',
76             '_page_btn_name' => '返回列表',
77             '_page_btn_link' => U('lst'),
78         ));
79            // 1.显示表单
80            $this->display();
81     }