29 require_once NOALYSS_INCLUDE.
'/database/class_noalyss_sql.php';
38 $this->
table =
"rapport_advanced.formulaire_param";
39 $this->primary_key =
"p_id";
44 "p_libelle" =>
"p_libelle",
46 "p_order" =>
"p_order",
54 "p_libelle" =>
"text",
55 "p_type" =>
"numeric",
56 "p_order" =>
"numeric",
61 $this->
default = array(
66 parent::__construct($cn, $p_id);
78 $this->
table =
"rapport_advanced.formulaire";
79 $this->primary_key =
"f_id";
83 "f_title" =>
"f_title",
84 "f_description" =>
"f_description",
86 "f_mimetype" =>
"f_mimetype",
87 "f_filename" =>
"f_filename",
94 "f_description" =>
"text",
96 "f_mimetype" =>
"text",
97 "f_filename" =>
"text",
101 $this->
default = array(
106 parent::__construct($cn, $p_id);
118 $this->
table =
"rapport_advanced.formulaire_param_detail";
119 $this->primary_key =
"fp_id";
124 "tmp_val" =>
"tmp_val",
125 "tva_id" =>
"tva_id",
126 "fp_formula" =>
"fp_formula",
127 "fp_signed" =>
"fp_signed",
128 "jrn_def_type" =>
"jrn_def_type",
130 "type_detail" =>
"type_detail",
131 "with_tmp_val" =>
"with_tmp_val",
132 "type_sum_account" =>
"type_sum_account",
133 "operation_pcm_val" =>
"operation_pcm_val",
134 "jrn_def_id" =>
"jrn_def_id",
135 "date_paid" =>
"date_paid"
139 "fp_id" =>
"numeric",
142 "tva_id" =>
"numeric",
143 "fp_formula" =>
"text",
144 "fp_signed" =>
"numeric",
145 "jrn_def_type" =>
"text",
146 "tt_id" =>
"numeric",
147 "type_detail" =>
"numeric",
148 "with_tmp_val" =>
"text",
149 "type_sum_account" =>
"numeric",
150 "operation_pcm_val" =>
"text",
151 "jrn_def_id" =>
"numeric",
152 "date_paid" =>
"numeric"
155 $this->
default = array(
160 parent::__construct($cn, $p_id);
172 $this->
table =
"rapport_advanced.declaration";
173 $this->primary_key =
"d_id";
177 "d_title" =>
"d_title",
178 "d_description" =>
'd_description',
179 "d_start" =>
"d_start",
181 "to_keep" =>
"to_keep",
182 "d_generated" =>
"d_generated",
184 "d_filename" =>
"d_filename",
185 "d_mimetype" =>
"d_mimetype",
186 "d_size" =>
"d_size",
194 "d_description" =>
'text',
198 "d_generated" =>
"date",
201 "d_filename" =>
"text",
202 "d_mimetype" =>
"text",
203 "d_size" =>
"numeric",
204 'd_step' =>
'numeric'
207 $this->
default = array(
209 "d_generated" =>
"auto"
213 $this->date_format =
"DD.MM.YYYY";
214 parent::__construct($cn, $p_id);
226 $this->
table =
"rapport_advanced.declaration_row";
227 $this->primary_key =
"dr_id";
232 "dr_libelle" =>
"dr_libelle",
233 "dr_order" =>
"dr_order",
234 "dr_code" =>
"dr_code",
235 "dr_amount" =>
"dr_amount",
236 "dr_type" =>
"dr_type",
237 "dr_start" =>
"dr_start",
238 "dr_end" =>
"dr_end",
239 "dr_account"=>
"dr_account"
243 "dr_id" =>
"numeric",
245 "dr_libelle" =>
"text",
246 "dr_order" =>
"text",
247 "dr_code" =>
"numeric",
248 "dr_amount" =>
"numeric",
249 "dr_type" =>
"numeric",
250 "dr_start" =>
"date",
252 "dr_account"=>
"numeric"
255 $this->
default = array(
258 $this->date_format =
'DD.MM.YYYY';
259 parent::__construct($cn, $p_id);
271 $this->
table =
"rapport_advanced.declaration_row_detail";
272 $this->primary_key =
"ddr_id";
275 "ddr_id" =>
"ddr_id",
276 "ddr_amount" =>
"ddr_amount",
281 "ddr_id" =>
"numeric",
282 "ddr_amount" =>
"numeric",
286 $this->
default = array(
291 parent::__construct($cn, $p_id);
309 $this->
table =
"rapport_advanced.listing";
310 $this->primary_key =
"l_id";
313 "description" =>
"l_description",
316 "filename" =>
"l_filename",
317 "mimetype" =>
"l_mimetype",
319 "fiche_def_id" =>
"fd_id"
324 "l_description" =>
"text",
326 "l_filename" =>
"text",
327 "l_mimetype" =>
"text",
328 "l_size" =>
"numeric",
331 $this->
default = array(
336 parent::__construct($cn, $p_id);
351 $this->
table =
"rapport_advanced.listing_param";
352 $this->primary_key =
"lp_id";
356 "listing_id" =>
"l_id",
358 "comment" =>
"lp_comment",
359 "order" =>
"l_order",
360 "tmp_val" =>
"tmp_val",
361 "tva_id" =>
"tva_id",
362 "formula" =>
"fp_formula",
363 "signed" =>
"fp_signed",
364 "jrn_def_type" =>
"jrn_def_type",
365 "acc_vat_sum" =>
"tt_id",
366 "formula_type" =>
"type_detail",
367 "with_tmp_val" =>
"with_tmp_val",
368 "sum_signed" =>
"type_sum_account",
369 "operation_pcm_val" =>
"operation_pcm_val",
370 "jrn_def_id" =>
"jrn_def_id",
371 "date_paid" =>
"date_paid",
372 "attribut_card" =>
"ad_id",
373 "card_saldo" =>
"lp_card_saldo",
374 "with_card" =>
"lp_with_card",
375 "lp_histo"=>
"lp_histo"
379 "lp_id" =>
"numeric",
382 "lp_comment" =>
"text",
383 "l_order" =>
"numeric",
385 "tva_id" =>
"numeric",
386 "fp_formula" =>
"text",
387 "fp_signed" =>
"numeric",
388 "jrn_def_type" =>
"text",
389 "tt_id" =>
"numeric",
390 "type_detail" =>
"numeric",
391 "with_tmp_val" =>
"text",
392 "type_sum_account" =>
"numeric",
393 "operation_pcm_val" =>
"text",
394 "jrn_def_id" =>
"numeric",
395 "date_paid" =>
"numeric",
396 "ad_id" =>
"numeric",
397 "lp_card_saldo" =>
"text",
398 "lp_with_card" =>
"text",
399 "lp_histo" =>
"numeric",
402 $this->
default = array(
407 parent::__construct($cn, $p_id);
432 $this->
table =
"rapport_advanced.listing_compute";
433 $this->primary_key =
"lc_id";
438 ,
"description" =>
"l_description"
439 ,
"l_start" =>
"l_start"
441 ,
"l_keep" =>
"l_keep"
442 ,
"l_timestamp" =>
"l_timestamp"
449 ,
"l_description" =>
"text"
450 ,
"l_start" =>
"date"
453 ,
"l_timestamp" =>
"date"
457 $this->
default = array(
459 ,
"l_timestamp" =>
"auto"
462 $this->date_format =
"DD.MM.YYYY";
463 parent::__construct($cn, $p_id);
502 $this->
table =
"rapport_advanced.listing_compute_fiche";
503 $this->primary_key =
"lf_id";
509 ,
"lf_lob" =>
"lf_lob"
510 ,
"lf_filename" =>
"lf_filename"
511 ,
"lf_mimetype" =>
"lf_mimetype"
512 ,
"lf_pdf" =>
"lf_pdf"
513 ,
"lf_pdf_filename" =>
"lf_pdf_filename"
514 ,
'action_included'=>
'lf_action_included'
515 ,
'email_send_date'=>
'lf_email_send_date'
516 ,
'email_send_result'=>
'lf_email_send_result'
520 "lf_id" =>
"numeric",
521 "lc_id" =>
"numeric",
524 ,
"lf_filename" =>
"text"
525 ,
"lf_mimetype" =>
"text"
527 ,
"lf_pdf_filename" =>
"text"
528 ,
'lf_action_included'=>
'text'
529 ,
'lf_email_send_date'=>
'text'
530 ,
'lf_email_send_result'=>
'text'
533 $this->
default = array(
537 $this->date_format =
"DD.MM.YYYY";
538 parent::__construct($cn, $p_id);
561 require_once NOALYSS_INCLUDE.
'/database/class_noalyss_sql.php';
587 $this->
table =
"rapport_advanced.listing_compute_detail";
588 $this->primary_key =
"ld_id";
591 "ld_id" =>
"ld_id",
"lc_id" =>
"lc_id"
592 ,
"ld_value_date" =>
"ld_value_date"
593 ,
"ld_value_numeric" =>
"ld_value_numeric"
594 ,
"ld_value_text" =>
"ld_value_text"
598 ,
'comment'=>
'lc_comment'
600 ,
'history'=>
'lc_histo'
604 "ld_id" =>
"numeric",
606 ,
"ld_value_date" =>
"date"
607 ,
"ld_value_numeric" =>
"numeric"
608 ,
"ld_value_text" =>
"text"
609 ,
"lp_id" =>
"numeric"
610 ,
"lf_id" =>
"numeric"
612 ,
'lc_comment'=>
"text"
613 ,
'lc_order'=>
"numeric"
614 ,
'lc_histo'=>
"numeric"
617 $this->
default = array(
621 $this->date_format =
"DD.MM.YYYY";
622 parent::__construct($cn, $p_id);
650 $this->
table =
"rapport_advanced.listing_compute_historique";
651 $this->primary_key =
"lh_id";
654 "lh_id" =>
"lh_id",
"lh_id" =>
"lh_id"
661 ,
"ld_id" =>
"numeric"
662 ,
"jr_id" =>
"numeric"
665 $this->
default = array(
669 $this->date_format =
"DD.MM.YYYY";
670 parent::__construct($cn, $p_id);
690 $this->
table =
"rapport_advanced.listing_condition";
691 $this->primary_key =
"id";
696 ,
"c_operator" =>
"c_operator"
697 ,
"c_value" =>
"c_value"
702 ,
"lp_id" =>
"numeric"
703 ,
"c_operator" =>
"numeric"
704 ,
"c_value" =>
"text"
707 $this->
default = array(
711 $this->date_format =
"DD.MM.YYYY";
712 parent::__construct($cn, $p_id);
verify()
Add here your own code: verify is always call BEFORE insert or update.
Manage the table rapport_advanced.listing_compute_fiche.
verify()
Add here your own code: verify is always call BEFORE insert or update.
Manage the table rapport_advanced.listing_compute_historique.
Manage the table rapport_advanced.listing_compute_detail.
verify()
Add here your own code: verify is always call BEFORE insert or update.
verify()
Add here your own code: verify is always call BEFORE insert or update.
Manage the table rapport_advanced.listing_compute.