PHP.43-TP框架商城应用实例-后台16-商品属性3-库存量管理

　　　　//    处理库存量
    public function goods_number()
    {
        //接收商品ID
        $id = I(‘get.id‘);
        $gnModel = M(‘goods_number‘);

        //处理表单
        if(IS_POST)
        {
            // 先删除原库存，再添加，实现修改
            $gnModel->where(array(
                ‘goods_id‘ => array(‘eq‘, $id),
            ))->delete();
            $gaid = I(‘post.goods_attr_id‘);
            $gnum = I(‘post.goods_number‘);
            //统计数量，计算比例
            $cgaid = count($gaid);
            $cgnum = count($gnum);
            $rate = $cgaid/$cgnum;

            //循环库存量
            $_i = 0;
            foreach ($gnum as $k => $v)
            {
                $_goodsAttrId = array();
                //从商品属性ID数组中取出 $rate 个，循环一次取一个
                for($i=0; $i$rate; $i++)
                {
                    $_goodsAttrId[] = $gaid[$_i];
                    $_i++;
                }
                //升序排列
                sort($_goodsAttrId, SORT_NUMERIC);    //以数字的形式排序
                //把取出来的商品属性ID转化成字符串
                $_goodsAttrId = (string)implode(‘,‘, $_goodsAttrId);
                $gnModel->add(array(
                    ‘goods_id‘ => $id,
                    ‘goods_attr_id‘ => $_goodsAttrId,
                    ‘goods_number‘ => $v,
                ));
            }
        }
        //(库存量修改)先取出这件商品已经设置过的库存量
        $gnData = $gnModel->where(array(
            ‘goods_id‘ => $id,
        ))->select();

        //根据商品ID取出这件商品所有属性的值和根据属性id，取出属性表中的属性名称
        $gaModel = M(‘goods_attr‘);
        $gaData = $gaModel->field(‘a.*, b.attr_name, b.attr_type‘)
        ->alias(‘a‘)
        ->join(‘LEFT JOIN __ATTRIBUTE__ b ON a.attr_id = b.id ‘)
        ->where(array(
            ‘goods_id‘ => array(‘eq‘, $id),
            ‘b.attr_type‘ => array(‘eq‘, ‘可选‘),
        ))->select();

        //处理$gaData数据，将二维转为三维数组:把属性相同的归类
        $_gaData = array();
        foreach ($gaData as $k => $v)
        {
            $_gaData[$v[‘attr_name‘]][] = $v;        //以属性名称作为下标
        }
        //var_dump($_gaData);die;
        
        
        $this->assign(array(
            ‘gnData‘ => $gnData,
            ‘gaData‘ => $_gaData,
            ‘_page_title‘ => ‘库存量管理‘,
            ‘_page_btn_name‘ => ‘返回列表‘,
            ‘_page_btn_link‘ => U(‘lst‘),
        ));
        //显示表单
        $this->display();
    }

class="list-div" id="listDiv">

    foreach ($gaDataas$k => $v): ?>
                endforeach; ?>
            if($gnData): ?>
            foreach ($gnDataas$k0 => $v0): ?>
            class="tron">
                php 
                $gaCount = count($gaData);
                foreach ($gaDataas$k => $v): ?>
                    endforeach; ?>
                endforeach; ?>
        else: ?>
            class="tron">
                php 
                $gaCount = count($gaData);
                foreach ($gaDataas$k => $v): ?>
                    endforeach; ?>
                endif; ?>
        


  

echo $k; ?>
            
库存量
            
操作
        
  
  

                        请选择
foreach ($v as $k1 => $v1): 
                                    $_attr = explode(‘,‘, $v0[‘goods_attr_id‘]);
                                    if(in_array($v1[‘id‘], $_attr))
                                        $select = ‘selected="selected"‘;
                                    else 
                                        $select = ‘‘;
                            ?>
                                echo $select; ?> value="$v1[‘id‘]; ?>">echo $v1[‘attr_value‘]; ?>
endforeach; ?>
                        

                

                

            
  

                        请选择
foreach ($v as $k1 => $v1): ?>
                                
echo $v1[‘attr_value‘]; ?>
endforeach; ?>