function getApprLessByIdMonth($idUser, $month) { $query = $this->con->genericQuery("select l._id,fk_mobile, l.fk_client, DATE_FORMAT( l.date, '%d/%m/%Y' ) as date, c.name as client, d.description as discipline, l.hours, l.currency, l.value_wo_discount, l.value_discount, l.value_total_user from " . $this->table . " l inner join disciplines d on l.fk_discipline = d._id inner join clients c on l.fk_client = c._id where fk_user = "******" and MONTH(date)='" . $month . "' and fk_less_stat = 2"); $objReturn = array(); foreach ($query as $value) { $less = new lesson(); $less->open($value); $objReturn[] = $less; } return $objReturn; }