29require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
40 public $element =
'subscription';
45 public $table_element =
'subscription';
50 public $picto =
'payment';
103 public $fields = array(
104 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
105 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 15),
106 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'position' => 20),
107 'fk_adherent' => array(
'type' =>
'integer',
'label' =>
'Member',
'enabled' => 1,
'visible' => -1,
'position' => 25),
108 'dateadh' => array(
'type' =>
'datetime',
'label' =>
'DateSubscription',
'enabled' => 1,
'visible' => -1,
'position' => 30),
109 'datef' => array(
'type' =>
'datetime',
'label' =>
'DateEndSubscription',
'enabled' => 1,
'visible' => -1,
'position' => 35),
110 'subscription' => array(
'type' =>
'double(24,8)',
'label' =>
'Amount',
'enabled' => 1,
'visible' => -1,
'position' => 40,
'isameasure' => 1),
111 'fk_bank' => array(
'type' =>
'integer',
'label' =>
'BankId',
'enabled' => 1,
'visible' => -1,
'position' => 45),
112 'note' => array(
'type' =>
'html',
'label' =>
'Note',
'enabled' => 1,
'visible' => -1,
'position' => 50),
113 'fk_type' => array(
'type' =>
'integer',
'label' =>
'MemberType',
'enabled' => 1,
'visible' => -1,
'position' => 55),
114 'fk_user_creat' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -2,
'position' => 60),
115 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => -1,
'position' => 65),
128 $this->ismultientitymanaged =
'fk_adherent@adherent';
139 public function create($user, $notrigger = 0)
148 if ($this->datef <= $this->dateh) {
149 $this->error = $langs->trans(
"ErrorBadValueForDate");
152 if (empty($this->datec)) {
158 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"subscription (fk_adherent, fk_type, datec, dateadh, datef, subscription, note)";
160 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
162 $result = $member->fetch($this->fk_adherent);
164 if ($this->fk_type ==
null) {
165 $type = $member->typeid;
167 $type = $this->fk_type;
169 $sql .=
" VALUES (".((int) $this->fk_adherent).
", '".$this->db->escape($type).
"', '".$this->db->idate($now).
"',";
170 $sql .=
" '".$this->db->idate($this->dateh).
"',";
171 $sql .=
" '".$this->db->idate($this->datef).
"',";
172 $sql .=
" ".((float) $this->amount).
",";
173 $sql .=
" '".$this->db->escape($this->note_public ? $this->note_public : $this->note).
"')";
175 $resql = $this->db->query($sql);
178 $this->errors[] = $this->db->lasterror();
182 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.$this->table_element);
183 $this->fk_type = $type;
186 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
187 $this->linked_objects = $this->linkedObjectsIds;
191 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
192 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
193 if (is_array($tmp_origin_id)) {
194 foreach ($tmp_origin_id as $origin_id) {
197 $this->error = $this->db->lasterror();
202 $origin_id = $tmp_origin_id;
205 $this->error = $this->db->lasterror();
212 if (!$error && !$notrigger) {
213 $this->context = array(
'member' => $member);
215 $result = $this->
call_trigger(
'MEMBER_SUBSCRIPTION_CREATE', $user);
224 $this->db->rollback();
241 $sql =
"SELECT rowid, fk_type, fk_adherent, datec,";
243 $sql .=
" dateadh as dateh,";
245 $sql .=
" subscription, note as note_public, fk_bank";
246 $sql .=
" FROM ".MAIN_DB_PREFIX.
"subscription";
247 $sql .=
" WHERE rowid = ".((int) $rowid);
249 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
250 $resql = $this->db->query($sql);
252 if ($this->db->num_rows($resql)) {
253 $obj = $this->db->fetch_object($resql);
255 $this->
id = $obj->rowid;
256 $this->
ref = $obj->rowid;
258 $this->fk_type = $obj->fk_type;
259 $this->fk_adherent = $obj->fk_adherent;
260 $this->datec = $this->db->jdate($obj->datec);
261 $this->datem = $this->db->jdate($obj->tms);
262 $this->dateh = $this->db->jdate($obj->dateh);
263 $this->datef = $this->db->jdate($obj->datef);
264 $this->amount = $obj->subscription;
265 $this->note = $obj->note_public;
266 $this->note_public = $obj->note_public;
267 $this->fk_bank = $obj->fk_bank;
273 $this->error = $this->db->lasterror();
286 public function update($user, $notrigger = 0)
292 if (!is_numeric($this->amount)) {
293 $this->error =
'BadValueForParameterAmount';
297 if (empty($this->note_public) && !empty($this->note)) {
298 $this->note_public = $this->note;
301 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"subscription SET ";
302 $sql .=
" fk_type = ".((int) $this->fk_type).
",";
303 $sql .=
" fk_adherent = ".((int) $this->fk_adherent).
",";
304 $sql .=
" note = ".($this->note_public ?
"'".$this->db->escape($this->note_public).
"'" :
'null').
",";
305 $sql .=
" subscription = ".(float)
price2num($this->amount).
",";
306 $sql .=
" dateadh = '".$this->db->idate($this->dateh).
"',";
307 $sql .=
" datef = '".$this->db->idate($this->datef).
"',";
308 $sql .=
" datec = '".$this->db->idate($this->datec).
"',";
309 $sql .=
" fk_bank = ".($this->fk_bank ? ((int) $this->fk_bank) :
'null');
310 $sql .=
" WHERE rowid = ".((int) $this->
id);
312 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
313 $resql = $this->db->query($sql);
315 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
317 $result = $member->fetch($this->fk_adherent);
318 $result = $member->update_end_date($user);
320 if (!$error && !$notrigger) {
321 $this->context = array(
'member' => $member);
323 $result = $this->
call_trigger(
'MEMBER_SUBSCRIPTION_MODIFY', $user);
331 $this->error = $this->db->lasterror();
336 $this->db->rollback();
351 public function delete($user, $notrigger = 0)
356 if ($this->fk_bank > 0) {
357 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
359 $result = $accountline->fetch($this->fk_bank);
367 $result = $this->
call_trigger(
'MEMBER_SUBSCRIPTION_DELETE', $user);
376 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"subscription WHERE rowid = ".((int) $this->
id);
377 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
378 $resql = $this->db->query($sql);
380 $num = $this->db->affected_rows($resql);
382 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
384 $result = $member->fetch($this->fk_adherent);
385 $result = $member->update_end_date($user);
387 if ($this->fk_bank > 0 && is_object($accountline) && $accountline->id > 0) {
388 $result = $accountline->delete($user);
393 $this->error = $accountline->error;
394 $this->db->rollback();
407 $this->error = $this->db->lasterror();
413 $this->db->rollback();
432 public function getNomUrl($withpicto = 0, $notooltip = 0, $option =
'', $morecss =
'', $save_lastsearch_value = -1)
438 $langs->load(
"members");
440 $label =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Subscription").
'</u>';
444 $label .=
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
445 if (!empty($this->dateh)) {
446 $label .=
'<br><b>'.$langs->trans(
'DateStart').
':</b> '.
dol_print_date($this->dateh,
'day');
448 if (!empty($this->datef)) {
449 $label .=
'<br><b>'.$langs->trans(
'DateEnd').
':</b> '.
dol_print_date($this->datef,
'day');
452 $url = DOL_URL_ROOT.
'/adherents/subscription/card.php?rowid='.((int) $this->
id);
454 if ($option !=
'nolink') {
456 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
457 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
458 $add_save_lastsearch_values = 1;
460 if ($add_save_lastsearch_values) {
461 $url .=
'&save_lastsearch_values=1';
465 $linkstart =
'<a href="'.$url.
'" class="classfortooltip" title="'.
dol_escape_htmltag($label, 1).
'">';
468 $result .= $linkstart;
470 $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);
472 if ($withpicto != 2) {
473 $result .= $this->ref;
517 $sql =
'SELECT c.rowid, c.datec,';
518 $sql .=
' c.tms as datem';
519 $sql .=
' FROM '.MAIN_DB_PREFIX.
'subscription as c';
520 $sql .=
' WHERE c.rowid = '.((int) $id);
522 $resql = $this->db->query($sql);
524 if ($this->db->num_rows($resql)) {
525 $obj = $this->db->fetch_object($resql);
526 $this->
id = $obj->rowid;
528 $this->date_creation = $this->db->jdate($obj->datec);
529 $this->date_modification = $this->db->jdate($obj->datem);
532 $this->db->free($resql);
547 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
549 $return =
'<div class="box-flex-item box-flex-grow-zero">';
550 $return .=
'<div class="info-box info-box-sm">';
551 $return .=
'<span class="info-box-icon bg-infobox-action">';
553 $return .=
'</span>';
555 $return .=
'<div class="info-box-content">';
556 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">';
558 $return .=
'</span>';
559 if ($selected >= 0) {
560 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
562 if (property_exists($this,
'dateh') || property_exists($this,
'datef')) {
563 $return .=
'<br><span class="info-box-status opacitymedium small">'.dol_print_date($this->dateh,
'day').
' - '.
dol_print_date($this->datef,
'day').
'</span>';
566 if (!empty($arraydata[
'member']) && is_object($arraydata[
'member'])) {
567 $return .=
'<br><div class="inline-block tdoverflowmax150">'.$arraydata[
'member']->getNomUrl(-4).
'</div>';
570 if (property_exists($this,
'amount')) {
571 $return .=
'<br><span class="amount inline-block">'.price($this->amount).
'</span>';
572 if (!empty($arraydata[
'bank'])) {
573 $return .=
' <span class="info-box-label ">'.$arraydata[
'bank']->getNomUrl(-1).
'</span>';
Class to manage bank transaction lines.
Class to manage members of a foundation.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class to manage subscriptions of foundation members.
fetch($rowid)
Method to load a subscription.
getLibStatut($mode=0)
Return the label of the status.
create($user, $notrigger=0)
Function who permitted creation of the subscription.
info($id)
Load information of the subscription object.
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
__construct($db)
Constructor.
getNomUrl($withpicto=0, $notooltip=0, $option='', $morecss='', $save_lastsearch_value=-1)
Return clicable name (with picto eventually)
LibStatut($status, $mode=0)
Return the label of a given status.
update($user, $notrigger=0)
Update subscription.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_now($mode='auto')
Return date for now.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...