29 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
40 public $element =
'user_bank_account';
45 public $table_element =
'user_rib';
81 $this->error_number = 0;
92 public function create(
User $user =
null, $notrigger = 0)
96 $sql =
"INSERT INTO ".$this->db->prefix().
"user_rib (fk_user, datec)";
97 $sql .=
" VALUES (".$this->userid.
", '".$this->
db->idate($now).
"')";
100 if ($this->
db->affected_rows(
$resql)) {
101 $this->
id = $this->
db->last_insert_id($this->
db->prefix().
"user_rib");
103 return $this->
update($user);
106 print $this->
db->error();
126 $sql =
"UPDATE ".$this->db->prefix().
"user_rib SET";
127 $sql .=
" bank = '".$this->db->escape($this->bank).
"'";
128 $sql .=
",code_banque='".$this->db->escape($this->code_banque).
"'";
129 $sql .=
",code_guichet='".$this->db->escape($this->code_guichet).
"'";
130 $sql .=
",number='".$this->db->escape($this->number).
"'";
131 $sql .=
",cle_rib='".$this->db->escape($this->cle_rib).
"'";
132 $sql .=
",bic='".$this->db->escape($this->bic).
"'";
133 $sql .=
",iban_prefix = '".$this->db->escape($this->iban).
"'";
134 $sql .=
",domiciliation='".$this->db->escape($this->domiciliation).
"'";
135 $sql .=
",proprio = '".$this->db->escape($this->proprio).
"'";
136 $sql .=
",owner_address = '".$this->db->escape($this->owner_address).
"'";
138 if (trim($this->label) !=
'') {
139 $sql .=
",label = '".$this->db->escape($this->label).
"'";
141 $sql .=
",label = NULL";
143 $sql .=
" WHERE rowid = ".((int) $this->
id);
145 $result = $this->
db->query($sql);
162 public function fetch($id, $ref =
'', $userid = 0)
164 if (empty($id) && empty($ref) && empty($userid)) {
168 $sql =
"SELECT rowid, fk_user, entity, bank, number, code_banque, code_guichet, cle_rib, bic, iban_prefix as iban, domiciliation, proprio,";
169 $sql .=
" owner_address, label, datec, tms as datem";
170 $sql .=
" FROM ".$this->db->prefix().
"user_rib";
172 $sql .=
" WHERE rowid = ".((int) $id);
175 $sql .=
" WHERE label = '".$this->db->escape($ref).
"'";
178 $sql .=
" WHERE fk_user = ".((int) $userid);
184 $obj = $this->
db->fetch_object(
$resql);
186 $this->
id = $obj->rowid;
187 $this->userid = $obj->fk_soc;
188 $this->bank = $obj->bank;
189 $this->code_banque = $obj->code_banque;
190 $this->code_guichet = $obj->code_guichet;
191 $this->number = $obj->number;
192 $this->cle_rib = $obj->cle_rib;
193 $this->bic = $obj->bic;
194 $this->iban = $obj->iban;
195 $this->domiciliation = $obj->domiciliation;
196 $this->proprio = $obj->proprio;
197 $this->owner_address = $obj->owner_address;
198 $this->label = $obj->label;
199 $this->datec = $this->
db->jdate($obj->datec);
200 $this->datem = $this->
db->jdate($obj->datem);
221 if ($this->code_banque || $this->code_guichet || $this->number || $this->cle_rib) {
222 if ($this->label && $displayriblabel) {
223 $rib = $this->label.
" : ";
226 $rib .= (string) $this;