/** * GET PACKAGE ENTRY */ static function GetPackageEntries($report) { $query = 'SELECT * ' . 'FROM package_entry ' . 'WHERE fk_expense_report = :id'; $results = Database::QueryAll($query, ['id' => intval($report->getId())]); $entries = null; for ($i = 0; $i < count($results); $i++) { $entries[$i] = new PackageEntry(intval($results[$i]['id']), intval($results[$i]['quantity']), intval($results[$i]['fk_expense_report']), intval($results[$i]['fk_expense_package'])); } $report->setPackageEntries($entries); return $report; }
/** * GET EXPENSE PACKAGE */ static function GetExpensePackage() { $query = 'SELECT label, amount ' . 'FROM expense_package ' . 'ORDER BY id DESC'; $results = Database::QueryAll($query); return $results; }
/** * LIST ALL */ static function ListAll() { $query = ' SELECT id, service_number, last_name, first_name, address, zip_code, city, hiring_date FROM representative WHERE accountant=0 ORDER BY last_name '; $results = Database::QueryAll($query); $representatives = []; for ($i = 0; $i < count($results); $i++) { $results[$i]['id'] = (int) $results[$i]['id']; $results[$i]['hiring_date'] = new DateTime($results[$i]['hiring_date']); $results[$i]['hiring_date'] = $results[$i]['hiring_date']->format('Y-m-d'); $representatives[$i] = new Representative($results[$i]); } return $representatives; }
/** * GET REPORT */ static function GetReport($date, $representative_id) { $query = 'SELECT * ' . 'FROM expense_report ' . 'WHERE YEAR(report_date) = YEAR(:date) ' . 'AND MONTH(report_date) = MONTH(:date) ' . 'AND fk_representative = :id'; $results = Database::QueryAll($query, ['date' => $date, 'id' => $representative_id]); $report = new ExpenseReport(intval($results[0]['id']), $results[0]['report_date'], $results[0]['update_date'], intval($results[0]['fk_representative']), null, null, intval($results[0]['fk_report_status'])); return $report; }
/** * GET NON PACKAGE ENTRY */ static function GetNonPackageEntries($report) { $query = 'SELECT * ' . 'FROM non_package_entry ' . 'WHERE fk_expense_report = :id ' . 'ORDER by entry_date DESC'; $results = Database::QueryAll($query, ['id' => $report->getId()]); $entries = []; for ($i = 0; $i < count($results); $i++) { $entries[$i] = new NonPackageEntry($results[$i]['id'], $results[$i]['label'], $results[$i]['entry_date'], $results[$i]['amount'], $results[$i]['fk_expense_status'], $results[$i]['fk_expense_report']); } $report->setNonPackageEntries($entries); return $report; }