34require
'../../main.inc.php';
43require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/paymentsocialcontribution.class.php';
47require_once DOL_DOCUMENT_ROOT.
'/salaries/class/salary.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
49require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
50require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formsocialcontrib.class.php';
52 include_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
56$langs->loadLangs(array(
'compta',
'bills',
'hrm'));
59$hookmanager->initHooks(array(
'specialexpensesindex'));
63$search_sc_type =
GETPOST(
'search_sc_type',
'intcomma');
64$optioncss =
GETPOST(
'optioncss',
'alpha');
67$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
68$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
70if (empty($page) || $page < 0) {
73$offset = $limit * $page;
77 $sortfield =
"cs.date_ech";
85 $socid = $user->socid;
87$result =
restrictedArea($user,
'tax',
'',
'chargesociales',
'charges');
95if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
106$tva_static =
new Tva($db);
109$userstatic =
new User($db);
110$sal_static =
new Salary($db);
111$accountstatic =
new Account($db);
115$title = $langs->trans(
"SocialContributionsPayments");
122if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
123 $param .=
'&contextpage='.urlencode($contextpage);
125if ($limit > 0 && $limit !=
$conf->liste_limit) {
126 $param .=
'&limit='.((int) $limit);
129 $param .=
'&sortfield='.urlencode($sortfield);
132 $param .=
'&sortorder='.urlencode($sortorder);
135 $param .=
'&year='.urlencode((
string) ($year));
137if ($search_sc_type) {
138 $param .=
'&search_sc_type='.urlencode((
string) ($search_sc_type));
140if ($optioncss !=
'') {
141 $param .=
'&optioncss='.urlencode($optioncss);
145print
'<form method="POST" action="'.dolBuildUrl($_SERVER[
"PHP_SELF"]).
'">';
146if ($optioncss !=
'') {
147 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
149print
'<input type="hidden" name="token" value="'.newToken().
'">';
150print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
151print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
152print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
153print
'<input type="hidden" name="page" value="'.$page.
'">';
155$sql =
"SELECT c.id, c.libelle as type_label,";
156$sql .=
" cs.rowid, cs.libelle as label_sc, cs.fk_type as type, cs.periode as period, cs.date_ech, cs.amount as total, cs.paye,";
157$sql .=
" pc.rowid as pid, pc.datep, pc.amount as totalpaid, pc.num_paiement as num_payment, pc.fk_bank,";
158$sql .=
" pct.code as payment_code,";
159$sql .=
" u.rowid as uid, u.lastname, u.firstname, u.email, u.login, u.admin, u.statut,";
160$sql .=
" ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos,";
161$sql .=
" aj.label as account_journal";
162$sql .=
" FROM ".MAIN_DB_PREFIX.
"c_chargesociales as c,";
163$sql .=
" ".MAIN_DB_PREFIX.
"chargesociales as cs";
164$sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"paiementcharge as pc ON pc.fk_charge = cs.rowid";
165$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as pct ON pc.fk_typepaiement = pct.id";
166$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank as b ON pc.fk_bank = b.rowid";
167$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank_account as ba ON b.fk_account = ba.rowid";
168$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"accounting_journal as aj ON ba.fk_accountancy_journal = aj.rowid";
169$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u ON u.rowid = cs.fk_user";
170$sql .=
" WHERE cs.fk_type = c.id";
171$sql .=
" AND cs.entity IN (".getEntity(
"tax").
")";
172if ($search_sc_type > 0) {
173 $sql .=
" AND cs.fk_type = ".((int) $search_sc_type);
183if ($sortfield && preg_match(
'/^(cs|c|pc|pct|u|ba)\./', $sortfield)) {
184 $sql .= $db->order($sortfield, (
string) $sortorder);
188$nbtotalofrecords =
'';
191 $resql = $db->query($sql);
192 $nbtotalofrecords = $db->num_rows($resql);
193 if (($page * $limit) > (int) $nbtotalofrecords) {
199if (is_numeric($nbtotalofrecords) && ($limit > $nbtotalofrecords || empty($limit))) {
200 $num = $nbtotalofrecords;
203 $sql .= $db->plimit($limit + 1, $offset);
206 $resql = $db->query($sql);
208 dol_print_error($db);
212 $num = $db->num_rows($resql);
218print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder,
'', $num, $nbtotalofrecords,
'object_payment', 0, $nav,
'', $limit, 0);
220print
'<table class="noborder centpercent">';
222print
'<tr class="liste_titre">';
223print
'<td class="liste_titre"></td>';
224print
'<td class="liste_titre"></td>';
225print
'<td class="liste_titre">';
226$formsocialcontrib->select_type_socialcontrib(
GETPOSTISSET(
"search_sc_type") ? (
int) $search_sc_type : 0,
'search_sc_type', 1, 0, 0,
'minwidth200 maxwidth300');
228print
'<td class="liste_titre"></td>';
229print
'<td class="liste_titre"></td>';
230print
'<td class="liste_titre"></td>';
231print
'<td class="liste_titre"></td>';
232print
'<td class="liste_titre"></td>';
233print
'<td class="liste_titre"></td>';
235 print
'<td class="liste_titre"></td>';
236 print
'<td class="liste_titre"></td>';
238print
'<td class="liste_titre"></td>';
239print
'<td class="liste_titre center">';
240$searchpicto = $form->showFilterButtons();
245print
'<tr class="liste_titre">';
246print_liste_field_titre(
"RefPayment", $_SERVER[
"PHP_SELF"],
"pc.rowid",
"", $param,
'', $sortfield, $sortorder);
247print_liste_field_titre(
"SocialContribution", $_SERVER[
"PHP_SELF"],
"c.libelle",
"", $param,
'', $sortfield, $sortorder);
248print_liste_field_titre(
"TypeContrib", $_SERVER[
"PHP_SELF"],
"cs.fk_type",
"", $param,
'', $sortfield, $sortorder);
249print_liste_field_titre(
"PeriodEndDate", $_SERVER[
"PHP_SELF"],
"cs.periode",
"", $param,
'', $sortfield, $sortorder,
'center ');
250print_liste_field_titre(
"DatePayment", $_SERVER[
"PHP_SELF"],
"pc.datep",
"", $param,
'', $sortfield, $sortorder,
'center ');
252print_liste_field_titre(
"PaymentMode", $_SERVER[
"PHP_SELF"],
"pct.code",
"", $param,
'', $sortfield, $sortorder);
253print_liste_field_titre(
"Numero", $_SERVER[
"PHP_SELF"],
"pc.num_paiement",
"", $param,
'', $sortfield, $sortorder,
'',
'ChequeOrTransferNumber');
255 print_liste_field_titre(
"BankTransactionLine", $_SERVER[
"PHP_SELF"],
"pc.fk_bank",
"", $param,
'', $sortfield, $sortorder);
256 print_liste_field_titre(
"BankAccount", $_SERVER[
"PHP_SELF"],
"ba.label",
"", $param,
"", $sortfield, $sortorder);
258print_liste_field_titre(
"ExpectedToPay", $_SERVER[
"PHP_SELF"],
"cs.amount",
"", $param,
'class="right"', $sortfield, $sortorder);
259print_liste_field_titre(
"PayedByThisPayment", $_SERVER[
"PHP_SELF"],
"pc.amount",
"", $param,
'class="right"', $sortfield, $sortorder);
264 dol_print_error($db);
273while ($i < min($num, $limit)) {
274 $obj = $db->fetch_object($resql);
276 $payment_sc_static->id = $obj->pid;
277 $payment_sc_static->ref = $obj->pid;
278 $payment_sc_static->datep = $db->jdate($obj->datep);
280 $socialcontrib->id = $obj->rowid;
281 $socialcontrib->ref = empty($obj->label_sc) ? $obj->type_label : $obj->label_sc;
282 $socialcontrib->paye = $obj->paye;
285 $socialcontrib->label = empty($obj->label_sc) ? $obj->type_label : $obj->label_sc;
286 $socialcontrib->type_label = $obj->type_label;
288 print
'<tr class="oddeven">';
290 print
'<td class="nowraponall">'.$payment_sc_static->getNomUrl(1).
"</td>\n";
292 print
'<td class="tdoverflowmax250">';
293 print $socialcontrib->getNomUrl(1,
'');
296 print
'<td title="'.dolPrintHTMLForAttribute($obj->type_label).
'" class="tdoverflowmax300">'.dolPrintHTML($obj->type_label).
'</td>';
298 $date = $obj->period;
300 $date = $obj->date_ech;
302 print
'<td class="center">'.dol_print_date($date,
'day').
'</td>';
304 print
'<td class="center">'.dol_print_date($db->jdate($obj->datep),
'day').
'</td>';
308 if (!empty($obj->uid)) {
309 $userstatic->id = $obj->uid;
310 $userstatic->lastname = $obj->lastname;
311 $userstatic->firstname = $obj->firstname;
312 $userstatic->admin = $obj->admin;
313 $userstatic->login = $obj->login;
314 $userstatic->email = $obj->email;
315 $userstatic->status = $obj->statut;
316 print $userstatic->getNomUrl(1);
322 if ($obj->payment_code) {
323 $labelpayment = $langs->trans(
"PaymentTypeShort".$obj->payment_code);
325 print
'<td class="tdoverflowmax150" title="'.$labelpayment.
'">';
329 print
'<td>'.$obj->num_payment.
'</td>';
334 print
'<td class="nowraponall">';
335 $accountlinestatic->id = $obj->fk_bank;
336 print $accountlinestatic->getNomUrl(1);
339 print
'<td class="nowraponall">';
341 $accountstatic->id = $obj->bid;
342 $accountstatic->ref = $obj->bref;
343 $accountstatic->number = $obj->bnumber;
344 $accountstatic->label = $obj->blabel;
345 $accountstatic->iban = $obj->iban;
346 $accountstatic->bic = $obj->bic;
347 $accountstatic->currency_code = $langs->trans(
"Currency".$obj->currency_code);
348 $accountstatic->clos = $obj->clos;
351 $accountstatic->account_number = $obj->account_number;
352 $accountstatic->accountancy_journal = $obj->account_journal;
354 print $accountstatic->getNomUrl(1);
362 print
'<td class="right"><span class="amount">'.price($obj->total).
'</span></td>';
365 print
'<td class="right">';
366 if ($obj->totalpaid) {
367 print
'<span class="amount">'.price($obj->totalpaid).
'</span>';
375 $total += $obj->total;
376 $totalpaid += $obj->totalpaid;
381print
'<tr class="liste_total"><td colspan="3" class="liste_total">'.$langs->trans(
"Total").
'</td>';
382print
'<td class="liste_total right"></td>';
383print
'<td align="center" class="liste_total"> </td>';
384print
'<td align="center" class="liste_total"> </td>';
385print
'<td align="center" class="liste_total"> </td>';
386print
'<td align="center" class="liste_total"> </td>';
387print
'<td align="center" class="liste_total"> </td>';
392print
'<td class="liste_total right">'.price($totalpaid).
"</td>";
401$parameters = array(
'user' => $user);
402$reshook = $hookmanager->executeHooks(
'dashboardSpecialBills', $parameters,
$object);
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage bank accounts.
Class to manage bank transaction lines.
Class for managing the social charges.
Class to manage payments of social contributions.
Class to manage salary payments.
Class to manage VAT - Value-added tax (also known in French as TVA)
Class to manage Dolibarr users.
dol_get_first_day($year, $month=1, $gm=false)
Return GMT time for first day of a month or year.
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isModEnabled($module)
Is Dolibarr module enabled.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.