医疗器械 当访问后台自动批量下架过期产品

 

 

html代码：

 

<script type="text/javascript">
  function dophpn(){
      var url = '/admin_nx_gl/operation_page.php?act=plxgwcmn';
      $.getJSON(url, function(data){
        document.getElementById('dq').innerHTML = data.url;
      });
      
  }
  
  
    function dophpm(){
      var url = '/admin_nx_gl/operation_page.php?act=plxgwcmm';
      $.getJSON(url, function(data){
        document.getElementById('dw').innerHTML = data.url;
      });
      
  }
  
  
   function dophp(){
      var url = '/admin_nx_gl/operation_page.php?act=plxgwcm';
      $.getJSON(url, function(data){
        document.getElementById('de').innerHTML = data.url;
      });
      
  }
  
 
window.onload=dophpn(); 

//window.onload=dophpm(); 
//window.onload=dophp(); 

  </script>
 <span id="dq"></span>
 <span id="dw"></span>
 <span id="de"></span>

 

 

php操作数据库代码：

if ($_REQUEST['act'] == 'plxgwcmn')
{
    
       $time=time();
    
    /* 数据 */
       //  $sql = "UPDATE ".$ecs->table('goods')." SET flag=1, is_on_sale=0  WHERE pass_number !='' AND term_of_validity <= ".$time." AND is_on_sale =1";

    $sql =  "UPDATE".$ecs->table('goods')." SET flag=UNIX_TIMESTAMP(), is_on_sale=0  WHERE goodstype=1 and  pass_number =''  AND is_on_sale =1 AND cat_id IN (SELECT cat_id FROM " . $ecs->table('category') . " WHERE parent_id IN (SELECT cat_id FROM " . $ecs->table('category') . " WHERE parent_id IN (951,1185,1282,950,1325)))";

    $db->query($sql);
        
        
    $ret = array('url' => '操作成功！',);
    echo   json_encode($ret);
    /* 模板赋值 */
    $smarty->assign('ur_here',    '页面操作');

     $smarty->assign('full_page',   1);

 
 
    $smarty->display('operation_page.htm');
}