// List of fields to search into when doing a "search in all"
$fieldstosearchall = array('cp.rowid' => 'Ref', 'cp.description' => 'Description');
/*
* Actions
*/
// None
/*
* View
*/
$holiday = new Holiday($db);
$holidaystatic = new Holiday($db);
$fuser = new User($db);
$childids = $user->getAllChildIds();
$childids[] = $user->id;
// Update sold
$result = $holiday->updateBalance();
$max_year = 5;
$min_year = 10;
$filter = '';
llxHeader(array(), $langs->trans('CPTitreMenu'));
$order = $db->order($sortfield, $sortorder) . $db->plimit($limit + 1, $offset);
// WHERE
if (!empty($search_ref)) {
$filter .= " AND cp.rowid LIKE '%" . $db->escape($search_ref) . "%'\n";
}
// DATE START
if ($year_start > 0) {
if ($month_start > 0) {
$filter .= " AND (cp.date_debut BETWEEN '" . $db->idate(dol_get_first_day($year_start, $month_start, 1)) . "' AND '" . $db->idate(dol_get_last_day($year_start, $month_start, 1)) . "')";
//$filter.= " AND date_format(cp.date_debut, '%Y-%m') = '$year_start-$month_start'";
} else {
