<?php

namespace model\grid;


/**
 * Class basic
 * @package model\grid
 */
class basic extends \model
{

    /**
     * @param array $where
     * @param int $page
     * @param int $pagesize
     * @param string $sidx
     * @param string $sord
     * @param string $orderby
     * @return array
     */
	public function list($where=[],$page=0,$pagesize=0,$sidx='',$sord='asc',$orderby=''){
		$where = $this->listWhere($where,$page,$pagesize,$sidx,$sord,$orderby);
		$table = "grid_basic";
		$fields = "*";
		if($page>0 && $pagesize>0){
			$pages = $this->paging($table,$where,$page,$pagesize);
			$where["LIMIT"] = [$pages['limit'],$pagesize];
		}
		$rows = $this->db->select($table,$fields,$where);
		$data = [
			'page'=> $page,
			'total'=> $pages['total'],
			'records' => $pages['records'],
			'rows' => $rows
		];
		return $data;
	}

    /**
     * @param $table
     * @param array $where
     * @param int $page
     * @param int $pagesize
     * @param string $sidx
     * @param string $sord
     * @param string $orderby
     * @return array
     */
	function lists($table,$where=[],$page=0,$pagesize=0,$sidx='',$sord='asc',$orderby='')
    {
        $where = $this->listWhere($where,$page,$pagesize,$sidx,$sord,$orderby);
        $fields = "*";
        if($page>0 && $pagesize>0){
            $pages = $this->paging($table,$where,$page,$pagesize);
            $where["LIMIT"] = [$pages['limit'],$pagesize];
        }

        $rows = $this->db->select($table,$fields,$where);

        $data = [
            'page'=> $page,
            'total'=> $pages['total'],
            'records' => $pages['records'],
            'rows' => $rows
        ];
        return $data;
    }

    /**
     * @param $id
     * @param $table
     * @return mixed
     */
    public function getByID($id,$table)
    {
        $fields = "*";
        $rows = $this->db->select($table,$fields,['id'=>$id]);
        if(!empty($rows)){
            return $rows[0];
        }
    }

}