<main>
  <div class="container-fluid">
    <div class="row align-items-center justify-content-between pt-2">
      <div class="col-auto mb-3">
        <h4>
            <b>items</b>
        </h4>
      </div>
      <div class="col-12 col-xl-auto mb-3">
        
        <a class="btn btn-xs cl-in1" href="?op=items&col1=st&q1=1&sortby=update_at">ready stok - update_at</a>
        <a class="btn btn-xs cl-dp2" href="?op=items&col1=st&q1=0&sortby=variant_count&mc=size_count&mv=0">cek</a>
        <a class="btn btn-xs cl-lg4" href="?op=items&col=size_count&q=0">size=0 [stok kosong]</a>
        <a class="btn btn-xs cl-dp" href="?op=items&col1=st&q1=1&sortby=price">by price</a>
        <a class="btn btn-xs cl-dp1" href="?op=items&col1=st&q1=1&sortby=stock">by stock</a>
        <a class="btn btn-xs cl-dp10" href="?op=items&col1=st&q1=1&sortby=size_count">by size</a>
        <a class="btn btn-xs cl-dp2" href="?op=items&col1=st&q1=1&sortby=variant_count">by color</a>
        <a class="btn btn-xs cl-dp3" href="?op=items&col1=st&q1=1&sortby=weight2">by weight</a>
        <a class="btn btn-xs cl-dp4" href="?op=items&op2=json">fJson</a>
        <a class="btn btn-xs cl-dp4" href="?op=items&op2=backup">BackupToOld</a>
      </div>
    </div>
    <div class="row">
      <div class="col-12">
       <?php
       foreach ($ar['key_tag'] as $k => $v) {
          echo '<a href="?op=items&col=st&q=1&lcol=name&lq='.$v.'">'.$v.'</a> | ';
        }
       ?>            

        <hr>
       <?php
       //$js2=json_decode($js['nibcat']);
       $js2=json_decode($ar['js']['nibrascat']);
       foreach ($ar['idcat'] as $k => $v) {
          echo '<a href="?op=items&col=st&q=1&col2=cat&q2='.$v.'">'.$v.' '.$js2->$v->name.'</a> | ';
        }
       ?>    <a href="?op=items&col=st&q=1&col2=cat&q2=0">Non Category</a>           
      </div>
    </div>      
      
    <?php
    switch($op2) {

      case "json";
          //fjson("");
          fjson3();
        break;
      
      case "json2";
          fjson($_POST['json']);
          //echo "<pre"
        break;
      case "backup";
          $sql="SELECT id,url,name,img,img_zoom,img_cover,code,weight,percent,description,keywords,price,price2,weight2,stock,stock2,create_at,update_at,variant_count,size_count,idurl,cat,descr_word_len,descr_char_len,del,is_product,st,cek from `items`";
          $res=mysqli_query($db,$sql);
          while($r1=mysqli_fetch_assoc($res)) {
            $idt=array(
              'id'=>$r1['id'],
              'url'=>$r1['url'],
              'name'=>gpc($r1['name']),
              'img'=>$r1['img'],
              'img_zoom'=>$r1['img_zoom'],
              'img_cover'=>$r1['img_cover'],
              'code'=>$r1['code'],
              'weight'=>$r1['weight'],
              'percent'=>$r1['percent'],
              'description'=>gpc($r1['description']),
              'keywords'=>$r1['keywords'],
              'price'=>$r1['price'],
              'price2'=>$r1['price2'],
              'weight2'=>$r1['weight2'],
              'stock'=>$r1['stock'],
              'create_at'=>$r1['create_at'],
              'update_at'=>$r1['update_at'],
              'variant_count'=>$r1['variant_count'],
              'size_count'=>$r1['size_count'],
              'idurl'=>$r1['idurl'],
              'cat'=>$r1['cat'],
              'del'=>$r1['del'],
              'is_product'=>$r1['is_product'],
              'st'=>$r1['st'],
            );
            $udt=array(
              'description'=>gpc($r1['description']),
              'stock'=>$r1['stock'],
              'variant_count'=>$r1['variant_count'],
              'size_count'=>$r1['size_count'],
              'st'=>$r1['st'],
            );
            InsertUpdate($db,"items_old",$idt,$udt,0);
          }

        break;

      case "list";
        default;
        list_items($q,$col,$q1,$col1,$q2,$col2,$lq,$lcol,$mc,$mv,$lc,$lv,$sortby);
    }
    
    ?>
      
  </div>
</main>                    

