- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
public static function ShowClaimsByManager($manager_id,$status,$offset_limit,$rows_limit){
$DBH = Registry::get('DBH');
$STH = $DBH ->prepare(
"SELECT * FROM claims,claims_status
WHERE claims.manager_id = :manager_id
AND claims.id = claims_status.claim_id
AND claims_status.status = :statusc
LIMIT :offsetl, :rowsl" );
$STH->bindParam(':manager_id', $manager_id, PDO::PARAM_STR);
$STH->bindParam(':statusc', $status, PDO::PARAM_STR);
$STH->bindParam(':offsetl', $offset_limit, PDO::PARAM_INT);
$STH->bindParam(':rowsl', $rows_limit, PDO::PARAM_INT);
$STH->execute();
$result = $STH->fetchAll(PDO::FETCH_ASSOC);
return $result;
}