function countAll(){
$CompanyGroupNo = 3;
$status = 1;
$sql = "SELECT product_code_no FROM `tbl_pcc_product_code` WHERE `status` = :status: AND `company_group_no` = :CompanyGroupNo:";
$query = $this->BaseModel->db->query($sql, ['CompanyGroupNo' => $CompanyGroupNo, 'status' => $status]);
$results = $query->getResultArray();
return count($results);
}
function allRecords($limit,$start,$col,$dir){
$CompanyGroupNo = 3;
$status = 1;
$sql = "SELECT * FROM `tbl_pcc_product_code` WHERE `status` = :status: AND `company_group_no` = :CompanyGroupNo: LIMIT :limit:, :start: ORDER BY :col:, :dir:";
$query = $this->BaseModel->db->query($sql, [
'CompanyGroupNo' => $CompanyGroupNo,
'status' => $status,
'limit' => $limit,
'start' => $start,
'col' => $col,
'dir' => $dir
]);
$results = $query->getResultArray();
if(count($results)>0 ){
return $results;
}else{
return null;
}
}
function recordsSearch($limit,$start,$search,$col,$dir){
$CompanyGroupNo = 3;
$status = 1;
$sql = "SELECT * FROM `tbl_pcc_product_code` WHERE `status` = :status: AND `company_group_no` = :CompanyGroupNo: AND part_number LIKE CONCAT('%', :search:,'%') LIMIT :limit:, :start: ORDER BY :col:, :dir:";
$query = $this->BaseModel->db->query($sql, [
'CompanyGroupNo' => $CompanyGroupNo,
'status' => $status,
'limit' => $limit,
'start' => $start,
'col' => $col,
'dir' => $dir,
'search' => $search
]);
$results = $query->getResultArray();
if(count($results)>0 ){
return $results;
}else{
return null;
}
}
function recordsSearchCount($search){
$CompanyGroupNo = 3;
$status = 1;
$sql = "SELECT product_code_no FROM `tbl_pcc_product_code` WHERE `status` = :status: AND `company_group_no` = :CompanyGroupNo: AND part_number LIKE CONCAT('%', :search:,'%') ";
$query = $this->BaseModel->db->query($sql, [
'CompanyGroupNo' => $CompanyGroupNo,
'status' => $status,
'search' => $search
]);
$results = $query->getResultArray();
return count($results);
}