function list_countries()
{
$query = $this->con->genericQuery("select * from " . $this->table . " order by name");
$objReturn = array();
foreach ($query as $value) {
$country = new country();
$country->open($value);
$objReturn[] = $country;
}
return $objReturn;
}
<?php
require_once "../config.php";
$discAdd = false;
$discUpd = false;
$discDel = false;
if (!$_GET['user']) {
die;
} else {
$idUser = $_GET['user'];
}
$country = new country();
$country->open($company->fk_country);
$newUser = new user();
$newUser->open($idUser);
if ($_POST['action'] == 'Save') {
if (isset($_POST['hdId'])) {
$newUser->saveDiscplines($_POST['hdId'], $_POST['discPrices']);
$discUpd = true;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<link rel="shortcut icon" href="../img/icon.png">
<title>Disciplines | FOLearn</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta name="description" content="" />
function showInvoices($fk_company, $dtStart, $dtEnd, $idCountry)
{
$country = new country();
$country->open($idCountry);
$pay = new payment();
$data = array();
$i = 0;
$list_invoices = $pay->getByDate($fk_company, $dtStart, $dtEnd);
$html .= '<table id="datatables" class="table table-bordered table-striped responsive">';
$html .= ' <thead>';
$html .= ' <tr>';
$html .= ' <th class="head0">#</th>';
$html .= ' <th class="head1">Date Start</th>';
$html .= ' <th class="head0">Date End</th>';
$html .= ' <th class="head1">Lessons</th>';
$html .= ' <th class="head0">Invoice</th>';
$html .= ' <th class="head1">Actions</th>';
$html .= ' </tr>';
$html .= ' </thead>';
$html .= ' <tbody>';
foreach ($list_invoices as $value) {
$i = $i + 1;
$html .= ' <tr src="stays">';
$html .= ' <td>' . $value->sequence . '</td>';
$html .= ' <td>' . date('Y-m-d', strtotime($value->date_start)) . '</td>';
$html .= ' <td>' . date('Y-m-d', strtotime($value->date_end)) . '</td>';
$html .= ' <td>' . $value->lessons . '</td>';
$html .= ' <td>(' . $country->currency . ') ' . $value->invoice . '</td>';
$html .= ' <td><a href="/pages/invoice-detail.php?id=' . $value->id . '" role="button" class="btn btn-link">View</a></td>';
$html .= ' </tr>';
}
$html .= ' </tbody>';
$html .= '</table>';
$data['html'] = $html;
$data['count'] = $i;
echo json_encode($data);
}
