- 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;
    }