<?php
function list_items($q,$col,$q1,$col1,$q2,$col2,$lq,$lcol,$mc,$mv,$lc,$lv,$sortby) {
  global $db,$ar;
  
  //print_r($ar);
  if($col2=='cat' && $q2>0) {
    $js2=json_decode($ar['js']['nibrascat']);
    //echo $q2."<br>";
    echo "<b>".$js2->$q2->name."</b>, Size: ".$js2->$q2->sizes."<br>";
    //echo "<pre>"; print_r($js2); echo "</pre>";
  }  
  ?>
  <table class="table table-bordered table-hover" id="dataTable_8d" width="100%" cellspacing="0">
    <thead>
        <tr>
            <th>id</th>
            <th>title</th>
            <th>code</th>
            <th>key</th>
            <th>url</th>
            <th>size</th>
            <th>color</th>
            <th>weight</th>
            <th>price</th>
            <th>stock</th>
            <th>%</th>
            <th>Nilai</th>
            <th>st</th>
            <th>cat</th>
            <th>idurl</th>            
            <th>uDate</th>            
            <th>Menu</th>
        </tr>
    </thead>

    <tbody>
    <?php
    $sql = "select * from `items` where del=0 ";
        if($col!='') {
            $sql .= " and `".$col."`='".$q."'";
        }
        if($col1!='') {
            $sql .= " and `".$col1."`='".$q1."'";
        }
        if($col2!='') {
            $sql .= " and `".$col2."`='".$q2."'";
        }
        if($lcol!='') {
            $sql .= " and `".$lcol."` like '%".$lq."%'";
        }
        if($lc!='') {
            $sql .= " and `".$lc."`<'".$lv."'";
        }
        if($mc!='') {
            $sql .= " and `".$mc."`>'".$mv."'";
        }
        $res = mysqli_query($db, $sql);
        $sql2 = $sql." order by ".$sortby." desc limit 100";

    $res2 = mysqli_query($db, $sql2);
    //echo $sql;
    $j['stock']=$j['nb']=0;
    while($rw = mysqli_fetch_assoc($res2)) {
      if($rw['keywords']!='') {
        $ek=explode(", ",$rw['keywords']);
        if(count($ek)>1) {
          $keyw="";
          foreach ($ek as $k => $v) {
            $keyw .='<a href="?op=items&lcol=keywords&lq='.$v.'">'.$v.'</a>, ';
          }
        } else {
          $keyw='<a href="?op=items&lcol=keywords&lq='.$rw['keywords'].'">'.$rw['keywords'].'</a>';
        }

      } else {
        $keyw='';
      }

      $nb=$rw['stock']*$rw['price']/1000;
      $j['stock']=$j['stock']+$rw['stock'];
      $j['nb']=$j['nb']+$nb;
    
    ?>
    
        <tr id="row-<?=$rw['id'];?>">
            <td><?=$rw['id'];?></td>            
            <td><?=$rw['name'];?></td>
            <td><?=$rw['code'];?></td>
            <td><?=$keyw;?></td>
            <td>
              <a href="<?=$rw['url'];?>" target="_blank"><?=substr($rw['url'],27);?></a>
            </td>
            
            <td class="text-right"><?=$rw['size_count'];?></td>            
            <td class="text-right"><?=$rw['variant_count'];?></td>            
            <td class="text-right"><?=$rw['weight'];?></td>
            <td class="text-right"><?=ang2($rw['price']);?></td>           
            <td class="text-right"><?=$rw['stock'];?></td>
            <td class="text-right"><?=$rw['percent'];?></td>           
            <td class="text-right"><?=ang2($nb);?></td>           
            <td class="text-right"><a href="?op=items&col=st&q=<?=$rw['st'];?>"><?=$rw['st'];?></a></td>
            <td class="text-right"><a href="?op=items&col=cat&q=<?=$rw['cat'];?>"><?=$rw['cat'];?></a></td>
            <td class="text-right"><?=$rw['idurl'];?></td>           
            <td class="text-right"><a href="dom/item_update.php?id=<?=$rw['id'];?>&slug=<?=substr($rw['url'],27)?>" target="_blank"><?=date("y.m.d H.i.s",$rw['update_at']);?></a></td>           
            <td>
              <a href="#" onClick="uCol(<?=$rw['id'];?>,'st',0,'items');" class="btn btn-xs btn-color-blue">reset</a>
              <a href="#" onClick="uCol(<?=$rw['id'];?>,'del',1,'items');" class="btn btn-xs btn-color-red">del</a>               
            </td>
        </tr>
      <?php
      }
      ?>  
        
    </tbody>
    <tfoot>
        <tr>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th class="text-right"><?=ang2($j['stock']);?></th>
            <th></th>
            <th class="text-right"><?=ang2($j['nb']);?></th>
            <th></th>
            <th></th>
            <th></th>            
            <th></th>            
            <th></th>
        </tr>
    </tfoot>


  </table><hr><?=$sql2;?><br><?=mysqli_num_rows($res);?><br>
  st=1 (ready stock)<br>
  <?php

    
}

function fjson($js) {
  global $db,$ar;
  
  ?>
  <form action="index.php?op=items&op2=json2" method="post" enctype="multipart/form-data">      
    <div class="form-group row">
        <div class="col-sm-10">        
          <textarea class="form-control"  name="json" rows="10"><?=$js;?></textarea>            
        </div>
        <div class="col-sm-2">
            <button type="submit" name="submit" class="btn btn-primary">Submit</button>
        </div>
    </div>
  </form>
  <?php
}

function fjson3() {
  global $db,$ar;
  
  ?>
  <form action="http://localhost/data/nibras/api/post.item.php" method="post" enctype="multipart/form-data">
  <input type="hidden" name="op" value="add">      
    <div class="form-group row">
        <div class="col-sm-10">        
          <textarea class="form-control"  name="json" rows="10"></textarea>            
        </div>
        <div class="col-sm-2">
            <button type="submit" name="submit" class="btn btn-primary">Submit</button>
        </div>
    </div>
  </form>
  <?php
}


?>