28require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
40 public $element =
'chargesociales';
45 public $table_element =
'chargesociales';
50 public $picto =
'bill';
85 public $type_accountancy_code;
127 public $paiementtype;
132 public $mode_reglement_id;
137 public $mode_reglement_code;
142 public $mode_reglement;
167 const STATUS_UNPAID = 0;
172 const STATUS_PAID = 1;
192 public function fetch($id, $ref =
'')
194 $sql =
"SELECT cs.rowid, cs.date_ech";
195 $sql .=
", cs.libelle as label, cs.fk_type, cs.amount, cs.fk_projet as fk_project, cs.paye, cs.periode as period, cs.import_key";
196 $sql .=
", cs.fk_account, cs.fk_mode_reglement, cs.fk_user, note_public, note_private";
197 $sql .=
", c.libelle as type_label, c.code as type_code, c.accountancy_code as type_accountancy_code";
198 $sql .=
', p.code as mode_reglement_code, p.libelle as mode_reglement_libelle';
199 $sql .=
" FROM ".MAIN_DB_PREFIX.
"chargesociales as cs";
200 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_chargesociales as c ON cs.fk_type = c.id";
201 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as p ON cs.fk_mode_reglement = p.id';
202 $sql .=
' WHERE cs.entity IN ('.getEntity(
'tax').
')';
204 $sql .=
" AND cs.ref = '".$this->db->escape($ref).
"'";
206 $sql .=
" AND cs.rowid = ".((int) $id);
209 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
210 $resql = $this->db->query($sql);
212 if ($this->db->num_rows($resql)) {
213 $obj = $this->db->fetch_object($resql);
215 $this->
id = $obj->rowid;
216 $this->
ref = $obj->rowid;
217 $this->date_ech = $this->db->jdate($obj->date_ech);
218 $this->lib = $obj->label;
219 $this->label = $obj->label;
220 $this->
type = $obj->fk_type;
221 $this->type_label = $obj->type_label;
222 $this->type_code = $obj->type_code;
223 $this->type_accountancy_code = $obj->type_accountancy_code;
224 $this->fk_account = $obj->fk_account;
225 $this->mode_reglement_id = $obj->fk_mode_reglement;
226 $this->mode_reglement_code = $obj->mode_reglement_code;
227 $this->mode_reglement = $obj->mode_reglement_libelle;
228 $this->
amount = $obj->amount;
229 $this->fk_project = $obj->fk_project;
230 $this->fk_user = $obj->fk_user;
231 $this->note_public = $obj->note_public;
232 $this->note_private = $obj->note_private;
233 $this->paye = $obj->paye;
234 $this->periode = $this->db->jdate($obj->period);
235 $this->period = $this->db->jdate($obj->period);
236 $this->import_key = $obj->import_key;
238 $this->db->free($resql);
245 $this->error = $this->db->lasterror();
260 if ($newamount == 0 || empty($this->date_ech) || (empty($this->period) && empty($this->periode))) {
283 if (!$this->
check()) {
284 $this->error =
"ErrorBadParameter";
290 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"chargesociales (fk_type, fk_account, fk_mode_reglement, libelle, date_ech, periode, amount, fk_projet, entity, fk_user_author, fk_user, date_creation)";
291 $sql .=
" VALUES (".((int) $this->
type);
292 $sql .=
", ".($this->fk_account > 0 ? ((int) $this->fk_account) :
'NULL');
293 $sql .=
", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
"NULL");
294 $sql .=
", '".$this->db->escape($this->label ? $this->label : $this->lib).
"'";
295 $sql .=
", '".$this->db->idate($this->date_ech).
"'";
296 $sql .=
", '".$this->db->idate($this->period).
"'";
297 $sql .=
", '".price2num($newamount).
"'";
298 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
'NULL');
299 $sql .=
", ".((int)
$conf->entity);
300 $sql .=
", ".((int) $user->id);
301 $sql .=
", ".($this->fk_user > 0 ? ((int) $this->fk_user) :
'NULL');
302 $sql .=
", '".$this->db->idate($now).
"'";
305 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
306 $resql = $this->db->query($sql);
308 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"chargesociales");
311 $result = $this->call_trigger(
'SOCIALCONTRIBUTION_CREATE', $user);
320 $this->db->rollback();
324 $this->error = $this->db->error();
325 $this->db->rollback();
341 if ($totalpaid < 0) {
344 return (empty($totalpaid) ? 1 : 0);
354 public function delete($user, $notrigger = 0)
359 $this->error =
'ErrorRecordHasChildren';
366 include_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
367 $account =
new Account($this->db);
368 $lines_url = $account->get_url(0, $this->
id,
'sc');
371 foreach ($lines_url as $line_url) {
374 $accountline->fetch($line_url[
'fk_bank']);
375 $result = $accountline->delete_urls($user);
384 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"paiementcharge WHERE fk_charge=".((int) $this->
id);
385 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
386 $resql = $this->db->query($sql);
389 $this->error = $this->db->lasterror();
394 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"chargesociales WHERE rowid=".((int) $this->
id);
395 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
396 $resql = $this->db->query($sql);
399 $this->error = $this->db->lasterror();
403 if (!$error && !$notrigger) {
405 $result = $this->call_trigger(
'SOCIALCONTRIBUTION_DELETE', $user);
416 $this->db->rollback();
429 public function update($user, $notrigger = 0)
434 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"chargesociales";
435 $sql .=
" SET libelle = '".$this->db->escape($this->label ? $this->label : $this->lib).
"'";
436 $sql .=
", date_ech = '".$this->db->idate($this->date_ech).
"'";
437 $sql .=
", periode = '".$this->db->idate($this->period ? $this->period : $this->periode).
"'";
439 $sql .=
", fk_projet=".($this->fk_project > 0 ? ((int) $this->fk_project) :
"NULL");
440 $sql .=
", fk_user=".($this->fk_user > 0 ? ((int) $this->fk_user) :
"NULL");
441 $sql .=
", fk_user_modif=".((int) $user->id);
442 if ($this->
type > 0) {
443 $sql .=
", fk_type = ".((int) $this->
type);
445 $sql .=
" WHERE rowid=".((int) $this->
id);
447 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
448 $resql = $this->db->query($sql);
452 $this->errors[] =
"Error ".$this->db->lasterror();
458 $result = $this->call_trigger(
'SOCIALCONTRIBUTION_MODIFY', $user);
468 foreach ($this->errors as $errmsg) {
469 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
470 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
472 $this->db->rollback();
490 $sql =
"SELECT SUM(f.amount) as amount";
491 $sql .=
" FROM ".MAIN_DB_PREFIX.
"chargesociales as f";
492 $sql .=
" WHERE f.entity = ".((int)
$conf->entity);
493 $sql .=
" AND paye = 0";
496 $sql .=
" AND f.datev >= '".((int) $year).
"-01-01' AND f.datev <= '".((int) $year).
"-12-31' ";
499 $result = $this->db->query($sql);
501 if ($this->db->num_rows($result)) {
502 $obj = $this->db->fetch_object($result);
503 $this->db->free($result);
509 print $this->db->error();
526 dol_syslog(get_class($this).
"::set_paid is deprecated, use setPaid instead", LOG_NOTICE);
538 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"chargesociales SET";
540 $sql .=
" WHERE rowid = ".((int) $this->
id);
542 $return = $this->db->query($sql);
565 dol_syslog(get_class($this).
"::set_unpaid is deprecated, use setUnpaid instead", LOG_NOTICE);
577 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"chargesociales SET";
579 $sql .=
" WHERE rowid = ".((int) $this->
id);
581 $return = $this->db->query($sql);
601 return $this->
LibStatut($this->paye, $mode, $alreadypaid);
613 public function LibStatut($status, $mode = 0, $alreadypaid = -1)
619 $langs->loadLangs(array(
"customers",
"bills"));
622 $this->labelStatus = array();
623 $this->labelStatusShort = array();
625 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
628 $this->labelStatus[self::STATUS_UNPAID] = $langs->transnoentitiesnoconv(
'Unpaid');
629 $this->labelStatus[self::STATUS_PAID] = $langs->transnoentitiesnoconv(
'Paid');
630 if ($status == self::STATUS_UNPAID && $alreadypaid > 0) {
631 $this->labelStatus[self::STATUS_UNPAID] = $langs->transnoentitiesnoconv(
"BillStatusStarted");
633 $this->labelStatusShort[self::STATUS_UNPAID] = $langs->transnoentitiesnoconv(
'Unpaid');
634 $this->labelStatusShort[self::STATUS_PAID] = $langs->transnoentitiesnoconv(
'Paid');
635 if ($status == self::STATUS_UNPAID && $alreadypaid > 0) {
636 $this->labelStatusShort[self::STATUS_UNPAID] = $langs->transnoentitiesnoconv(
"BillStatusStarted");
640 $statusType =
'status1';
641 if ($status == 0 && $alreadypaid > 0) {
642 $statusType =
'status3';
645 $statusType =
'status6';
648 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
663 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $short = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
665 global $langs,
$conf, $user, $hookmanager;
667 if (!empty(
$conf->dol_no_mouse_hover)) {
673 $url = DOL_URL_ROOT.
'/compta/sociales/card.php?id='.$this->id;
679 if ($option !==
'nolink') {
681 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
682 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
683 $add_save_lastsearch_values = 1;
685 if ($add_save_lastsearch_values) {
686 $url .=
'&save_lastsearch_values=1';
690 if (empty($this->
ref)) {
691 $this->
ref = $this->label;
694 $label = img_picto(
'', $this->picto,
'class="pictofixedwidth"').
'<u class="paddingrightonly">'.$langs->trans(
"SocialContribution").
'</u>';
695 if (isset($this->paye)) {
696 $label .=
' '.$this->getLibStatut(5);
698 if (!empty($this->
id)) {
699 $label .=
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->id;
701 if (!empty($this->label)) {
702 $label .=
'<br><b>'.$langs->trans(
'Label').
':</b> '.$this->label;
704 if (!empty($this->type_label)) {
705 $label .=
'<br><b>'.$langs->trans(
'Type').
':</b> '.$this->type_label;
706 if (
isModEnabled(
'accounting') || !empty($this->type_accountancy_code)) {
707 include_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
708 $label .=
' <span class="opacitymedium">('.$langs->trans(
'AccountancyCode').
': '.(empty($this->type_accountancy_code) ? $langs->trans(
"Unknown") :
length_accountg($this->type_accountancy_code)).
')</span>';
713 if (empty($notooltip) && $user->hasRight(
"facture",
"read")) {
715 $label = $langs->trans(
"SocialContribution");
716 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
718 $linkclose .=
' title="'.dolPrintHTMLForAttribute($label).
'"';
719 $linkclose .=
' class="classfortooltip"';
722 $linkstart =
'<a href="'.$url.
'"';
723 $linkstart .= $linkclose.
'>';
726 $result .= $linkstart;
728 $result .= img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
730 if ($withpicto != 2) {
731 $result .= $this->ref;
735 if ($addlinktonotes) {
736 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
738 $notetoshow = $langs->trans(
"ViewPrivateNote").
':<br>'.$txttoshow;
739 $result .=
' <span class="note inline-block">';
740 $result .=
'<a href="'.DOL_URL_ROOT.
'/compta/sociales/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.dolPrintHTMLForAttribute($notetoshow).
'">';
741 $result .= img_picto(
'',
'note');
743 $result .=
'</span>';
748 $hookmanager->initHooks(array($this->element .
'dao'));
749 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
750 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
752 $result = $hookmanager->resPrint;
754 $result .= $hookmanager->resPrint;
767 $sql =
'SELECT sum(amount) as amount';
768 $sql .=
' FROM '.MAIN_DB_PREFIX.
'paiementcharge';
769 $sql .=
" WHERE fk_charge = ".((int) $this->
id);
771 dol_syslog(get_class($this).
"::getSommePaiement", LOG_DEBUG);
772 $resql = $this->db->query($sql);
776 $obj = $this->db->fetch_object($resql);
778 $amount = $obj->amount ? $obj->amount : 0;
781 $this->db->free($resql);
796 $sql =
"SELECT e.rowid, e.tms as datem, e.date_creation as datec, e.date_valid as datev, e.import_key,";
797 $sql .=
" e.fk_user_author, e.fk_user_modif, e.fk_user_valid";
798 $sql .=
" FROM ".MAIN_DB_PREFIX.
"chargesociales as e";
799 $sql .=
" WHERE e.rowid = ".((int) $id);
801 dol_syslog(get_class($this).
"::info", LOG_DEBUG);
802 $result = $this->db->query($sql);
804 if ($this->db->num_rows($result)) {
805 $obj = $this->db->fetch_object($result);
807 $this->
id = $obj->rowid;
809 $this->user_creation_id = $obj->fk_user_author;
810 $this->user_modification_id = $obj->fk_user_modif;
811 $this->user_validation_id = $obj->fk_user_valid;
812 $this->date_creation = $this->db->jdate($obj->datec);
813 $this->date_modification = $this->db->jdate($obj->datem);
814 $this->date_validation = $this->db->jdate($obj->datev);
815 $this->import_key = $obj->import_key;
818 $this->db->free($result);
821 dol_print_error($this->db);
837 $this->
ref =
'SPECIMEN';
840 $this->date_creation =
dol_now();
841 $this->date_ech = $this->date_creation + 3600 * 24 * 30;
842 $this->periode = $this->date_creation + 3600 * 24 * 30;
843 $this->period = $this->date_creation + 3600 * 24 * 30;
845 $this->label =
'Social contribution label';
847 $this->type_label =
'Type of social contribution';
861 global
$conf, $langs;
863 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
865 $return =
'<div class="box-flex-item box-flex-grow-zero">';
866 $return .=
'<div class="info-box info-box-sm">';
867 $return .=
'<span class="info-box-icon bg-infobox-action">';
868 $return .= img_picto(
'', $this->picto);
869 $return .=
'</span>';
870 $return .=
'<div class="info-box-content">';
871 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl(0) : $this->ref).
'</span>';
872 if ($selected >= 0) {
873 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
875 if (property_exists($this,
'label')) {
876 $return .=
' <div class="inline-block opacitymedium valignmiddle tdoverflowmax100">'.$this->label.
'</div>';
878 if (!empty($arraydata[
'project']) && $arraydata[
'project'] instanceof
Project && $arraydata[
'project']->
id > 0) {
879 $return .=
'<br><span class="info-box-label">'.$arraydata[
'project']->getNomUrl(1).
'</span>';
881 if (property_exists($this,
'date_ech')) {
882 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"Date").
'</span> : <span class="info-box-label">'.
dol_print_date($this->date_ech,
'day').
'</span>';
884 if (property_exists($this,
'amount')) {
886 $return .=
'<span class="info-box-label amount">'.price($this->
amount, 0, $langs, 1, -1, -1,
$conf->currency).
'</span>';
888 if (method_exists($this,
'LibStatut')) {
889 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3, (
float) $this->totalpaid).
'</div>';
length_accountg($account)
Return General accounting account with defined length (used for product and miscellaneous)
$propal type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
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.
is_erasable()
Return if a social contribution can be deleted: not once a payment exists, as for invoices.
LibStatut($status, $mode=0, $alreadypaid=-1)
Renvoi le libelle d'un statut donne.
__construct(DoliDB $db)
Constructor.
setUnpaid($user)
Remove tag paid on social contribution.
initAsSpecimen()
Initialise an instance with random values.
check()
Check if a social contribution can be created into database.
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
getSommePaiement()
Return amount of payments already done.
solde($year=0)
Calculate amount remaining to pay by year.
fetch($id, $ref='')
Retrouve et charge une charge sociale.
getNomUrl($withpicto=0, $option='', $notooltip=0, $short=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return a link to the object card (with optionally the picto)
update($user, $notrigger=0)
Update social or fiscal contribution.
set_unpaid($user)
Remove tag paid on social contribution.
set_paid($user)
Tag social contribution as paid completely.
info($id)
Charge l'information d'ordre info dans l'objet entrepot.
create($user)
Create a social contribution into database.
getLibStatut($mode=0, $alreadypaid=-1)
Retourne le libelle du statut d'une charge (impaye, payee)
setPaid($user)
Tag social contribution as paid completely.
Class to manage Dolibarr database access.
Class to manage projects.
dol_now($mode='gmt')
Return date for now.
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as p p num_paiement as f pf amount as amount