sku 加减号的增删

---恢复内容开始---

//php页面

public function test(){

   $id="1";

   $data=Db::table('week3_goods')

       ->join("week3_hp","week3_goods.g_id=week3_hp.goods_id")

       ->join("week3_goods_attr","week3_hp.g_a_id=week3_goods_attr.g_a_id")

       ->where("week3_goods.g_id",$id)

       ->select();

    //print_r($data);die;

  foreach($data as $k =>$v){

      if($v['a_id']){

          $ids=explode(',',$v['a_id']);

          foreach($ids as $kk =>$vv){

              $res=Db::table('week3_attr')->where("a_id",$vv)->find();

              $ids[$kk]=$res['a_val'];

              $data[$k]['attr']=$ids;

          }

      }

  }

    $color=Db::table('week3_attr')->where("a_name",'颜色')->select();

    $buttor=Db::table('week3_attr')->where("a_name","内存")->select();

    return view("index",['color'=>$color,'buttor'=>$buttor,'arr'=>$data]);

}

//添加数据

public function add(){

    $data=Request::instance()->param();

    foreach($data['color'] as $k =>$v){

        $arr['goods_id']=$data['goods_id'];

        $arr['attr']=$data['color'][$k].",".$data['buttor'][$k];

        $arr['hp_num']=$data['hp_num'][$k];

        $arr['stock']=$data['stock'][$k];

        $res[]=$arr;

    }

    print_r($res);

}

//hrml页面   循环输出数据

<center>

    <tr>

    <th>

        商品名称：{$arr[0]['g_name']}

        货物：{$arr[0]['hp_num']}

    </th>

</tr>

    <table>

        <form action="{:url('login/add')}">

            <input type="hidden" value="{$arr[0]['goods_id']}" name="goods_id"/>

            <tr>

                <td>颜色</td>

                <td>内存</td>

                <td>货号</td>

                <td>库存</td>

                <td>操作</td>

            </tr>

            {volist name="arr" id="vv"}

            <tr>

                <td>

                    <select name="color[]" id="color">

                        <?php foreach($color as $k =>$v){?>

                        <option value="<?php echo $v['a_id']?>"

                            <?php if($v['a_val']==$vv['attr'][0]){

                         echo "selected";

                         } ?>><?php echo $v['a_val'];?>

                       </option>

                        <?php }?>

                    </select>

                </td>

                <td>

                    <select name="buttor[]" id="buttor">

                        <?php foreach($buttor as $k =>$v){?>

                        <option value="<?php echo $v['a_id']?>"

                        <?php if($v['a_val']==$vv['attr'][0]){

                         echo "selected";

                         } ?>><?php echo $v['a_val'];?>

                        </option>

                        <?php }?>

                    </select>

                </td>

                <td><input type="text" value="{$vv['hp_num']}" name="hp_num[]"/></td>

                <td><input type="text" value="{$vv['stock']}" name="stock[]"/></td>

                <td><input type="button" value="+" class="jia"/></td>

            </tr>

            {/volist}

            <tr>

                <td><input type="submit" value="添加"/></td>

            </tr>

        </form>

    </table>

</center>

//jquery   界面

//加减号的改变

$(document).on('click','.jia',function(){

    var obj=$(this).parents("tr").clone();

    obj.find(".jia").attr('value','-');

    obj.find(".jia").attr('class','jian');

    $(this).parents("tr").after(obj);

});

$(document).on('click','.jian',function(){

    $(this).parents("tr").remove();

});

---恢复内容结束---

//php页面

public function test(){

   $id="1";

   $data=Db::table('week3_goods')

       ->join("week3_hp","week3_goods.g_id=week3_hp.goods_id")

       ->join("week3_goods_attr","week3_hp.g_a_id=week3_goods_attr.g_a_id")

       ->where("week3_goods.g_id",$id)

       ->select();

    //print_r($data);die;

  foreach($data as $k =>$v){

      if($v['a_id']){

          $ids=explode(',',$v['a_id']);

          foreach($ids as $kk =>$vv){

              $res=Db::table('week3_attr')->where("a_id",$vv)->find();

              $ids[$kk]=$res['a_val'];

              $data[$k]['attr']=$ids;

          }

      }

  }

    $color=Db::table('week3_attr')->where("a_name",'颜色')->select();

    $buttor=Db::table('week3_attr')->where("a_name","内存")->select();

    return view("index",['color'=>$color,'buttor'=>$buttor,'arr'=>$data]);

}

//添加数据

public function add(){

    $data=Request::instance()->param();

    foreach($data['color'] as $k =>$v){

        $arr['goods_id']=$data['goods_id'];

        $arr['attr']=$data['color'][$k].",".$data['buttor'][$k];

        $arr['hp_num']=$data['hp_num'][$k];

        $arr['stock']=$data['stock'][$k];

        $res[]=$arr;

    }

    print_r($res);

}

//hrml页面   循环输出数据

<center>

    <tr>

    <th>

        商品名称：{$arr[0]['g_name']}

        货物：{$arr[0]['hp_num']}

    </th>

</tr>

    <table>

        <form action="{:url('login/add')}">

            <input type="hidden" value="{$arr[0]['goods_id']}" name="goods_id"/>

            <tr>

                <td>颜色</td>

                <td>内存</td>

                <td>货号</td>

                <td>库存</td>

                <td>操作</td>

            </tr>

            {volist name="arr" id="vv"}

            <tr>

                <td>

                    <select name="color[]" id="color">

                        <?php foreach($color as $k =>$v){?>

                        <option value="<?php echo $v['a_id']?>"

                            <?php if($v['a_val']==$vv['attr'][0]){

                         echo "selected";

                         } ?>><?php echo $v['a_val'];?>

                       </option>

                        <?php }?>

                    </select>

                </td>

                <td>

                    <select name="buttor[]" id="buttor">

                        <?php foreach($buttor as $k =>$v){?>

                        <option value="<?php echo $v['a_id']?>"

                        <?php if($v['a_val']==$vv['attr'][0]){

                         echo "selected";

                         } ?>><?php echo $v['a_val'];?>

                        </option>

                        <?php }?>

                    </select>

                </td>

                <td><input type="text" value="{$vv['hp_num']}" name="hp_num[]"/></td>

                <td><input type="text" value="{$vv['stock']}" name="stock[]"/></td>

                <td><input type="button" value="+" class="jia"/></td>

            </tr>

            {/volist}

            <tr>

                <td><input type="submit" value="添加"/></td>

            </tr>

        </form>

    </table>

</center>

//jquery   界面

//加减号的改变

$(document).on('click','.jia',function(){

    var obj=$(this).parents("tr").clone();

    obj.find(".jia").attr('value','-');

    obj.find(".jia").attr('class','jian');

    $(this).parents("tr").after(obj);

});

$(document).on('click','.jian',function(){

    $(this).parents("tr").remove();

});