예제 #1
0
 public static function GetClientNotes($clientid)
 {
     try {
         $client = Client::GetClient($clientid);
         $sql = 'SELECT * FROM credit_notes WHERE client_id = ' . $clientid . ' AND status = 1';
         $res = DatabaseHandler::GetAll($sql);
         $invoices = [];
         foreach ($res as $item) {
             if (!empty($item['datetime'])) {
                 $invoice = new CreditNote($item['id'], $item['description'], $item['datetime'], $item['status'], $client);
                 $invoice->initialize();
                 $invoices[] = $invoice;
             } else {
             }
         }
         return $invoices;
     } catch (Exception $e) {
         return null;
     }
 }