function getLessonsByStatUsersDate($idStatus, $idUsers, $dtStart, $dtEnd, $idCountry)
{
$country = new country();
$country->open($idCountry);
$users = "";
foreach ($idUsers as $u) {
$users .= $u . ",";
}
$users = substr($users, 0, -1);
$lesson = new lesson();
$data = array();
$i = 0;
$list_lessons = $lesson->getByStatUserDate($idStatus, $users, $dtStart, $dtEnd);
$html .= '<table id="datatables" class="table table-bordered table-striped responsive">';
$html .= ' <thead>';
$html .= ' <tr>';
$html .= ' <th class="head0">Date</th>';
$html .= ' <th class="head1">User</th>';
$html .= ' <th class="head0">Client</th>';
$html .= ' <th class="head1">Discipline</th>';
$html .= ' <th class="head0">Hours</th>';
$html .= ' <th class="head1">P. f/Hr User</th>';
$html .= ' <th class="head0">P. f/Hr Company</th>';
$html .= ' <th class="head1">Gross Value</th>';
$html .= ' <th class="head0">Discount Value</th>';
$html .= ' <th class="head1">Value to Pay</th>';
$html .= ' <th class="head0">Total Value</th>';
$html .= ' <th class="head1">Evaluation</th>';
$html .= ' </tr>';
$html .= ' </thead>';
$html .= ' <tbody>';
foreach ($list_lessons as $value) {
$i = $i + 1;
$html .= ' <tr src="lesson-report">';
$html .= ' <td>' . $value['date'] . '</td>';
$html .= ' <td>' . $value['user'] . '</td><input name="hdId" type="hidden" value="' . $value['id'] . '"/><input name="hdIdMob" type="hidden" value="' . $value['fk_mobile'] . '"/><input name="hdIdCli" type="hidden" value="' . $value['fk_client'] . '"/><input name="hdObs" type="hidden" value="' . $value['observations'] . '"/>';
$html .= ' <td><a href="#myModalClient" role="button" class="btn btn-link" data-toggle="modal" id="aClient">' . $value['client'] . '</a></td>';
$html .= ' <td>' . $value['discipline'] . '</td>';
$html .= ' <td><a href="#myModalHours" role="button" class="btn btn-link" data-toggle="modal" id="aHours">' . $value['hours'] . '</a></td>';
$html .= ' <td>(' . $country->currency . ') ' . $value['price_hour_user'] . '</td>';
$html .= ' <td>(' . $country->currency . ') ' . $value['price_hour_comp'] . '</td>';
$html .= ' <td>(' . $country->currency . ') ' . $value['value_wo_discount'] . '</td>';
$html .= ' <td>(' . $country->currency . ') ' . $value['value_discount'] . '</td>';
$html .= ' <td>(' . $country->currency . ') ' . $value['value_total_user'] . '</td>';
$html .= ' <td>(' . $country->currency . ') ' . $value['value_total_comp'] . '</td>';
if ($value['evaluation'] != '') {
$html .= ' <td><a href="#myModalEval" role="button" class="btn btn-link" data-toggle="modal" id="aEval">See</a></td>';
} elseif ($value['observations'] != '') {
$html .= ' <td><a href="#myModalObs" role="button" class="btn btn-link" data-toggle="modal" id="aObs">See</a></td>';
} else {
$html .= ' <td>Not evaluated</td>';
}
$html .= ' </tr>';
}
$html .= ' </tbody>';
$html .= '<tfoot>';
$html .= '<tr>';
$html .= '<th style="text-align:right" colspan="10">Sum of Total To Pay (' . $country->currency . '):</th>';
$html .= '<th style="text-align:center" colspan="2"></th>';
$html .= '</tr>';
$html .= '<tr>';
$html .= '<th style="text-align:right" colspan="10">Sum of Total Value (' . $country->currency . '):</th>';
$html .= '<th style="text-align:center" colspan="2"></th>';
$html .= '</tr>';
$html .= '</tfoot>';
$html .= '</table>';
$data['html'] = $html;
$data['count'] = $i;
echo json_encode($data);
}