<?php require_once "../config.php"; if (!$_GET['id']) { die; } $pay = new payment(); $pay->open($_GET['id']); $country = new country(); $country->open($company->fk_country); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <link rel="shortcut icon" href="../img/icon.png"> <title>Invoice #<?php echo $pay->sequence; ?> | FOLearn</title> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta name="description" content="" /> <meta name="author" content="stilearning" /> <!-- google font --> <link href="http://fonts.googleapis.com/css?family=Aclonica:regular" rel="stylesheet" type="text/css" /> <!-- styles --> <link href="../css/bootstrap.css" rel="stylesheet" /> <link href="../css/bootstrap-responsive.css" rel="stylesheet" /> <link href="../css/stilearn.css" rel="stylesheet" />
function getByDate($fk_company, $dtIni, $dtEnd) { $query = $this->con->genericQuery("select * from " . $this->table . " where fk_company = {$fk_company} and (date_start between STR_TO_DATE('" . $dtIni . "','%m-%Y') and STR_TO_DATE('" . $dtEnd . "','%m-%Y')) order by date_start"); $objReturn = array(); foreach ($query as $value) { $py = new payment(); $py->open($value); $objReturn[] = $py; } return $objReturn; }