@@ -82,8 +82,8 @@ discard block |
||
82 | 82 | |
83 | 83 | // Default sort order (if not yet defined by previous GETPOST) |
84 | 84 | if (!$sortfield) { |
85 | - reset($object->fields); // Reset is required to avoid key() to return null. |
|
86 | - $sortfield = "t.position"; // Set here default search field. By default 1st field in definition. |
|
85 | + reset($object->fields); // Reset is required to avoid key() to return null. |
|
86 | + $sortfield = "t.position"; // Set here default search field. By default 1st field in definition. |
|
87 | 87 | } |
88 | 88 | if (!$sortorder) { |
89 | 89 | $sortorder = "ASC"; |
@@ -542,7 +542,7 @@ discard block |
||
542 | 542 | } |
543 | 543 | |
544 | 544 | $varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage; |
545 | -$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields with user setup |
|
545 | +$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields with user setup |
|
546 | 546 | $selectedfields = ($mode != 'kanban' ? $htmlofselectarray : ''); |
547 | 547 | $selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : ''); |
548 | 548 | |
@@ -632,7 +632,7 @@ discard block |
||
632 | 632 | } elseif (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && !in_array($key, array('id', 'rowid', 'ref', 'status')) && $val['label'] != 'TechnicalID' && empty($val['arrayofkeyval'])) { |
633 | 633 | $cssforfield .= ($cssforfield ? ' ' : '').'right'; |
634 | 634 | } |
635 | - $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label |
|
635 | + $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label |
|
636 | 636 | if (!empty($arrayfields['t.'.$key]['checked'])) { |
637 | 637 | print getTitleFieldOfList($arrayfields['t.'.$key]['label'], 0, $_SERVER['PHP_SELF'], 't.'.$key, '', $param, ($cssforfield ? 'class="'.$cssforfield.'"' : ''), $sortfield, $sortorder, ($cssforfield ? $cssforfield.' ' : ''), 0, (empty($val['helplist']) ? '' : $val['helplist']))."\n"; |
638 | 638 | $totalarray['nbfield']++; |
@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | * Dolibarr version of the loaded document |
79 | 79 | * @var string Version, possible values are: 'development', 'experimental', 'dolibarr', 'dolibarr_deprecated' or a version string like 'x.y.z'''|'development'|'dolibarr'|'experimental' |
80 | 80 | */ |
81 | - public $version = 'disabled'; // Disabled by default. Enabled in constructor if option INVOICE_USE_SITUATION is 2. |
|
81 | + public $version = 'disabled'; // Disabled by default. Enabled in constructor if option INVOICE_USE_SITUATION is 2. |
|
82 | 82 | |
83 | 83 | /** |
84 | 84 | * @var int height for info total |
@@ -247,7 +247,7 @@ discard block |
||
247 | 247 | } |
248 | 248 | |
249 | 249 | if ($mysoc === null) { |
250 | - dol_syslog(get_class($this).'::__construct() Global $mysoc should not be null.'. getCallerInfoString(), LOG_ERR); |
|
250 | + dol_syslog(get_class($this).'::__construct() Global $mysoc should not be null.'.getCallerInfoString(), LOG_ERR); |
|
251 | 251 | return; |
252 | 252 | } |
253 | 253 | |
@@ -297,7 +297,7 @@ discard block |
||
297 | 297 | $outputlangsbis->loadLangs(array("main", "bills", "products", "dict", "companies", "compta")); |
298 | 298 | } |
299 | 299 | |
300 | - if (empty($object) || ($object->type != Facture::TYPE_SITUATION && ($object->type != Facture::TYPE_CREDIT_NOTE && !empty($object->situation_cycle_ref)))) { |
|
300 | + if (empty($object) || ($object->type != Facture::TYPE_SITUATION && ($object->type != Facture::TYPE_CREDIT_NOTE && !empty($object->situation_cycle_ref)))) { |
|
301 | 301 | setEventMessage($langs->trans('WarningsObjectIsNotASituation'), 'warnings'); |
302 | 302 | return 1; |
303 | 303 | } |
@@ -416,15 +416,15 @@ discard block |
||
416 | 416 | $pdf->SetAutoPageBreak(1, 0); |
417 | 417 | |
418 | 418 | // compute height for situation invoices |
419 | - $this->heightforinfotot = 45; // Height reserved to output the info and total part and payment part |
|
419 | + $this->heightforinfotot = 45; // Height reserved to output the info and total part and payment part |
|
420 | 420 | if (!getDolGlobalString('INVOICE_NO_PAYMENT_DETAILS') && $nbpayments > 0) { |
421 | 421 | $this->heightforinfotot += 4 * ($nbpayments + 3); |
422 | 422 | } |
423 | 423 | if ($nbprevsituation > 0) { |
424 | 424 | $this->heightforinfotot += 4 * ($nbprevsituation + 3); |
425 | 425 | } |
426 | - $this->heightforfreetext = (getDolGlobalInt('MAIN_PDF_FREETEXT_HEIGHT', 5)); // Height reserved to output the free text on last page |
|
427 | - $this->heightforfooter = $this->marge_basse + (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS') ? 12 : 22); // Height reserved to output the footer (value include bottom margin) |
|
426 | + $this->heightforfreetext = (getDolGlobalInt('MAIN_PDF_FREETEXT_HEIGHT', 5)); // Height reserved to output the free text on last page |
|
427 | + $this->heightforfooter = $this->marge_basse + (!getDolGlobalString('MAIN_GENERATE_DOCUMENTS_SHOW_FOOT_DETAILS') ? 12 : 22); // Height reserved to output the footer (value include bottom margin) |
|
428 | 428 | |
429 | 429 | if (class_exists('TCPDF')) { |
430 | 430 | $pdf->setPrintHeader(false); |
@@ -438,7 +438,7 @@ discard block |
||
438 | 438 | if (!empty($conf->mycompany->multidir_output[$object->entity])) { |
439 | 439 | $logodir = $conf->mycompany->multidir_output[$object->entity]; |
440 | 440 | } |
441 | - $pagecount = $pdf->setSourceFile($logodir.'/' . getDolGlobalString('MAIN_ADD_PDF_BACKGROUND')); |
|
441 | + $pagecount = $pdf->setSourceFile($logodir.'/'.getDolGlobalString('MAIN_ADD_PDF_BACKGROUND')); |
|
442 | 442 | $this->tplidx = $pdf->importPage(1); |
443 | 443 | } |
444 | 444 | |
@@ -530,7 +530,7 @@ discard block |
||
530 | 530 | // $pdf->GetY() here can't be used. It is bottom of the second address box but first one may be higher |
531 | 531 | |
532 | 532 | // $this->tab_top is y where we must continue content (90 = 42 + 48: 42 is height of logo and ref, 48 is address blocks) |
533 | - $this->tab_top = 90 + $top_shift + $shipp_shift; // top_shift is an addition for linked objects or addons (0 in most cases) |
|
533 | + $this->tab_top = 90 + $top_shift + $shipp_shift; // top_shift is an addition for linked objects or addons (0 in most cases) |
|
534 | 534 | $this->tab_top_newpage = (!getDolGlobalInt('MAIN_PDF_DONOTREPEAT_HEAD') ? 42 + $top_shift : 10); |
535 | 535 | |
536 | 536 | // You can add more thing under header here, if you increase $extra_under_address_shift too. |
@@ -1040,11 +1040,11 @@ discard block |
||
1040 | 1040 | if (!isset($this->tva[$vatrate])) { |
1041 | 1041 | $this->tva[$vatrate] = 0; |
1042 | 1042 | } |
1043 | - $this->tva[$vatrate] += $tvaligne; // ->tva is abandoned, we use now ->tva_array that is more complete |
|
1043 | + $this->tva[$vatrate] += $tvaligne; // ->tva is abandoned, we use now ->tva_array that is more complete |
|
1044 | 1044 | $vatcode = $object->lines[$i]->vat_src_code; |
1045 | 1045 | if (getDolGlobalInt('PDF_INVOICE_SHOW_VAT_ANALYSIS')) { |
1046 | 1046 | if (empty($this->tva_array[$vatrate.($vatcode ? ' ('.$vatcode.')' : '')]['tot_ht'])) { |
1047 | - $this->tva_array[$vatrate . ($vatcode ? ' (' . $vatcode . ')' : '')]['tot_ht'] = 0; |
|
1047 | + $this->tva_array[$vatrate.($vatcode ? ' ('.$vatcode.')' : '')]['tot_ht'] = 0; |
|
1048 | 1048 | } |
1049 | 1049 | $this->tva_array[$vatrate.($vatcode ? ' ('.$vatcode.')' : '')] = array('vatrate'=>$vatrate, 'vatcode'=>$vatcode, 'amount'=> $this->tva_array[$vatrate.($vatcode ? ' ('.$vatcode.')' : '')]['amount'] + $tvaligne, 'tot_ht'=> $this->tva_array[$vatrate.($vatcode ? ' ('.$vatcode.')' : '')]['tot_ht'] + $object->lines[$i]->total_ht); |
1050 | 1050 | } else { |
@@ -1136,7 +1136,7 @@ discard block |
||
1136 | 1136 | // Pagefoot |
1137 | 1137 | $this->_pagefoot($pdf, $object, $outputlangs); |
1138 | 1138 | if (method_exists($pdf, 'AliasNbPages')) { |
1139 | - $pdf->AliasNbPages(); // @phan-suppress-current-line PhanUndeclaredMethod |
|
1139 | + $pdf->AliasNbPages(); // @phan-suppress-current-line PhanUndeclaredMethod |
|
1140 | 1140 | } |
1141 | 1141 | |
1142 | 1142 | $this->resumeLastPage($pdf, $object, 0, $tab_top, $outputlangs, $outputlangsbis); |
@@ -1372,7 +1372,7 @@ discard block |
||
1372 | 1372 | foreach ($this->tva_array as $tvakey => $tvaval) { |
1373 | 1373 | $pdf->SetFont('', '', $default_font_size - 2); |
1374 | 1374 | $pdf->SetXY($this->marge_gauche, $posy); |
1375 | - $titre = round((float) $tvakey, 2) . "%"; |
|
1375 | + $titre = round((float) $tvakey, 2)."%"; |
|
1376 | 1376 | $pdf->MultiCell(25, 4, $titre, 0, 'L'); |
1377 | 1377 | |
1378 | 1378 | $pdf->SetFont('', '', $default_font_size - 2); |
@@ -1410,8 +1410,8 @@ discard block |
||
1410 | 1410 | $posy = $pdf->GetY() + 4; |
1411 | 1411 | } |
1412 | 1412 | |
1413 | - $posxval = 52; // Position of values of properties shown on left side |
|
1414 | - $posxend = 110; // End of x for text on left side |
|
1413 | + $posxval = 52; // Position of values of properties shown on left side |
|
1414 | + $posxend = 110; // End of x for text on left side |
|
1415 | 1415 | if ($this->page_largeur < 210) { // To work with US executive format |
1416 | 1416 | $posxend -= 10; |
1417 | 1417 | } |
@@ -1441,7 +1441,7 @@ discard block |
||
1441 | 1441 | |
1442 | 1442 | $pdf->SetFont('', '', $default_font_size - 2); |
1443 | 1443 | $pdf->SetXY($posxval, $posy); |
1444 | - $categoryOfOperationLabel = $outputlangs->transnoentities("MentionCategoryOfOperations" . $this->categoryOfOperation); |
|
1444 | + $categoryOfOperationLabel = $outputlangs->transnoentities("MentionCategoryOfOperations".$this->categoryOfOperation); |
|
1445 | 1445 | $pdf->MultiCell($posxend - $posxval, 4, $categoryOfOperationLabel, 0, 'L'); |
1446 | 1446 | |
1447 | 1447 | $posy = $pdf->GetY() + 3; // for 2 lines |
@@ -1608,7 +1608,7 @@ discard block |
||
1608 | 1608 | include_once DOL_DOCUMENT_ROOT.'/core/lib/functions_be.lib.php'; |
1609 | 1609 | $invoicePaymentKey = dolBECalculateStructuredCommunication($object->ref, $object->type); |
1610 | 1610 | |
1611 | - $pdf->MultiCell(100, 3, $outputlangs->transnoentities('StructuredCommunication').": " . $outputlangs->convToOutputCharset($invoicePaymentKey), 0, 'L', 0); |
|
1611 | + $pdf->MultiCell(100, 3, $outputlangs->transnoentities('StructuredCommunication').": ".$outputlangs->convToOutputCharset($invoicePaymentKey), 0, 'L', 0); |
|
1612 | 1612 | } |
1613 | 1613 | } |
1614 | 1614 | } |
@@ -1794,7 +1794,7 @@ discard block |
||
1794 | 1794 | if (($object->lines[$i]->info_bits & 0x01) == 0x01) { |
1795 | 1795 | $vatrate .= '*'; |
1796 | 1796 | } |
1797 | - if (! isset($tvas[$vatrate])) { |
|
1797 | + if (!isset($tvas[$vatrate])) { |
|
1798 | 1798 | $tvas[$vatrate] = 0; |
1799 | 1799 | } |
1800 | 1800 | $tvas[$vatrate] += $tvaligne; |
@@ -2063,7 +2063,7 @@ discard block |
||
2063 | 2063 | if (empty($hidetop)) { |
2064 | 2064 | // Show category of operations |
2065 | 2065 | if (getDolGlobalInt('INVOICE_CATEGORY_OF_OPERATION') == 1 && $this->categoryOfOperation >= 0) { |
2066 | - $categoryOfOperations = $outputlangs->transnoentities("MentionCategoryOfOperations") . ' : ' . $outputlangs->transnoentities("MentionCategoryOfOperations" . $this->categoryOfOperation); |
|
2066 | + $categoryOfOperations = $outputlangs->transnoentities("MentionCategoryOfOperations").' : '.$outputlangs->transnoentities("MentionCategoryOfOperations".$this->categoryOfOperation); |
|
2067 | 2067 | $pdf->SetXY($this->marge_gauche, $tab_top - 4); |
2068 | 2068 | $pdf->MultiCell(($pdf->GetStringWidth($categoryOfOperations)) + 4, 2, $categoryOfOperations); |
2069 | 2069 | } |
@@ -2083,7 +2083,7 @@ discard block |
||
2083 | 2083 | $pdf->SetFont('', '', $default_font_size - 1); |
2084 | 2084 | |
2085 | 2085 | // Output Rect |
2086 | - $this->printRoundedRect($pdf, $this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $tab_height, $this->corner_radius, $hidetop, $hidebottom, 'D'); // Rect prend une longueur en 3eme param et 4eme param |
|
2086 | + $this->printRoundedRect($pdf, $this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $tab_height, $this->corner_radius, $hidetop, $hidebottom, 'D'); // Rect prend une longueur en 3eme param et 4eme param |
|
2087 | 2087 | |
2088 | 2088 | // situation invoice |
2089 | 2089 | $pdf->SetFont('', '', $default_font_size - 2); |
@@ -2123,7 +2123,7 @@ discard block |
||
2123 | 2123 | $pdf->SetFont('', '', $default_font_size - 1); |
2124 | 2124 | |
2125 | 2125 | if (empty($hidetop)) { |
2126 | - $pdf->line($this->marge_gauche, $tab_top + 5, $this->page_largeur - $this->marge_droite, $tab_top + 5); // line prend une position y en 2eme param et 4eme param |
|
2126 | + $pdf->line($this->marge_gauche, $tab_top + 5, $this->page_largeur - $this->marge_droite, $tab_top + 5); // line prend une position y en 2eme param et 4eme param |
|
2127 | 2127 | } |
2128 | 2128 | } |
2129 | 2129 | |
@@ -2700,7 +2700,7 @@ discard block |
||
2700 | 2700 | 'overtitle' => array( |
2701 | 2701 | 'textkey' => 'Chantier', // use lang key is useful in somme case with module |
2702 | 2702 | 'align' => 'C', |
2703 | - 'padding' => array(0.5,0.5,0.5,0.5), // Like css 0 => top , 1 => right, 2 => bottom, 3 => left |
|
2703 | + 'padding' => array(0.5, 0.5, 0.5, 0.5), // Like css 0 => top , 1 => right, 2 => bottom, 3 => left |
|
2704 | 2704 | 'width' => 18 |
2705 | 2705 | ), |
2706 | 2706 | ); |
@@ -2725,13 +2725,13 @@ discard block |
||
2725 | 2725 | ), |
2726 | 2726 | 'border-left' => true, // add left line separator |
2727 | 2727 | 'overtitle' => array( |
2728 | - 'textkey' => 'S'.$derniere_situation->situation_counter . ' - ' . dol_print_date($derniere_situation->date, "%d/%m/%Y"), |
|
2728 | + 'textkey' => 'S'.$derniere_situation->situation_counter.' - '.dol_print_date($derniere_situation->date, "%d/%m/%Y"), |
|
2729 | 2729 | 'align' => 'C', |
2730 | - 'padding' => array(0.5,0.2,0.5,0.2), // Like css 0 => top, 1 => right, 2 => bottom, 3 => left |
|
2730 | + 'padding' => array(0.5, 0.2, 0.5, 0.2), // Like css 0 => top, 1 => right, 2 => bottom, 3 => left |
|
2731 | 2731 | 'width' => 10 + 15 //current width + amount cell width |
2732 | 2732 | ), |
2733 | 2733 | ); |
2734 | - if ($this->situationinvoice && ! empty($this->TDataSituation['date_derniere_situation'])) { |
|
2734 | + if ($this->situationinvoice && !empty($this->TDataSituation['date_derniere_situation'])) { |
|
2735 | 2735 | $this->cols['prev_progress']['status'] = true; |
2736 | 2736 | } |
2737 | 2737 | |
@@ -2746,7 +2746,7 @@ discard block |
||
2746 | 2746 | ), |
2747 | 2747 | 'border-left' => true, // add left line separator |
2748 | 2748 | ); |
2749 | - if ($this->situationinvoice && ! empty($this->TDataSituation['date_derniere_situation'])) { |
|
2749 | + if ($this->situationinvoice && !empty($this->TDataSituation['date_derniere_situation'])) { |
|
2750 | 2750 | $this->cols['prev_progress_amount']['status'] = true; |
2751 | 2751 | } |
2752 | 2752 | |
@@ -2761,9 +2761,9 @@ discard block |
||
2761 | 2761 | ), |
2762 | 2762 | 'border-left' => true, // add left line separator |
2763 | 2763 | 'overtitle' => array( |
2764 | - 'textkey' => 'S'.$object->situation_counter . ' - ' . dol_print_date($object->date, "%d/%m/%Y"), |
|
2764 | + 'textkey' => 'S'.$object->situation_counter.' - '.dol_print_date($object->date, "%d/%m/%Y"), |
|
2765 | 2765 | 'align' => 'C', |
2766 | - 'padding' => array(0.5,0.2,0.5,0.2), // Like css 0 => top, 1 => right, 2 => bottom, 3 => left |
|
2766 | + 'padding' => array(0.5, 0.2, 0.5, 0.2), // Like css 0 => top, 1 => right, 2 => bottom, 3 => left |
|
2767 | 2767 | 'width' => 10 + 15 |
2768 | 2768 | ), |
2769 | 2769 | ); |
@@ -2887,7 +2887,7 @@ discard block |
||
2887 | 2887 | |
2888 | 2888 | // Output Rect |
2889 | 2889 | // KEEPTHIS => Affiche les bords extérieurs |
2890 | - $this->printRoundedRectBtp($pdf, $this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $tab_height, $this->corner_radius, $hidetop, $hidebottom, 'D'); // Rect prend une longueur en 3eme param et 4eme param |
|
2890 | + $this->printRoundedRectBtp($pdf, $this->marge_gauche, $tab_top, $this->page_largeur - $this->marge_gauche - $this->marge_droite, $tab_height, $this->corner_radius, $hidetop, $hidebottom, 'D'); // Rect prend une longueur en 3eme param et 4eme param |
|
2891 | 2891 | |
2892 | 2892 | $pdf->line($this->posx_cumul_anterieur - 1, $tab_top, $this->posx_cumul_anterieur - 1, $tab_top + $tab_height); |
2893 | 2893 | if (empty($hidetop)) { |
@@ -2944,7 +2944,7 @@ discard block |
||
2944 | 2944 | $pdf->SetXY($this->marge_gauche + 10, $tab_top + 24 + $i); |
2945 | 2945 | $pdf->MultiCell(80, 2, $outputlangs->transnoentities("TotalHT").' '.$TVatInfo['label'], '', 'L'); |
2946 | 2946 | |
2947 | - if (! empty($this->TDataSituation['current'][$tva_tx_formated]['TVA'])) { |
|
2947 | + if (!empty($this->TDataSituation['current'][$tva_tx_formated]['TVA'])) { |
|
2948 | 2948 | $pdf->SetXY($this->marge_gauche + 10, $tab_top + 28 + $i); |
2949 | 2949 | $pdf->MultiCell(80, 2, $outputlangs->transnoentities("VAT").' '.$TVatInfo['label'], '', 'L'); |
2950 | 2950 | } else { |
@@ -3008,7 +3008,7 @@ discard block |
||
3008 | 3008 | $pdf->MultiCell(32, 2, price($this->TDataSituation[$col][$tva_tx_formated]['HT'], 0, '', 1, -1, 2), '', 'R'); |
3009 | 3009 | |
3010 | 3010 | // Total TVA |
3011 | - if (! empty($this->TDataSituation['current'][$tva_tx_formated]['TVA'])) { |
|
3011 | + if (!empty($this->TDataSituation['current'][$tva_tx_formated]['TVA'])) { |
|
3012 | 3012 | $pdf->SetXY($x, $tab_top + 28 + $i); |
3013 | 3013 | $pdf->MultiCell(32, 2, price($this->TDataSituation[$col][$tva_tx_formated]['TVA'], 0, '', 1, -1, 2), '', 'R'); |
3014 | 3014 | } else { |
@@ -3086,7 +3086,7 @@ discard block |
||
3086 | 3086 | |
3087 | 3087 | $TDataSituation = array(); |
3088 | 3088 | |
3089 | - if (! empty($facDerniereSituation)) { |
|
3089 | + if (!empty($facDerniereSituation)) { |
|
3090 | 3090 | $TDataSituation['derniere_situation'] = $facDerniereSituation; |
3091 | 3091 | $TDataSituation['date_derniere_situation'] = $facDerniereSituation->date; |
3092 | 3092 | } |
@@ -3095,9 +3095,9 @@ discard block |
||
3095 | 3095 | $retenue_garantie_anterieure = 0; |
3096 | 3096 | // Init tous les champs à 0 |
3097 | 3097 | $TDataSituation['cumul_anterieur'] = array( |
3098 | - 'HT' => 0, //montant HT normal |
|
3099 | - 'TVA' => 0, //montant de la TVA sur le HTnet |
|
3100 | - 'TTC' => 0, //montant TTC (HTnet + TVA) |
|
3098 | + 'HT' => 0, //montant HT normal |
|
3099 | + 'TVA' => 0, //montant de la TVA sur le HTnet |
|
3100 | + 'TTC' => 0, //montant TTC (HTnet + TVA) |
|
3101 | 3101 | 'retenue_garantie' => 0, |
3102 | 3102 | 'travaux_sup' => 0, |
3103 | 3103 | 'HTnet' => 0, //montant HT |
@@ -3127,7 +3127,7 @@ discard block |
||
3127 | 3127 | $isFirstSituation = false; |
3128 | 3128 | if (!empty($l->fk_prev_id)) { |
3129 | 3129 | $prevSituationPercent = $l->get_prev_progress($previousInvoice->id, true); |
3130 | - } elseif (! array_key_exists($i + 1, $TPreviousInvoices)) { |
|
3130 | + } elseif (!array_key_exists($i + 1, $TPreviousInvoices)) { |
|
3131 | 3131 | $isFirstSituation = true; |
3132 | 3132 | } |
3133 | 3133 | |
@@ -3137,7 +3137,7 @@ discard block |
||
3137 | 3137 | |
3138 | 3138 | //1ere ligne |
3139 | 3139 | $amounttva = $calc_ht * ($ltvatx / 100); |
3140 | - if (! isset($TDataSituation['cumul_anterieur'][$ltvatx])) { |
|
3140 | + if (!isset($TDataSituation['cumul_anterieur'][$ltvatx])) { |
|
3141 | 3141 | $TDataSituation['cumul_anterieur'][$ltvatx]['HT'] = $calc_ht; |
3142 | 3142 | $TDataSituation['cumul_anterieur'][$ltvatx]['TVA'] = $amounttva; |
3143 | 3143 | } else { |
@@ -3149,14 +3149,14 @@ discard block |
||
3149 | 3149 | //le grand total de TVA |
3150 | 3150 | // $TDataSituation['cumul_anterieur']['TVA'] += $amounttva; |
3151 | 3151 | |
3152 | - if (empty($l->fk_prev_id) && ! $isFirstSituation) { |
|
3152 | + if (empty($l->fk_prev_id) && !$isFirstSituation) { |
|
3153 | 3153 | // TODO: à clarifier, mais pour moi, un facture de situation précédente qui a des progressions à 0% c'est pas logique |
3154 | 3154 | $TDataSituation['cumul_anterieur']['travaux_sup'] += $calc_ht; |
3155 | 3155 | } |
3156 | 3156 | } |
3157 | 3157 | } |
3158 | 3158 | |
3159 | - if (! empty($previousInvoice->retained_warranty) && !getDolGlobalString('USE_RETAINED_WARRANTY_ONLY_FOR_SITUATION_FINAL')) { |
|
3159 | + if (!empty($previousInvoice->retained_warranty) && !getDolGlobalString('USE_RETAINED_WARRANTY_ONLY_FOR_SITUATION_FINAL')) { |
|
3160 | 3160 | $retenue_garantie_anterieure += $previousInvoice->getRetainedWarrantyAmount(); |
3161 | 3161 | } |
3162 | 3162 | |
@@ -3170,7 +3170,7 @@ discard block |
||
3170 | 3170 | // print json_encode($facDerniereSituation->lines);exit; |
3171 | 3171 | $TDataSituation['current'] = $this->btpGetInvoiceAmounts($object->id); |
3172 | 3172 | |
3173 | - if (! empty($facDerniereSituation->lines)) { |
|
3173 | + if (!empty($facDerniereSituation->lines)) { |
|
3174 | 3174 | $TFacLinesKey = array_keys($facDerniereSituation->lines); |
3175 | 3175 | $TObjectLinesKey = array_keys($object->lines); |
3176 | 3176 | $TDiffKey = array_diff($TObjectLinesKey, $TFacLinesKey); |
@@ -3382,16 +3382,16 @@ discard block |
||
3382 | 3382 | $facDerniereSituation = $TPreviousInvoices[0]; |
3383 | 3383 | |
3384 | 3384 | $ret = array( |
3385 | - 'HT' => 0, //montant HT normal |
|
3385 | + 'HT' => 0, //montant HT normal |
|
3386 | 3386 | 'HTnet' => 0, //montant HT |
3387 | - 'TVA' => 0, //montant de la TVA sur le HTnet |
|
3388 | - 'TTC' => 0, //montant TTC (HTnet + TVA) |
|
3387 | + 'TVA' => 0, //montant de la TVA sur le HTnet |
|
3388 | + 'TTC' => 0, //montant TTC (HTnet + TVA) |
|
3389 | 3389 | 'retenue_garantie' => 0, |
3390 | 3390 | 'travaux_sup' => 0, |
3391 | 3391 | 'total_a_payer' => 0 //montant "a payer" sur la facture |
3392 | 3392 | ); |
3393 | 3393 | |
3394 | - if (! empty($facDerniereSituation)) { |
|
3394 | + if (!empty($facDerniereSituation)) { |
|
3395 | 3395 | $ret['derniere_situation'] = $facDerniereSituation; |
3396 | 3396 | $ret['date_derniere_situation'] = $facDerniereSituation->date; |
3397 | 3397 | } |
@@ -3525,7 +3525,7 @@ discard block |
||
3525 | 3525 | $label = $outputlangs->transnoentities("SituationInvoiceTotalProposal"); |
3526 | 3526 | $pdf->MultiCell($this->page_largeur - ($this->marge_droite + $this->marge_gauche), 3, $label, 0, 'L', 0, 1, $posx, $posy + 1); |
3527 | 3527 | |
3528 | - $amount = price($sign * ($total_ht + (! empty($propal->remise) ? $propal->remise : 0))); |
|
3528 | + $amount = price($sign * ($total_ht + (!empty($propal->remise) ? $propal->remise : 0))); |
|
3529 | 3529 | $pdf->MultiCell($width2, 3, $amount, 0, 'R', 0, 1, $posx + $width, $posy + 1); |
3530 | 3530 | |
3531 | 3531 | $pdf->SetFont('', '', $default_font_size - 1); |
@@ -3568,7 +3568,7 @@ discard block |
||
3568 | 3568 | |
3569 | 3569 | $force_to_zero = false; |
3570 | 3570 | |
3571 | - $idinv = 0;//count($previousinvoices); |
|
3571 | + $idinv = 0; //count($previousinvoices); |
|
3572 | 3572 | while ($idinv < count($previousinvoices)) { |
3573 | 3573 | $invoice = $previousinvoices[$idinv]; |
3574 | 3574 | |
@@ -3590,7 +3590,7 @@ discard block |
||
3590 | 3590 | $force_to_zero = true; |
3591 | 3591 | } |
3592 | 3592 | |
3593 | - $ref .= ' - '. $invoice->ref; |
|
3593 | + $ref .= ' - '.$invoice->ref; |
|
3594 | 3594 | $ref .= ' ('.dol_print_date($invoice->date, "%d/%m/%Y", false, $outputlangs).')'; |
3595 | 3595 | $pdf->MultiCell($this->page_largeur - ($this->marge_droite + $this->marge_gauche), 3, $ref, 0, 'L', 0); |
3596 | 3596 | |
@@ -3621,7 +3621,7 @@ discard block |
||
3621 | 3621 | if (($invoice->lines[$i]->info_bits & 0x01) == 0x01) { |
3622 | 3622 | $vatrate .= '*'; |
3623 | 3623 | } |
3624 | - if (! isset($tvas[$vatrate])) { |
|
3624 | + if (!isset($tvas[$vatrate])) { |
|
3625 | 3625 | $tvas[$vatrate] = 0; |
3626 | 3626 | } |
3627 | 3627 | $tvas[$vatrate] += $tvaligne; |
@@ -3799,7 +3799,7 @@ discard block |
||
3799 | 3799 | $pdf->SetXY($posx + $width4, $posy + $height * $index + $y); |
3800 | 3800 | $pdf->MultiCell($width4, $height - 1, price($sign * $payment['amount'], 0, $outputlangs), 0, 'L', 0); |
3801 | 3801 | $pdf->SetXY($posx + $width4 * 2, $posy + $height * $index + $y); |
3802 | - $oper = $outputlangs->transnoentitiesnoconv("PaymentTypeShort" . $payment['type']); |
|
3802 | + $oper = $outputlangs->transnoentitiesnoconv("PaymentTypeShort".$payment['type']); |
|
3803 | 3803 | |
3804 | 3804 | $pdf->MultiCell($width4, $height - 1, $oper, 0, 'L', 0); |
3805 | 3805 | $pdf->SetXY($posx + $width4 * 3, $posy + $height * $index + $y); |
@@ -3830,7 +3830,7 @@ discard block |
||
3830 | 3830 | $this->_pagehead($pdf, $object, 0, $outputlangs); |
3831 | 3831 | } |
3832 | 3832 | $pdf->setPage($pageposafter + 1); |
3833 | - $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it. |
|
3833 | + $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it. |
|
3834 | 3834 | |
3835 | 3835 | $posy = $this->tab_top_newpage + 1; |
3836 | 3836 | } else { |
@@ -3862,7 +3862,7 @@ discard block |
||
3862 | 3862 | |
3863 | 3863 | $posy += 10; |
3864 | 3864 | |
3865 | - $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it. |
|
3865 | + $pdf->setPageOrientation('', 1, 0); // The only function to edit the bottom margin of current page to set it. |
|
3866 | 3866 | |
3867 | 3867 | $pdf->SetTextColor(0, 0, 60); |
3868 | 3868 | $pdf->SetFont('', '', $default_font_size - 1); |
@@ -33,14 +33,14 @@ discard block |
||
33 | 33 | |
34 | 34 | // Load Dolibarr environment |
35 | 35 | require '../../main.inc.php'; |
36 | -require_once DOL_DOCUMENT_ROOT . '/projet/class/project.class.php'; |
|
37 | -require_once DOL_DOCUMENT_ROOT . '/projet/class/task.class.php'; |
|
38 | -require_once DOL_DOCUMENT_ROOT . '/compta/facture/class/facture.class.php'; |
|
39 | -require_once DOL_DOCUMENT_ROOT . '/core/lib/project.lib.php'; |
|
40 | -require_once DOL_DOCUMENT_ROOT . '/core/lib/date.lib.php'; |
|
41 | -require_once DOL_DOCUMENT_ROOT . '/core/class/html.formother.class.php'; |
|
42 | -require_once DOL_DOCUMENT_ROOT . '/core/class/html.formprojet.class.php'; |
|
43 | -require_once DOL_DOCUMENT_ROOT . '/core/class/html.formintervention.class.php'; |
|
36 | +require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php'; |
|
37 | +require_once DOL_DOCUMENT_ROOT.'/projet/class/task.class.php'; |
|
38 | +require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php'; |
|
39 | +require_once DOL_DOCUMENT_ROOT.'/core/lib/project.lib.php'; |
|
40 | +require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php'; |
|
41 | +require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php'; |
|
42 | +require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php'; |
|
43 | +require_once DOL_DOCUMENT_ROOT.'/core/class/html.formintervention.class.php'; |
|
44 | 44 | |
45 | 45 | /** |
46 | 46 | * @var Conf $conf |
@@ -176,7 +176,7 @@ discard block |
||
176 | 176 | setEventMessages($hookmanager->error, $hookmanager->errors, 'errors'); |
177 | 177 | } |
178 | 178 | |
179 | -include DOL_DOCUMENT_ROOT . '/core/actions_changeselectedfields.inc.php'; |
|
179 | +include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php'; |
|
180 | 180 | |
181 | 181 | // Purge search criteria |
182 | 182 | if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers |
@@ -358,10 +358,10 @@ discard block |
||
358 | 358 | } |
359 | 359 | |
360 | 360 | if ($action == 'confirm_deleteline' && $confirm == "yes" && ($user->hasRight('projet', 'time') || $user->hasRight('projet', 'all', 'creer'))) { |
361 | - $object->fetchTimeSpent(GETPOSTINT('lineid')); // load properties like $object->timespent_xxx |
|
361 | + $object->fetchTimeSpent(GETPOSTINT('lineid')); // load properties like $object->timespent_xxx |
|
362 | 362 | |
363 | 363 | if (in_array($object->timespent_fk_user, $childids) || $user->hasRight('projet', 'all', 'creer')) { |
364 | - $result = $object->delTimeSpent($user); // delete line with $object->timespent_id |
|
364 | + $result = $object->delTimeSpent($user); // delete line with $object->timespent_id |
|
365 | 365 | |
366 | 366 | if ($result < 0) { |
367 | 367 | $langs->load("errors"); |
@@ -381,7 +381,7 @@ discard block |
||
381 | 381 | if (count($tasksarray) > 0) { |
382 | 382 | $id = $tasksarray[0]->id; |
383 | 383 | } else { |
384 | - header("Location: " . DOL_URL_ROOT . '/projet/tasks.php?id=' . $projectstatic->id . ($withproject ? '&withproject=1' : '') . (empty($mode) ? '' : '&mode=' . $mode)); |
|
384 | + header("Location: ".DOL_URL_ROOT.'/projet/tasks.php?id='.$projectstatic->id.($withproject ? '&withproject=1' : '').(empty($mode) ? '' : '&mode='.$mode)); |
|
385 | 385 | exit; |
386 | 386 | } |
387 | 387 | } |
@@ -418,9 +418,9 @@ discard block |
||
418 | 418 | if (!($projectstatic->thirdparty->id > 0)) { |
419 | 419 | setEventMessages($langs->trans("ThirdPartyRequiredToGenerateInvoice"), null, 'errors'); |
420 | 420 | } else { |
421 | - include_once DOL_DOCUMENT_ROOT . '/compta/facture/class/facture.class.php'; |
|
422 | - include_once DOL_DOCUMENT_ROOT . '/projet/class/project.class.php'; |
|
423 | - include_once DOL_DOCUMENT_ROOT . '/product/class/product.class.php'; |
|
421 | + include_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php'; |
|
422 | + include_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php'; |
|
423 | + include_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php'; |
|
424 | 424 | |
425 | 425 | $tmpinvoice = new Facture($db); |
426 | 426 | $tmptimespent = new Task($db); |
@@ -486,7 +486,7 @@ discard block |
||
486 | 486 | $arrayoftasks = array(); |
487 | 487 | foreach ($toselect as $key => $value) { |
488 | 488 | // Get userid, timepent |
489 | - $object->fetchTimeSpent($value); // $value is ID of 1 line in timespent table |
|
489 | + $object->fetchTimeSpent($value); // $value is ID of 1 line in timespent table |
|
490 | 490 | $arrayoftasks[$object->timespent_fk_user][(int) $object->timespent_fk_product]['timespent'] += $object->timespent_duration; |
491 | 491 | $arrayoftasks[$object->timespent_fk_user][(int) $object->timespent_fk_product]['totalvaluetodivideby3600'] += ($object->timespent_duration * $object->timespent_thm); |
492 | 492 | } |
@@ -559,7 +559,7 @@ discard block |
||
559 | 559 | } |
560 | 560 | |
561 | 561 | // Add lines |
562 | - $lineid = $tmpinvoice->addline($langs->trans("TimeSpentForInvoice", $username) . ' : ' . $qtyhourtext, $pu_htline, round($qtyhour / $prodDurationHours, 2), $txtvaline, $localtax1line, $localtax2line, ($idprodline > 0 ? $idprodline : 0), $remiseproject); |
|
562 | + $lineid = $tmpinvoice->addline($langs->trans("TimeSpentForInvoice", $username).' : '.$qtyhourtext, $pu_htline, round($qtyhour / $prodDurationHours, 2), $txtvaline, $localtax1line, $localtax2line, ($idprodline > 0 ? $idprodline : 0), $remiseproject); |
|
563 | 563 | if ($lineid < 0) { |
564 | 564 | $error++; |
565 | 565 | setEventMessages(null, $tmpinvoice->errors, 'errors'); |
@@ -592,16 +592,16 @@ discard block |
||
592 | 592 | |
593 | 593 | $arrayoftasks[$object->timespent_id]['timespent'] = $object->timespent_duration; |
594 | 594 | $arrayoftasks[$object->timespent_id]['totalvaluetodivideby3600'] = $object->timespent_duration * $object->timespent_thm; |
595 | - $arrayoftasks[$object->timespent_id]['note'] = $ftask->ref . ' - ' . $ftask->label . ' - ' . $username; |
|
595 | + $arrayoftasks[$object->timespent_id]['note'] = $ftask->ref.' - '.$ftask->label.' - '.$username; |
|
596 | 596 | $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $object->timespent_note); |
597 | 597 | |
598 | 598 | if (!empty($withdetail)) { |
599 | 599 | if (!empty($object->timespent_withhour)) { |
600 | - $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $langs->trans("Date") . ': ' . dol_print_date($object->timespent_datehour)); |
|
600 | + $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $langs->trans("Date").': '.dol_print_date($object->timespent_datehour)); |
|
601 | 601 | } else { |
602 | - $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $langs->trans("Date") . ': ' . dol_print_date($object->timespent_date)); |
|
602 | + $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $langs->trans("Date").': '.dol_print_date($object->timespent_date)); |
|
603 | 603 | } |
604 | - $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $langs->trans("Duration") . ': ' . convertSecondToTime($object->timespent_duration, 'all', $conf->global->MAIN_DURATION_OF_WORKDAY)); |
|
604 | + $arrayoftasks[$object->timespent_id]['note'] = dol_concatdesc($arrayoftasks[$object->timespent_id]['note'], $langs->trans("Duration").': '.convertSecondToTime($object->timespent_duration, 'all', $conf->global->MAIN_DURATION_OF_WORKDAY)); |
|
605 | 605 | } |
606 | 606 | $arrayoftasks[$object->timespent_id]['user'] = $object->timespent_fk_user; |
607 | 607 | $arrayoftasks[$object->timespent_id]['fk_product'] = $object->timespent_fk_product; |
@@ -679,7 +679,7 @@ discard block |
||
679 | 679 | $arrayoftasks = array(); |
680 | 680 | foreach ($toselect as $key => $value) { |
681 | 681 | // Get userid, timepent |
682 | - $object->fetchTimeSpent($value); // Call method to get list of timespent for a timespent line id (We use the utiliy method found into Task object) |
|
682 | + $object->fetchTimeSpent($value); // Call method to get list of timespent for a timespent line id (We use the utiliy method found into Task object) |
|
683 | 683 | // $object->id is now the task id |
684 | 684 | $arrayoftasks[$object->id][(int) $object->timespent_fk_product]['timespent'] += $object->timespent_duration; |
685 | 685 | $arrayoftasks[$object->id][(int) $object->timespent_fk_product]['totalvaluetodivideby3600'] += ($object->timespent_duration * $object->timespent_thm); |
@@ -755,7 +755,7 @@ discard block |
||
755 | 755 | // Add lines |
756 | 756 | $date_start = ''; |
757 | 757 | $date_end = ''; |
758 | - $lineName = $ftask->ref . ' - ' . $ftask->label; |
|
758 | + $lineName = $ftask->ref.' - '.$ftask->label; |
|
759 | 759 | $lineid = $tmpinvoice->addline($lineName, $pu_ht_for_task, price2num($qtyhour / $prodDurationHours, 'MS'), $txtvaline, $localtax1line, $localtax2line, ($idprodline > 0 ? $idprodline : 0), $remiseproject, $date_start, $date_end, 0, 0, '', 'HT', 0, 1, -1, 0, '', 0, 0, null, $pa_ht); |
760 | 760 | if ($lineid < 0) { |
761 | 761 | $error++; |
@@ -765,8 +765,8 @@ discard block |
||
765 | 765 | |
766 | 766 | if (!$error) { |
767 | 767 | // Update lineid into line of timespent |
768 | - $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'element_time SET invoice_line_id = ' . ((int) $lineid) . ', invoice_id = ' . ((int) $tmpinvoice->id); |
|
769 | - $sql .= ' WHERE rowid IN (' . $db->sanitize(implode(',', $toselect)) . ')'; |
|
768 | + $sql = 'UPDATE '.MAIN_DB_PREFIX.'element_time SET invoice_line_id = '.((int) $lineid).', invoice_id = '.((int) $tmpinvoice->id); |
|
769 | + $sql .= ' WHERE rowid IN ('.$db->sanitize(implode(',', $toselect)).')'; |
|
770 | 770 | $result = $db->query($sql); |
771 | 771 | if (!$result) { |
772 | 772 | $error++; |
@@ -802,12 +802,12 @@ discard block |
||
802 | 802 | if (!($projectstatic->thirdparty->id > 0)) { |
803 | 803 | setEventMessages($langs->trans("ThirdPartyRequiredToGenerateIntervention"), null, 'errors'); |
804 | 804 | } else { |
805 | - include_once DOL_DOCUMENT_ROOT . '/compta/facture/class/facture.class.php'; |
|
806 | - include_once DOL_DOCUMENT_ROOT . '/projet/class/project.class.php'; |
|
807 | - include_once DOL_DOCUMENT_ROOT . '/product/class/product.class.php'; |
|
805 | + include_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php'; |
|
806 | + include_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php'; |
|
807 | + include_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php'; |
|
808 | 808 | |
809 | 809 | |
810 | - require_once DOL_DOCUMENT_ROOT . '/fichinter/class/fichinter.class.php'; |
|
810 | + require_once DOL_DOCUMENT_ROOT.'/fichinter/class/fichinter.class.php'; |
|
811 | 811 | $tmpinter = new Fichinter($db); |
812 | 812 | $tmptimespent = new Task($db); |
813 | 813 | $fuser = new User($db); |
@@ -819,7 +819,7 @@ discard block |
||
819 | 819 | $tmpinter->socid = $projectstatic->thirdparty->id; |
820 | 820 | $tmpinter->date = dol_mktime(GETPOSTINT('rehour'), GETPOSTINT('remin'), GETPOSTINT('resec'), GETPOSTINT('remonth'), GETPOSTINT('reday'), GETPOSTINT('reyear')); |
821 | 821 | $tmpinter->fk_project = $projectstatic->id; |
822 | - $tmpinter->description = $projectstatic->title . (!empty($projectstatic->description) ? '-' . $projectstatic->label : ''); |
|
822 | + $tmpinter->description = $projectstatic->title.(!empty($projectstatic->description) ? '-'.$projectstatic->label : ''); |
|
823 | 823 | |
824 | 824 | if ($interToUse) { |
825 | 825 | $tmpinter->fetch($interToUse); |
@@ -852,7 +852,7 @@ discard block |
||
852 | 852 | $qtyhourtext = convertSecondToTime($value['timespent'], 'all', $conf->global->MAIN_DURATION_OF_WORKDAY); |
853 | 853 | |
854 | 854 | // Add lines |
855 | - $lineid = $tmpinter->addline($user, $tmpinter->id, $ftask->label . (!empty($value['note']) ? ' - ' . $value['note'] : ''), $value['date'], $value['timespent']); |
|
855 | + $lineid = $tmpinter->addline($user, $tmpinter->id, $ftask->label.(!empty($value['note']) ? ' - '.$value['note'] : ''), $value['date'], $value['timespent']); |
|
856 | 856 | } |
857 | 857 | } |
858 | 858 | |
@@ -883,9 +883,9 @@ discard block |
||
883 | 883 | //$result = $projectstatic->fetch($object->fk_project); |
884 | 884 | $arrayofselected = is_array($toselect) ? $toselect : array(); |
885 | 885 | |
886 | -$title = $object->ref . ' - ' . $langs->trans("TimeSpent"); |
|
886 | +$title = $object->ref.' - '.$langs->trans("TimeSpent"); |
|
887 | 887 | if (!empty($withproject)) { |
888 | - $title .= ' | ' . $langs->trans("Project") . (!empty($projectstatic->ref) ? ': ' . $projectstatic->ref : ''); |
|
888 | + $title .= ' | '.$langs->trans("Project").(!empty($projectstatic->ref) ? ': '.$projectstatic->ref : ''); |
|
889 | 889 | } |
890 | 890 | $help_url = ''; |
891 | 891 | |
@@ -934,13 +934,13 @@ discard block |
||
934 | 934 | |
935 | 935 | $param = ((!empty($mode) && $mode == 'mine') ? '&mode=mine' : ''); |
936 | 936 | if ($search_user) { |
937 | - $param .= '&search_user=' . ((int) $search_user); |
|
937 | + $param .= '&search_user='.((int) $search_user); |
|
938 | 938 | } |
939 | 939 | if ($search_month) { |
940 | - $param .= '&search_month=' . ((int) $search_month); |
|
940 | + $param .= '&search_month='.((int) $search_month); |
|
941 | 941 | } |
942 | 942 | if ($search_year) { |
943 | - $param .= '&search_year=' . ((int) $search_year); |
|
943 | + $param .= '&search_year='.((int) $search_year); |
|
944 | 944 | } |
945 | 945 | |
946 | 946 | // Project card |
@@ -952,14 +952,14 @@ discard block |
||
952 | 952 | $morehtmlref .= $projectstatic->title; |
953 | 953 | // Thirdparty |
954 | 954 | if (!empty($projectstatic->thirdparty->id) && $projectstatic->thirdparty->id > 0) { |
955 | - $morehtmlref .= '<br>' . $projectstatic->thirdparty->getNomUrl(1, 'project'); |
|
955 | + $morehtmlref .= '<br>'.$projectstatic->thirdparty->getNomUrl(1, 'project'); |
|
956 | 956 | } |
957 | 957 | $morehtmlref .= '</div>'; |
958 | 958 | |
959 | 959 | // Define a complementary filter for search of next/prev ref. |
960 | 960 | if (!$user->hasRight('projet', 'all', 'lire')) { |
961 | 961 | $objectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 0); |
962 | - $projectstatic->next_prev_filter = "rowid:IN:" . $db->sanitize(count($objectsListId) ? implode(',', array_keys($objectsListId)) : '0'); |
|
962 | + $projectstatic->next_prev_filter = "rowid:IN:".$db->sanitize(count($objectsListId) ? implode(',', array_keys($objectsListId)) : '0'); |
|
963 | 963 | } |
964 | 964 | |
965 | 965 | dol_banner_tab($projectstatic, 'project_ref', $linkback, 1, 'ref', 'ref', $morehtmlref, $param); |
@@ -977,25 +977,25 @@ discard block |
||
977 | 977 | print '</td>'; |
978 | 978 | print '<td>'; |
979 | 979 | if (getDolGlobalString('PROJECT_USE_OPPORTUNITIES')) { |
980 | - print '<input type="checkbox" disabled name="usage_opportunity"' . (GETPOSTISSET('usage_opportunity') ? (GETPOST('usage_opportunity', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_opportunity ? ' checked="checked"' : '')) . '"> '; |
|
980 | + print '<input type="checkbox" disabled name="usage_opportunity"'.(GETPOSTISSET('usage_opportunity') ? (GETPOST('usage_opportunity', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_opportunity ? ' checked="checked"' : '')).'"> '; |
|
981 | 981 | $htmltext = $langs->trans("ProjectFollowOpportunity"); |
982 | 982 | print $form->textwithpicto($langs->trans("ProjectFollowOpportunity"), $htmltext); |
983 | 983 | print '<br>'; |
984 | 984 | } |
985 | 985 | if (!getDolGlobalString('PROJECT_HIDE_TASKS')) { |
986 | - print '<input type="checkbox" disabled name="usage_task"' . (GETPOSTISSET('usage_task') ? (GETPOST('usage_task', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_task ? ' checked="checked"' : '')) . '"> '; |
|
986 | + print '<input type="checkbox" disabled name="usage_task"'.(GETPOSTISSET('usage_task') ? (GETPOST('usage_task', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_task ? ' checked="checked"' : '')).'"> '; |
|
987 | 987 | $htmltext = $langs->trans("ProjectFollowTasks"); |
988 | 988 | print $form->textwithpicto($langs->trans("ProjectFollowTasks"), $htmltext); |
989 | 989 | print '<br>'; |
990 | 990 | } |
991 | 991 | if (!getDolGlobalString('PROJECT_HIDE_TASKS') && getDolGlobalString('PROJECT_BILL_TIME_SPENT')) { |
992 | - print '<input type="checkbox" disabled name="usage_bill_time"' . (GETPOSTISSET('usage_bill_time') ? (GETPOST('usage_bill_time', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_bill_time ? ' checked="checked"' : '')) . '"> '; |
|
992 | + print '<input type="checkbox" disabled name="usage_bill_time"'.(GETPOSTISSET('usage_bill_time') ? (GETPOST('usage_bill_time', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_bill_time ? ' checked="checked"' : '')).'"> '; |
|
993 | 993 | $htmltext = $langs->trans("ProjectBillTimeDescription"); |
994 | 994 | print $form->textwithpicto($langs->trans("BillTime"), $htmltext); |
995 | 995 | print '<br>'; |
996 | 996 | } |
997 | 997 | if (isModEnabled('eventorganization')) { |
998 | - print '<input type="checkbox" disabled name="usage_organize_event"' . (GETPOSTISSET('usage_organize_event') ? (GETPOST('usage_organize_event', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_organize_event ? ' checked="checked"' : '')) . '"> '; |
|
998 | + print '<input type="checkbox" disabled name="usage_organize_event"'.(GETPOSTISSET('usage_organize_event') ? (GETPOST('usage_organize_event', 'alpha') != '' ? ' checked="checked"' : '') : ($projectstatic->usage_organize_event ? ' checked="checked"' : '')).'"> '; |
|
999 | 999 | $htmltext = $langs->trans("EventOrganizationDescriptionLong"); |
1000 | 1000 | print $form->textwithpicto($langs->trans("ManageOrganizeEvent"), $htmltext); |
1001 | 1001 | } |
@@ -1003,7 +1003,7 @@ discard block |
||
1003 | 1003 | } |
1004 | 1004 | |
1005 | 1005 | // Visibility |
1006 | - print '<tr><td class="titlefield">' . $langs->trans("Visibility") . '</td><td>'; |
|
1006 | + print '<tr><td class="titlefield">'.$langs->trans("Visibility").'</td><td>'; |
|
1007 | 1007 | if ($projectstatic->public) { |
1008 | 1008 | print img_picto($langs->trans('SharedProject'), 'world', 'class="paddingrightonly"'); |
1009 | 1009 | print $langs->trans('SharedProject'); |
@@ -1014,14 +1014,14 @@ discard block |
||
1014 | 1014 | print '</td></tr>'; |
1015 | 1015 | |
1016 | 1016 | // Budget |
1017 | - print '<tr><td>' . $langs->trans("Budget") . '</td><td>'; |
|
1017 | + print '<tr><td>'.$langs->trans("Budget").'</td><td>'; |
|
1018 | 1018 | if (!is_null($projectstatic->budget_amount) && strcmp($projectstatic->budget_amount, '')) { |
1019 | - print '<span class="amount">' . price($projectstatic->budget_amount, 0, $langs, 1, 0, 0, $conf->currency) . '</span>'; |
|
1019 | + print '<span class="amount">'.price($projectstatic->budget_amount, 0, $langs, 1, 0, 0, $conf->currency).'</span>'; |
|
1020 | 1020 | } |
1021 | 1021 | print '</td></tr>'; |
1022 | 1022 | |
1023 | 1023 | // Date start - end project |
1024 | - print '<tr><td>' . $langs->trans("Dates") . '</td><td>'; |
|
1024 | + print '<tr><td>'.$langs->trans("Dates").'</td><td>'; |
|
1025 | 1025 | $start = dol_print_date($projectstatic->date_start, 'day'); |
1026 | 1026 | print($start ? $start : '?'); |
1027 | 1027 | $end = dol_print_date($projectstatic->date_end, 'day'); |
@@ -1036,7 +1036,7 @@ discard block |
||
1036 | 1036 | $cols = 2; |
1037 | 1037 | $savobject = $object; |
1038 | 1038 | $object = $projectstatic; |
1039 | - include DOL_DOCUMENT_ROOT . '/core/tpl/extrafields_view.tpl.php'; |
|
1039 | + include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php'; |
|
1040 | 1040 | $object = $savobject; |
1041 | 1041 | |
1042 | 1042 | print '</table>'; |
@@ -1054,7 +1054,7 @@ discard block |
||
1054 | 1054 | |
1055 | 1055 | // Categories |
1056 | 1056 | if (isModEnabled('category')) { |
1057 | - print '<tr><td class="valignmiddle">' . $langs->trans("Categories") . '</td><td>'; |
|
1057 | + print '<tr><td class="valignmiddle">'.$langs->trans("Categories").'</td><td>'; |
|
1058 | 1058 | print $form->showCategories($projectstatic->id, 'project', 1); |
1059 | 1059 | print "</td></tr>"; |
1060 | 1060 | } |
@@ -1083,12 +1083,12 @@ discard block |
||
1083 | 1083 | |
1084 | 1084 | if (!empty($projectidforalltimes)) { |
1085 | 1085 | // We are on tab 'Time Spent' of project |
1086 | - $backtourl = $_SERVER['PHP_SELF'] . '?projectid=' . $projectstatic->id . ($withproject ? '&withproject=1' : ''); |
|
1087 | - $linktocreatetimeUrl = $_SERVER['PHP_SELF'] . '?' . ($withproject ? 'withproject=1' : '') . '&projectid=' . $projectstatic->id . '&action=createtime&token=' . newToken() . $param . '&backtopage=' . urlencode($backtourl); |
|
1086 | + $backtourl = $_SERVER['PHP_SELF'].'?projectid='.$projectstatic->id.($withproject ? '&withproject=1' : ''); |
|
1087 | + $linktocreatetimeUrl = $_SERVER['PHP_SELF'].'?'.($withproject ? 'withproject=1' : '').'&projectid='.$projectstatic->id.'&action=createtime&token='.newToken().$param.'&backtopage='.urlencode($backtourl); |
|
1088 | 1088 | } else { |
1089 | 1089 | // We are on tab 'Time Spent' of task |
1090 | - $backtourl = $_SERVER['PHP_SELF'] . '?id=' . $object->id . ($withproject ? '&withproject=1' : ''); |
|
1091 | - $linktocreatetimeUrl = $_SERVER['PHP_SELF'] . '?' . ($withproject ? 'withproject=1' : '') . ($object->id > 0 ? '&id=' . $object->id : '&projectid=' . $projectstatic->id) . '&action=createtime&token=' . newToken() . $param . '&backtopage=' . urlencode($backtourl); |
|
1090 | + $backtourl = $_SERVER['PHP_SELF'].'?id='.$object->id.($withproject ? '&withproject=1' : ''); |
|
1091 | + $linktocreatetimeUrl = $_SERVER['PHP_SELF'].'?'.($withproject ? 'withproject=1' : '').($object->id > 0 ? '&id='.$object->id : '&projectid='.$projectstatic->id).'&action=createtime&token='.newToken().$param.'&backtopage='.urlencode($backtourl); |
|
1092 | 1092 | } |
1093 | 1093 | } else { |
1094 | 1094 | $linktocreatetimeBtnStatus = -2; |
@@ -1133,19 +1133,19 @@ discard block |
||
1133 | 1133 | print dol_get_fiche_head($head, 'task_time', $langs->trans("Task"), -1, 'projecttask', 0, '', 'reposition'); |
1134 | 1134 | |
1135 | 1135 | if ($action == 'deleteline') { |
1136 | - $urlafterconfirm = $_SERVER["PHP_SELF"] . "?" . ($object->id > 0 ? "id=" . $object->id : 'projectid=' . $projectstatic->id) . '&lineid=' . GETPOSTINT("lineid") . ($withproject ? '&withproject=1' : ''); |
|
1136 | + $urlafterconfirm = $_SERVER["PHP_SELF"]."?".($object->id > 0 ? "id=".$object->id : 'projectid='.$projectstatic->id).'&lineid='.GETPOSTINT("lineid").($withproject ? '&withproject=1' : ''); |
|
1137 | 1137 | print $form->formconfirm($urlafterconfirm, $langs->trans("DeleteATimeSpent"), $langs->trans("ConfirmDeleteATimeSpent"), "confirm_deleteline", '', '', 1); |
1138 | 1138 | } |
1139 | 1139 | |
1140 | 1140 | $param = ($withproject ? '&withproject=1' : ''); |
1141 | - $param .= ($param ? '&' : '') . 'id=' . $object->id; // ID of task |
|
1142 | - $linkback = $withproject ? '<a href="' . DOL_URL_ROOT . '/projet/tasks.php?id=' . $projectstatic->id . '">' . $langs->trans("BackToList") . '</a>' : ''; |
|
1141 | + $param .= ($param ? '&' : '').'id='.$object->id; // ID of task |
|
1142 | + $linkback = $withproject ? '<a href="'.DOL_URL_ROOT.'/projet/tasks.php?id='.$projectstatic->id.'">'.$langs->trans("BackToList").'</a>' : ''; |
|
1143 | 1143 | |
1144 | 1144 | if (!GETPOST('withproject') || empty($projectstatic->id)) { |
1145 | 1145 | $projectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 1); |
1146 | - $object->next_prev_filter = "fk_projet:IN:" . $db->sanitize($projectsListId); |
|
1146 | + $object->next_prev_filter = "fk_projet:IN:".$db->sanitize($projectsListId); |
|
1147 | 1147 | } else { |
1148 | - $object->next_prev_filter = "fk_projet:=:" . ((int) $projectstatic->id); |
|
1148 | + $object->next_prev_filter = "fk_projet:=:".((int) $projectstatic->id); |
|
1149 | 1149 | } |
1150 | 1150 | |
1151 | 1151 | $morehtmlref = ''; |
@@ -1153,12 +1153,12 @@ discard block |
||
1153 | 1153 | // Project |
1154 | 1154 | if (empty($withproject)) { |
1155 | 1155 | $morehtmlref .= '<div class="refidno">'; |
1156 | - $morehtmlref .= $langs->trans("Project") . ': '; |
|
1156 | + $morehtmlref .= $langs->trans("Project").': '; |
|
1157 | 1157 | $morehtmlref .= $projectstatic->getNomUrl(1); |
1158 | 1158 | $morehtmlref .= '<br>'; |
1159 | 1159 | |
1160 | 1160 | // Third party |
1161 | - $morehtmlref .= $langs->trans("ThirdParty") . ': '; |
|
1161 | + $morehtmlref .= $langs->trans("ThirdParty").': '; |
|
1162 | 1162 | if (!empty($projectstatic->thirdparty) && is_object($projectstatic->thirdparty)) { |
1163 | 1163 | $morehtmlref .= $projectstatic->thirdparty->getNomUrl(1); |
1164 | 1164 | } |
@@ -1174,7 +1174,7 @@ discard block |
||
1174 | 1174 | print '<table class="border centpercent tableforfield">'; |
1175 | 1175 | |
1176 | 1176 | // Task parent |
1177 | - print '<tr><td>' . $langs->trans("ChildOfTask") . '</td><td>'; |
|
1177 | + print '<tr><td>'.$langs->trans("ChildOfTask").'</td><td>'; |
|
1178 | 1178 | if ($object->fk_task_parent > 0) { |
1179 | 1179 | $tasktmp = new Task($db); |
1180 | 1180 | $tasktmp->fetch($object->fk_task_parent); |
@@ -1183,7 +1183,7 @@ discard block |
||
1183 | 1183 | print '</td></tr>'; |
1184 | 1184 | |
1185 | 1185 | // Date start - Date end task |
1186 | - print '<tr><td class="titlefield">' . $langs->trans("DateStart") . ' - ' . $langs->trans("Deadline") . '</td><td>'; |
|
1186 | + print '<tr><td class="titlefield">'.$langs->trans("DateStart").' - '.$langs->trans("Deadline").'</td><td>'; |
|
1187 | 1187 | $start = dol_print_date($object->date_start, 'dayhour'); |
1188 | 1188 | print($start ? $start : '?'); |
1189 | 1189 | $end = dol_print_date($object->date_end, 'dayhour'); |
@@ -1195,7 +1195,7 @@ discard block |
||
1195 | 1195 | print '</td></tr>'; |
1196 | 1196 | |
1197 | 1197 | // Planned workload |
1198 | - print '<tr><td>' . $langs->trans("PlannedWorkload") . '</td><td>'; |
|
1198 | + print '<tr><td>'.$langs->trans("PlannedWorkload").'</td><td>'; |
|
1199 | 1199 | if ($object->planned_workload) { |
1200 | 1200 | print convertSecondToTime($object->planned_workload, 'allhourmin'); |
1201 | 1201 | } |
@@ -1210,21 +1210,21 @@ discard block |
||
1210 | 1210 | print '<table class="border tableforfield centpercent">'; |
1211 | 1211 | |
1212 | 1212 | // Progress declared |
1213 | - print '<tr><td class="titlefield">' . $langs->trans("ProgressDeclared") . '</td><td>'; |
|
1214 | - print $object->progress != '' ? $object->progress . ' %' : ''; |
|
1213 | + print '<tr><td class="titlefield">'.$langs->trans("ProgressDeclared").'</td><td>'; |
|
1214 | + print $object->progress != '' ? $object->progress.' %' : ''; |
|
1215 | 1215 | print '</td></tr>'; |
1216 | 1216 | |
1217 | 1217 | // Progress calculated |
1218 | - print '<tr><td>' . $langs->trans("ProgressCalculated") . '</td><td>'; |
|
1218 | + print '<tr><td>'.$langs->trans("ProgressCalculated").'</td><td>'; |
|
1219 | 1219 | if ($object->planned_workload) { |
1220 | 1220 | $tmparray = $object->getSummaryOfTimeSpent(); |
1221 | 1221 | if ($tmparray['total_duration'] > 0) { |
1222 | - print round($tmparray['total_duration'] / $object->planned_workload * 100, 2) . ' %'; |
|
1222 | + print round($tmparray['total_duration'] / $object->planned_workload * 100, 2).' %'; |
|
1223 | 1223 | } else { |
1224 | 1224 | print '0 %'; |
1225 | 1225 | } |
1226 | 1226 | } else { |
1227 | - print '<span class="opacitymedium">' . $langs->trans("WorkloadNotDefined") . '</span>'; |
|
1227 | + print '<span class="opacitymedium">'.$langs->trans("WorkloadNotDefined").'</span>'; |
|
1228 | 1228 | } |
1229 | 1229 | print '</td>'; |
1230 | 1230 | |
@@ -1240,7 +1240,7 @@ discard block |
||
1240 | 1240 | print dol_get_fiche_end(); |
1241 | 1241 | } else { |
1242 | 1242 | if ($action == 'deleteline') { |
1243 | - $urlafterconfirm = $_SERVER["PHP_SELF"] . "?" . ($object->id > 0 ? "id=" . $object->id : 'projectid=' . $projectstatic->id) . '&lineid=' . GETPOSTINT("lineid") . ($withproject ? '&withproject=1' : ''); |
|
1243 | + $urlafterconfirm = $_SERVER["PHP_SELF"]."?".($object->id > 0 ? "id=".$object->id : 'projectid='.$projectstatic->id).'&lineid='.GETPOSTINT("lineid").($withproject ? '&withproject=1' : ''); |
|
1244 | 1244 | print $form->formconfirm($urlafterconfirm, $langs->trans("DeleteATimeSpent"), $langs->trans("ConfirmDeleteATimeSpent"), "confirm_deleteline", '', '', 1); |
1245 | 1245 | } |
1246 | 1246 | } |
@@ -1254,7 +1254,7 @@ discard block |
||
1254 | 1254 | |
1255 | 1255 | if ($action == 'deleteline' && !empty($projectidforalltimes)) { |
1256 | 1256 | // We must use projectidprojectid if on list of timespent of project and id=taskid if on list of timespent of a task |
1257 | - $urlafterconfirm = $_SERVER["PHP_SELF"] . "?" . ($projectstatic->id > 0 ? 'projectid=' . $projectstatic->id : ($object->id > 0 ? "id=" . $object->id : '')) . '&lineid=' . GETPOSTINT('lineid') . ($withproject ? '&withproject=1' : '') . "&contextpage=" . urlencode($contextpage); |
|
1257 | + $urlafterconfirm = $_SERVER["PHP_SELF"]."?".($projectstatic->id > 0 ? 'projectid='.$projectstatic->id : ($object->id > 0 ? "id=".$object->id : '')).'&lineid='.GETPOSTINT('lineid').($withproject ? '&withproject=1' : '')."&contextpage=".urlencode($contextpage); |
|
1258 | 1258 | $formconfirm = $form->formconfirm($urlafterconfirm, $langs->trans("DeleteATimeSpent"), $langs->trans("ConfirmDeleteATimeSpent"), "confirm_deleteline", '', '', 1); |
1259 | 1259 | } |
1260 | 1260 | |
@@ -1273,10 +1273,10 @@ discard block |
||
1273 | 1273 | // Definition of fields for list |
1274 | 1274 | $arrayfields = array(); |
1275 | 1275 | $arrayfields['t.element_date'] = array('label' => $langs->trans("Date"), 'checked' => 1); |
1276 | - $arrayfields['p.fk_soc'] = array('label' => $langs->trans("ThirdParty"), 'type' => 'integer:Societe:/societe/class/societe.class.php:1','checked' => 1); |
|
1276 | + $arrayfields['p.fk_soc'] = array('label' => $langs->trans("ThirdParty"), 'type' => 'integer:Societe:/societe/class/societe.class.php:1', 'checked' => 1); |
|
1277 | 1277 | $arrayfields['s.name_alias'] = array('label' => $langs->trans("AliasNameShort"), 'type' => 'integer:Societe:/societe/class/societe.class.php:1'); |
1278 | 1278 | if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) { // Not a dedicated task |
1279 | - if (! empty($allprojectforuser)) { |
|
1279 | + if (!empty($allprojectforuser)) { |
|
1280 | 1280 | $arrayfields['p.project_ref'] = ['label' => $langs->trans('RefProject'), 'checked' => 1]; |
1281 | 1281 | $arrayfields['p.project_label'] = ['label' => $langs->trans('ProjectLabel'), 'checked' => 1]; |
1282 | 1282 | } |
@@ -1292,83 +1292,83 @@ discard block |
||
1292 | 1292 | $arrayfields['value'] = array('label' => $langs->trans("Value"), 'checked' => 1, 'enabled' => isModEnabled("salaries")); |
1293 | 1293 | $arrayfields['valuebilled'] = array('label' => $langs->trans("Billed"), 'checked' => 1, 'enabled' => (((getDolGlobalInt('PROJECT_HIDE_TASKS') || !getDolGlobalInt('PROJECT_BILL_TIME_SPENT')) ? 0 : 1) && $projectstatic->usage_bill_time)); |
1294 | 1294 | // Extra fields |
1295 | - include DOL_DOCUMENT_ROOT . '/core/tpl/extrafields_list_array_fields.tpl.php'; |
|
1295 | + include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php'; |
|
1296 | 1296 | |
1297 | 1297 | $arrayfields = dol_sort_array($arrayfields, 'position'); |
1298 | - '@phan-var-force array<string,array{label:string,checked?:int<0,1>,position?:int,help?:string}> $arrayfields'; // dol_sort_array looses type for Phan |
|
1298 | + '@phan-var-force array<string,array{label:string,checked?:int<0,1>,position?:int,help?:string}> $arrayfields'; // dol_sort_array looses type for Phan |
|
1299 | 1299 | |
1300 | 1300 | $param = ''; |
1301 | 1301 | if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) { |
1302 | - $param .= '&contextpage=' . urlencode($contextpage); |
|
1302 | + $param .= '&contextpage='.urlencode($contextpage); |
|
1303 | 1303 | } |
1304 | 1304 | if ($limit > 0 && $limit != $conf->liste_limit) { |
1305 | 1305 | $param .= '&limit='.((int) $limit); |
1306 | 1306 | } |
1307 | 1307 | if ($search_month > 0) { |
1308 | - $param .= '&search_month=' . urlencode((string) ($search_month)); |
|
1308 | + $param .= '&search_month='.urlencode((string) ($search_month)); |
|
1309 | 1309 | } |
1310 | 1310 | if ($search_year > 0) { |
1311 | - $param .= '&search_year=' . urlencode((string) ($search_year)); |
|
1311 | + $param .= '&search_year='.urlencode((string) ($search_year)); |
|
1312 | 1312 | } |
1313 | 1313 | if (!empty($search_user)) { // We keep param if -1 because default value is forced to user id if not set |
1314 | 1314 | $param .= '&search_user='.urlencode($search_user); |
1315 | 1315 | } |
1316 | 1316 | if ($search_task_ref != '') { |
1317 | - $param .= '&search_task_ref=' . urlencode($search_task_ref); |
|
1317 | + $param .= '&search_task_ref='.urlencode($search_task_ref); |
|
1318 | 1318 | } |
1319 | 1319 | if ($search_company != '') { |
1320 | - $param .= '&$search_company=' . urlencode($search_company); |
|
1320 | + $param .= '&$search_company='.urlencode($search_company); |
|
1321 | 1321 | } |
1322 | 1322 | if ($search_company_alias != '') { |
1323 | - $param .= '&$search_company_alias=' . urlencode($search_company_alias); |
|
1323 | + $param .= '&$search_company_alias='.urlencode($search_company_alias); |
|
1324 | 1324 | } |
1325 | 1325 | if ($search_project_ref != '') { |
1326 | - $param .= '&$search_project_ref=' . urlencode($search_project_ref); |
|
1326 | + $param .= '&$search_project_ref='.urlencode($search_project_ref); |
|
1327 | 1327 | } |
1328 | 1328 | if ($search_project_label != '') { |
1329 | - $param .= '&$search_project_label=' . urlencode($search_project_label); |
|
1329 | + $param .= '&$search_project_label='.urlencode($search_project_label); |
|
1330 | 1330 | } |
1331 | 1331 | if ($search_task_label != '') { |
1332 | - $param .= '&search_task_label=' . urlencode($search_task_label); |
|
1332 | + $param .= '&search_task_label='.urlencode($search_task_label); |
|
1333 | 1333 | } |
1334 | 1334 | if ($search_note != '') { |
1335 | - $param .= '&search_note=' . urlencode($search_note); |
|
1335 | + $param .= '&search_note='.urlencode($search_note); |
|
1336 | 1336 | } |
1337 | 1337 | if ($search_duration != '') { |
1338 | - $param .= '&search_field2=' . urlencode((string) ($search_duration)); |
|
1338 | + $param .= '&search_field2='.urlencode((string) ($search_duration)); |
|
1339 | 1339 | } |
1340 | 1340 | if ($optioncss != '') { |
1341 | - $param .= '&optioncss=' . urlencode($optioncss); |
|
1341 | + $param .= '&optioncss='.urlencode($optioncss); |
|
1342 | 1342 | } |
1343 | 1343 | if ($search_date_startday) { |
1344 | - $param .= '&search_date_startday=' . urlencode((string) ($search_date_startday)); |
|
1344 | + $param .= '&search_date_startday='.urlencode((string) ($search_date_startday)); |
|
1345 | 1345 | } |
1346 | 1346 | if ($search_date_startmonth) { |
1347 | - $param .= '&search_date_startmonth=' . urlencode((string) ($search_date_startmonth)); |
|
1347 | + $param .= '&search_date_startmonth='.urlencode((string) ($search_date_startmonth)); |
|
1348 | 1348 | } |
1349 | 1349 | if ($search_date_startyear) { |
1350 | - $param .= '&search_date_startyear=' . urlencode((string) ($search_date_startyear)); |
|
1350 | + $param .= '&search_date_startyear='.urlencode((string) ($search_date_startyear)); |
|
1351 | 1351 | } |
1352 | 1352 | if ($search_date_endday) { |
1353 | - $param .= '&search_date_endday=' . urlencode((string) ($search_date_endday)); |
|
1353 | + $param .= '&search_date_endday='.urlencode((string) ($search_date_endday)); |
|
1354 | 1354 | } |
1355 | 1355 | if ($search_date_endmonth) { |
1356 | - $param .= '&search_date_endmonth=' . urlencode((string) ($search_date_endmonth)); |
|
1356 | + $param .= '&search_date_endmonth='.urlencode((string) ($search_date_endmonth)); |
|
1357 | 1357 | } |
1358 | 1358 | if ($search_date_endyear) { |
1359 | - $param .= '&search_date_endyear=' . urlencode((string) ($search_date_endyear)); |
|
1359 | + $param .= '&search_date_endyear='.urlencode((string) ($search_date_endyear)); |
|
1360 | 1360 | } |
1361 | 1361 | if ($search_timespent_starthour) { |
1362 | - $param .= '&search_timespent_duration_starthour=' . urlencode((string) ($search_timespent_starthour)); |
|
1362 | + $param .= '&search_timespent_duration_starthour='.urlencode((string) ($search_timespent_starthour)); |
|
1363 | 1363 | } |
1364 | 1364 | if ($search_timespent_startmin) { |
1365 | - $param .= '&search_timespent_duration_startmin=' . urlencode((string) ($search_timespent_startmin)); |
|
1365 | + $param .= '&search_timespent_duration_startmin='.urlencode((string) ($search_timespent_startmin)); |
|
1366 | 1366 | } |
1367 | 1367 | if ($search_timespent_endhour) { |
1368 | - $param .= '&search_timespent_duration_endhour=' . urlencode((string) ($search_timespent_endhour)); |
|
1368 | + $param .= '&search_timespent_duration_endhour='.urlencode((string) ($search_timespent_endhour)); |
|
1369 | 1369 | } |
1370 | 1370 | if ($search_timespent_endmin) { |
1371 | - $param .= '&search_timespent_duration_endmin=' . urlencode((string) ($search_timespent_endmin)); |
|
1371 | + $param .= '&search_timespent_duration_endmin='.urlencode((string) ($search_timespent_endmin)); |
|
1372 | 1372 | } |
1373 | 1373 | |
1374 | 1374 | /* |
@@ -1376,24 +1376,24 @@ discard block |
||
1376 | 1376 | include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php'; |
1377 | 1377 | */ |
1378 | 1378 | if ($id) { |
1379 | - $param .= '&id=' . urlencode((string) ($id)); |
|
1379 | + $param .= '&id='.urlencode((string) ($id)); |
|
1380 | 1380 | } |
1381 | 1381 | if ($projectid) { |
1382 | - $param .= '&projectid=' . urlencode((string) ($projectid)); |
|
1382 | + $param .= '&projectid='.urlencode((string) ($projectid)); |
|
1383 | 1383 | } |
1384 | 1384 | if ($withproject) { |
1385 | - $param .= '&withproject=' . urlencode((string) ($withproject)); |
|
1385 | + $param .= '&withproject='.urlencode((string) ($withproject)); |
|
1386 | 1386 | } |
1387 | 1387 | // Add $param from hooks |
1388 | 1388 | $parameters = array('param' => &$param); |
1389 | 1389 | $reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook |
1390 | 1390 | $param .= $hookmanager->resPrint; |
1391 | 1391 | |
1392 | - print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . '">'; |
|
1392 | + print '<form method="POST" action="'.$_SERVER["PHP_SELF"].'">'; |
|
1393 | 1393 | if ($optioncss != '') { |
1394 | - print '<input type="hidden" name="optioncss" value="' . $optioncss . '">'; |
|
1394 | + print '<input type="hidden" name="optioncss" value="'.$optioncss.'">'; |
|
1395 | 1395 | } |
1396 | - print '<input type="hidden" name="token" value="' . newToken() . '">'; |
|
1396 | + print '<input type="hidden" name="token" value="'.newToken().'">'; |
|
1397 | 1397 | print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">'; |
1398 | 1398 | if ($action == 'editline') { |
1399 | 1399 | print '<input type="hidden" name="action" value="updateline">'; |
@@ -1408,13 +1408,13 @@ discard block |
||
1408 | 1408 | } else { |
1409 | 1409 | print '<input type="hidden" name="action" value="list">'; |
1410 | 1410 | } |
1411 | - print '<input type="hidden" name="sortfield" value="' . $sortfield . '">'; |
|
1412 | - print '<input type="hidden" name="sortorder" value="' . $sortorder . '">'; |
|
1411 | + print '<input type="hidden" name="sortfield" value="'.$sortfield.'">'; |
|
1412 | + print '<input type="hidden" name="sortorder" value="'.$sortorder.'">'; |
|
1413 | 1413 | |
1414 | - print '<input type="hidden" name="id" value="' . $id . '">'; |
|
1415 | - print '<input type="hidden" name="projectid" value="' . $projectidforalltimes . '">'; |
|
1416 | - print '<input type="hidden" name="withproject" value="' . $withproject . '">'; |
|
1417 | - print '<input type="hidden" name="tab" value="' . $tab . '">'; |
|
1414 | + print '<input type="hidden" name="id" value="'.$id.'">'; |
|
1415 | + print '<input type="hidden" name="projectid" value="'.$projectidforalltimes.'">'; |
|
1416 | + print '<input type="hidden" name="withproject" value="'.$withproject.'">'; |
|
1417 | + print '<input type="hidden" name="tab" value="'.$tab.'">'; |
|
1418 | 1418 | print '<input type="hidden" name="page_y" value="">'; |
1419 | 1419 | |
1420 | 1420 | // Form to convert time spent into invoice |
@@ -1441,7 +1441,7 @@ discard block |
||
1441 | 1441 | 'onelineperperiod' => 'OneLinePerTimeSpentLine', |
1442 | 1442 | ); |
1443 | 1443 | print $form->selectarray('generateinvoicemode', $tmparray, 'onelineperuser', 0, 0, 0, '', 1); |
1444 | - print "\n" . '<script type="text/javascript">'; |
|
1444 | + print "\n".'<script type="text/javascript">'; |
|
1445 | 1445 | print ' |
1446 | 1446 | $(document).ready(function () { |
1447 | 1447 | setDetailVisibility(); |
@@ -1458,8 +1458,8 @@ discard block |
||
1458 | 1458 | } |
1459 | 1459 | }); |
1460 | 1460 | '; |
1461 | - print '</script>' . "\n"; |
|
1462 | - print '<span style="display:none" id="detail_time_duration"><input type="checkbox" value="detail" name="detail_time_duration"/>' . $langs->trans('AddDetailDateAndDuration') . '</span>'; |
|
1461 | + print '</script>'."\n"; |
|
1462 | + print '<span style="display:none" id="detail_time_duration"><input type="checkbox" value="detail" name="detail_time_duration"/>'.$langs->trans('AddDetailDateAndDuration').'</span>'; |
|
1463 | 1463 | print '</td>'; |
1464 | 1464 | print '</tr>'; |
1465 | 1465 | |
@@ -1509,14 +1509,14 @@ discard block |
||
1509 | 1509 | |
1510 | 1510 | print '<br>'; |
1511 | 1511 | print '<div class="center">'; |
1512 | - print '<input type="submit" class="button" id="createbills" name="createbills" value="' . $langs->trans('GenerateBill') . '"> '; |
|
1513 | - print '<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="' . $langs->trans("Cancel") . '">'; |
|
1512 | + print '<input type="submit" class="button" id="createbills" name="createbills" value="'.$langs->trans('GenerateBill').'"> '; |
|
1513 | + print '<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans("Cancel").'">'; |
|
1514 | 1514 | print '</div>'; |
1515 | 1515 | print '<br>'; |
1516 | 1516 | } else { |
1517 | - print '<div class="warning">' . $langs->trans("ThirdPartyRequiredToGenerateInvoice") . '</div>'; |
|
1517 | + print '<div class="warning">'.$langs->trans("ThirdPartyRequiredToGenerateInvoice").'</div>'; |
|
1518 | 1518 | print '<div class="center">'; |
1519 | - print '<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="' . $langs->trans("Cancel") . '">'; |
|
1519 | + print '<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans("Cancel").'">'; |
|
1520 | 1520 | print '</div>'; |
1521 | 1521 | $massaction = ''; |
1522 | 1522 | } |
@@ -1529,7 +1529,7 @@ discard block |
||
1529 | 1529 | print '<table class="noborder centpercent">'; |
1530 | 1530 | print '<tr>'; |
1531 | 1531 | print '<td class="titlefield">'; |
1532 | - print img_picto('', 'intervention', 'class="pictofixedwidth"') . $langs->trans('InterToUse'); |
|
1532 | + print img_picto('', 'intervention', 'class="pictofixedwidth"').$langs->trans('InterToUse'); |
|
1533 | 1533 | print '</td>'; |
1534 | 1534 | print '<td>'; |
1535 | 1535 | $forminter = new FormIntervention($db); |
@@ -1539,14 +1539,14 @@ discard block |
||
1539 | 1539 | print '</table>'; |
1540 | 1540 | |
1541 | 1541 | print '<div class="center">'; |
1542 | - print '<input type="submit" class="button" id="createinter" name="createinter" value="' . $langs->trans('GenerateInter') . '"> '; |
|
1543 | - print '<input type="submit" class="button" id="cancel" name="cancel" value="' . $langs->trans('Cancel') . '">'; |
|
1542 | + print '<input type="submit" class="button" id="createinter" name="createinter" value="'.$langs->trans('GenerateInter').'"> '; |
|
1543 | + print '<input type="submit" class="button" id="cancel" name="cancel" value="'.$langs->trans('Cancel').'">'; |
|
1544 | 1544 | print '</div>'; |
1545 | 1545 | print '<br>'; |
1546 | 1546 | } else { |
1547 | - print '<div class="warning">' . $langs->trans("ThirdPartyRequiredToGenerateIntervention") . '</div>'; |
|
1547 | + print '<div class="warning">'.$langs->trans("ThirdPartyRequiredToGenerateIntervention").'</div>'; |
|
1548 | 1548 | print '<div class="center">'; |
1549 | - print '<input type="submit" class="button" id="cancel" name="cancel" value="' . $langs->trans('Cancel') . '">'; |
|
1549 | + print '<input type="submit" class="button" id="cancel" name="cancel" value="'.$langs->trans('Cancel').'">'; |
|
1550 | 1550 | print '</div>'; |
1551 | 1551 | $massaction = ''; |
1552 | 1552 | } |
@@ -1616,14 +1616,14 @@ discard block |
||
1616 | 1616 | $sql .= " AND t.fk_element =".((int) $object->id); |
1617 | 1617 | } elseif (!empty($projectidforalltimes)) { |
1618 | 1618 | // Limit on one project |
1619 | - $sql .= " AND pt.fk_projet IN (" . $db->sanitize($projectidforalltimes) . ")"; |
|
1619 | + $sql .= " AND pt.fk_projet IN (".$db->sanitize($projectidforalltimes).")"; |
|
1620 | 1620 | } elseif (!empty($allprojectforuser)) { |
1621 | 1621 | // Limit on on user |
1622 | 1622 | if (empty($search_user)) { |
1623 | 1623 | $search_user = $user->id; |
1624 | 1624 | } |
1625 | 1625 | if ($search_user > 0) { |
1626 | - $sql .= " AND t.fk_user = " . ((int) $search_user); |
|
1626 | + $sql .= " AND t.fk_user = ".((int) $search_user); |
|
1627 | 1627 | } |
1628 | 1628 | } |
1629 | 1629 | |
@@ -1676,13 +1676,13 @@ discard block |
||
1676 | 1676 | if ($search_timespent_starthour || $search_timespent_startmin) { |
1677 | 1677 | $timespent_duration_start = $search_timespent_starthour * 60 * 60; // We store duration in seconds |
1678 | 1678 | $timespent_duration_start += ($search_timespent_startmin ? $search_timespent_startmin : 0) * 60; // We store duration in seconds |
1679 | - $sql .= " AND t.element_duration >= " . $timespent_duration_start; |
|
1679 | + $sql .= " AND t.element_duration >= ".$timespent_duration_start; |
|
1680 | 1680 | } |
1681 | 1681 | |
1682 | 1682 | if ($search_timespent_endhour || $search_timespent_endmin) { |
1683 | 1683 | $timespent_duration_end = $search_timespent_endhour * 60 * 60; // We store duration in seconds |
1684 | 1684 | $timespent_duration_end += ($search_timespent_endmin ? $search_timespent_endmin : 0) * 60; // We store duration in seconds |
1685 | - $sql .= " AND t.element_duration <= " . $timespent_duration_end; |
|
1685 | + $sql .= " AND t.element_duration <= ".$timespent_duration_end; |
|
1686 | 1686 | } |
1687 | 1687 | } |
1688 | 1688 | |
@@ -1730,13 +1730,13 @@ discard block |
||
1730 | 1730 | |
1731 | 1731 | if ($num >= 0) { |
1732 | 1732 | if (!empty($projectidforalltimes)) { |
1733 | - print '<!-- List of time spent for project -->' . "\n"; |
|
1733 | + print '<!-- List of time spent for project -->'."\n"; |
|
1734 | 1734 | |
1735 | 1735 | $title = $langs->trans("ListTaskTimeUserProject"); |
1736 | 1736 | |
1737 | 1737 | print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'clock', 0, $linktocreatetime, '', $limit, 0, 0, 1); |
1738 | 1738 | } else { |
1739 | - print '<!-- List of time spent -->' . "\n"; |
|
1739 | + print '<!-- List of time spent -->'."\n"; |
|
1740 | 1740 | |
1741 | 1741 | $title = $langs->trans("ListTaskTimeForTask"); |
1742 | 1742 | |
@@ -1758,26 +1758,26 @@ discard block |
||
1758 | 1758 | * Form to add a new line of time spent |
1759 | 1759 | */ |
1760 | 1760 | if ($action == 'createtime' && $user->hasRight('projet', 'time')) { |
1761 | - print '<!-- table to add time spent -->' . "\n"; |
|
1761 | + print '<!-- table to add time spent -->'."\n"; |
|
1762 | 1762 | if (!empty($id)) { |
1763 | - print '<input type="hidden" name="taskid" value="' . $id . '">'; |
|
1763 | + print '<input type="hidden" name="taskid" value="'.$id.'">'; |
|
1764 | 1764 | } |
1765 | 1765 | |
1766 | 1766 | print '<div class="div-table-responsive-no-min">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table |
1767 | 1767 | print '<table class="noborder nohover centpercent">'; |
1768 | 1768 | |
1769 | 1769 | print '<tr class="liste_titre">'; |
1770 | - print '<td>' . $langs->trans("Date") . '</td>'; |
|
1770 | + print '<td>'.$langs->trans("Date").'</td>'; |
|
1771 | 1771 | if (!empty($allprojectforuser)) { |
1772 | - print '<td>' . $langs->trans("Project") . '</td>'; |
|
1772 | + print '<td>'.$langs->trans("Project").'</td>'; |
|
1773 | 1773 | } |
1774 | 1774 | if (empty($id)) { |
1775 | - print '<td>' . $langs->trans("Task") . '</td>'; |
|
1775 | + print '<td>'.$langs->trans("Task").'</td>'; |
|
1776 | 1776 | } |
1777 | - print '<td>' . $langs->trans("By") . '</td>'; |
|
1778 | - print '<td>' . $langs->trans("Note") . '</td>'; |
|
1779 | - print '<td>' . $langs->trans("NewTimeSpent") . '</td>'; |
|
1780 | - print '<td>' . $langs->trans("ProgressDeclared") . '</td>'; |
|
1777 | + print '<td>'.$langs->trans("By").'</td>'; |
|
1778 | + print '<td>'.$langs->trans("Note").'</td>'; |
|
1779 | + print '<td>'.$langs->trans("NewTimeSpent").'</td>'; |
|
1780 | + print '<td>'.$langs->trans("ProgressDeclared").'</td>'; |
|
1781 | 1781 | if (!getDolGlobalString('PROJECT_HIDE_TASKS') && getDolGlobalString('PROJECT_BILL_TIME_SPENT')) { |
1782 | 1782 | print '<td></td>'; |
1783 | 1783 | |
@@ -1831,14 +1831,14 @@ discard block |
||
1831 | 1831 | print $form->select_dolusers((GETPOSTINT('userid') ? GETPOSTINT('userid') : $userid), 'userid', 0, '', 0, '', $contactsofproject, 0, 0, 0, '', 0, $langs->trans("ResourceNotAssignedToProject"), 'minwidth150imp maxwidth200'); |
1832 | 1832 | } else { |
1833 | 1833 | if ($nboftasks) { |
1834 | - print img_error($langs->trans('FirstAddRessourceToAllocateTime')) . ' ' . $langs->trans('FirstAddRessourceToAllocateTime'); |
|
1834 | + print img_error($langs->trans('FirstAddRessourceToAllocateTime')).' '.$langs->trans('FirstAddRessourceToAllocateTime'); |
|
1835 | 1835 | } |
1836 | 1836 | } |
1837 | 1837 | print '</td>'; |
1838 | 1838 | |
1839 | 1839 | // Note |
1840 | 1840 | print '<td>'; |
1841 | - print '<textarea name="timespent_note" class="maxwidth100onsmartphone" rows="' . ROWS_2 . '">' . (GETPOST('timespent_note') ? GETPOST('timespent_note') : '') . '</textarea>'; |
|
1841 | + print '<textarea name="timespent_note" class="maxwidth100onsmartphone" rows="'.ROWS_2.'">'.(GETPOST('timespent_note') ? GETPOST('timespent_note') : '').'</textarea>'; |
|
1842 | 1842 | print '</td>'; |
1843 | 1843 | |
1844 | 1844 | // Duration - Time spent |
@@ -1906,7 +1906,7 @@ discard block |
||
1906 | 1906 | $selectedfields .= (is_array($arrayofmassactions) && count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : ''); |
1907 | 1907 | |
1908 | 1908 | print '<div class="div-table-responsive">'; |
1909 | - print '<table class="tagtable nobottomiftotal liste' . ($moreforfilter ? " listwithfilterbefore" : "") . '">' . "\n"; |
|
1909 | + print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n"; |
|
1910 | 1910 | |
1911 | 1911 | // Fields title search |
1912 | 1912 | // -------------------------------------------------------------------- |
@@ -1931,20 +1931,20 @@ discard block |
||
1931 | 1931 | } |
1932 | 1932 | // Thirdparty |
1933 | 1933 | if (!empty($arrayfields['p.fk_soc']['checked'])) { |
1934 | - print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_company" value="' . dol_escape_htmltag($search_company) . '"></td>'; |
|
1934 | + print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_company" value="'.dol_escape_htmltag($search_company).'"></td>'; |
|
1935 | 1935 | } |
1936 | 1936 | |
1937 | 1937 | // Thirdparty alias |
1938 | 1938 | if (!empty($arrayfields['s.name_alias']['checked'])) { |
1939 | - print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_company_alias" value="' . dol_escape_htmltag($search_company_alias) . '"></td>'; |
|
1939 | + print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_company_alias" value="'.dol_escape_htmltag($search_company_alias).'"></td>'; |
|
1940 | 1940 | } |
1941 | 1941 | |
1942 | 1942 | if (!empty($allprojectforuser)) { |
1943 | 1943 | if (!empty($arrayfields['p.project_ref']['checked'])) { |
1944 | - print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_project_ref" value="' . dol_escape_htmltag($search_project_ref) . '"></td>'; |
|
1944 | + print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_project_ref" value="'.dol_escape_htmltag($search_project_ref).'"></td>'; |
|
1945 | 1945 | } |
1946 | 1946 | if (!empty($arrayfields['p.project_label']['checked'])) { |
1947 | - print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_project_label" value="' . dol_escape_htmltag($search_project_label) . '"></td>'; |
|
1947 | + print '<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_project_label" value="'.dol_escape_htmltag($search_project_label).'"></td>'; |
|
1948 | 1948 | } |
1949 | 1949 | } |
1950 | 1950 | // Task |
@@ -1962,7 +1962,7 @@ discard block |
||
1962 | 1962 | } |
1963 | 1963 | // Note |
1964 | 1964 | if (!empty($arrayfields['t.note']['checked'])) { |
1965 | - print '<td class="liste_titre"><input type="text" class="flat maxwidth75" name="search_note" value="' . dol_escape_htmltag($search_note) . '"></td>'; |
|
1965 | + print '<td class="liste_titre"><input type="text" class="flat maxwidth75" name="search_note" value="'.dol_escape_htmltag($search_note).'"></td>'; |
|
1966 | 1966 | } |
1967 | 1967 | // Duration |
1968 | 1968 | if (!empty($arrayfields['t.element_duration']['checked'])) { |
@@ -1973,7 +1973,7 @@ discard block |
||
1973 | 1973 | if ($search_timespent_starthour || $search_timespent_startmin) { |
1974 | 1974 | $durationtouse_start = ($search_timespent_starthour * 3600 + $search_timespent_startmin * 60); |
1975 | 1975 | } |
1976 | - print '<div class="nowraponall">' . $langs->trans('from') . ' '; |
|
1976 | + print '<div class="nowraponall">'.$langs->trans('from').' '; |
|
1977 | 1977 | print $form->select_duration('search_timespent_duration_start', $durationtouse_start, 0, 'text', 0, 1); |
1978 | 1978 | print '</div>'; |
1979 | 1979 | |
@@ -1981,7 +1981,7 @@ discard block |
||
1981 | 1981 | if ($search_timespent_endhour || $search_timespent_endmin) { |
1982 | 1982 | $durationtouse_end = ($search_timespent_endhour * 3600 + $search_timespent_endmin * 60); |
1983 | 1983 | } |
1984 | - print '<div class="nowraponall">' . $langs->trans('to') . ' '; |
|
1984 | + print '<div class="nowraponall">'.$langs->trans('to').' '; |
|
1985 | 1985 | print $form->select_duration('search_timespent_duration_end', $durationtouse_end, 0, 'text', 0, 1); |
1986 | 1986 | print '</div>'; |
1987 | 1987 | |
@@ -1997,7 +1997,7 @@ discard block |
||
1997 | 1997 | } |
1998 | 1998 | // Value billed |
1999 | 1999 | if (!empty($arrayfields['valuebilled']['checked'])) { |
2000 | - print '<td class="liste_titre center">' . $form->selectyesno('search_valuebilled', $search_valuebilled, 1, false, 1) . '</td>'; |
|
2000 | + print '<td class="liste_titre center">'.$form->selectyesno('search_valuebilled', $search_valuebilled, 1, false, 1).'</td>'; |
|
2001 | 2001 | } |
2002 | 2002 | |
2003 | 2003 | /* |
@@ -2015,7 +2015,7 @@ discard block |
||
2015 | 2015 | print $searchpicto; |
2016 | 2016 | print '</td>'; |
2017 | 2017 | } |
2018 | - print '</tr>' . "\n"; |
|
2018 | + print '</tr>'."\n"; |
|
2019 | 2019 | |
2020 | 2020 | |
2021 | 2021 | $totalarray = array(); |
@@ -2133,7 +2133,7 @@ discard block |
||
2133 | 2133 | if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) { |
2134 | 2134 | print '<td class="center nowraponall">'; |
2135 | 2135 | if (($action == 'editline' || $action == 'splitline') && GETPOSTINT('lineid') == $task_time->rowid) { |
2136 | - print '<input type="hidden" name="lineid" value="' . GETPOSTINT('lineid') . '">'; |
|
2136 | + print '<input type="hidden" name="lineid" value="'.GETPOSTINT('lineid').'">'; |
|
2137 | 2137 | print '<input type="submit" class="button buttongen smallpaddingimp margintoponlyshort marginbottomonlyshort button-save" name="save" value="'.$langs->trans("Save").'">'; |
2138 | 2138 | print '<br>'; |
2139 | 2139 | print '<input type="submit" class="button buttongen smallpaddingimp margintoponlyshort marginbottomonlyshort button-cancel" name="cancel" value="'.$langs->trans("Cancel").'">'; |
@@ -2144,7 +2144,7 @@ discard block |
||
2144 | 2144 | print '</a>'; |
2145 | 2145 | |
2146 | 2146 | if (getDolGlobalString('PROJECT_ALLOW_SPLIT_TIMESPENT')) { |
2147 | - print '<a class="reposition editfielda paddingleft" href="' . $_SERVER["PHP_SELF"] . '?action=splitline&token=' . newToken() . '&lineid=' . $task_time->rowid . $param . ((empty($id) || $tab == 'timespent') ? '&tab=timespent' : '') . '">'; |
|
2147 | + print '<a class="reposition editfielda paddingleft" href="'.$_SERVER["PHP_SELF"].'?action=splitline&token='.newToken().'&lineid='.$task_time->rowid.$param.((empty($id) || $tab == 'timespent') ? '&tab=timespent' : '').'">'; |
|
2148 | 2148 | print img_split('', 'class="pictofixedwidth paddingleft"'); |
2149 | 2149 | print '</a>'; |
2150 | 2150 | } |
@@ -2162,12 +2162,12 @@ discard block |
||
2162 | 2162 | |
2163 | 2163 | // Disable select if task not billable or already invoiced |
2164 | 2164 | $disabled = (intval($task_time->billable) != 1 || $invoiced); |
2165 | - $ctrl = '<input '.($disabled ? 'disabled' : '').' id="cb' . $task_time->rowid . '" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="' . $task_time->rowid . '"' . ($selected ? ' checked="checked"' : '') . '>'; |
|
2165 | + $ctrl = '<input '.($disabled ? 'disabled' : '').' id="cb'.$task_time->rowid.'" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="'.$task_time->rowid.'"'.($selected ? ' checked="checked"' : '').'>'; |
|
2166 | 2166 | if ($disabled) { |
2167 | 2167 | // If disabled, a dbl-click very close outside the control |
2168 | 2168 | // will re-enable it, so that user is not blocked if needed. |
2169 | - print '<span id="cbsp'. $task_time->rowid . '">'.$ctrl.'</span>'; |
|
2170 | - print '<script>$("#cbsp' . $task_time->rowid . '").dblclick(()=>{ $("#cb' . $task_time->rowid . '").removeAttr("disabled") })</script>'; |
|
2169 | + print '<span id="cbsp'.$task_time->rowid.'">'.$ctrl.'</span>'; |
|
2170 | + print '<script>$("#cbsp'.$task_time->rowid.'").dblclick(()=>{ $("#cb'.$task_time->rowid.'").removeAttr("disabled") })</script>'; |
|
2171 | 2171 | } else { |
2172 | 2172 | print $ctrl; |
2173 | 2173 | } |
@@ -2289,7 +2289,7 @@ discard block |
||
2289 | 2289 | } |
2290 | 2290 | } |
2291 | 2291 | } elseif ($action !== 'createtime') { |
2292 | - print '<input type="hidden" name="taskid" value="' . $id . '">'; |
|
2292 | + print '<input type="hidden" name="taskid" value="'.$id.'">'; |
|
2293 | 2293 | } |
2294 | 2294 | |
2295 | 2295 | // Task label |
@@ -2318,9 +2318,9 @@ discard block |
||
2318 | 2318 | } |
2319 | 2319 | if (count($contactsoftask) > 0) { |
2320 | 2320 | print img_object('', 'user', 'class="pictofixedwidth hideonsmartphone"'); |
2321 | - print $form->select_dolusers($task_time->fk_user, 'userid_line', 0, null, 0, '', $contactsoftask, '0', 0, 0, '', 0, '', 'minwidth100 maxwidth100'); // maxwidth must be lowed than minwidth of the td |
|
2321 | + print $form->select_dolusers($task_time->fk_user, 'userid_line', 0, null, 0, '', $contactsoftask, '0', 0, 0, '', 0, '', 'minwidth100 maxwidth100'); // maxwidth must be lowed than minwidth of the td |
|
2322 | 2322 | } else { |
2323 | - print img_error($langs->trans('FirstAddRessourceToAllocateTime')) . $langs->trans('FirstAddRessourceToAllocateTime'); |
|
2323 | + print img_error($langs->trans('FirstAddRessourceToAllocateTime')).$langs->trans('FirstAddRessourceToAllocateTime'); |
|
2324 | 2324 | } |
2325 | 2325 | } else { |
2326 | 2326 | $userstatic->id = $task_time->fk_user; |
@@ -2342,7 +2342,7 @@ discard block |
||
2342 | 2342 | if (!empty($arrayfields['t.note']['checked'])) { |
2343 | 2343 | if ($action == 'editline' && GETPOSTINT('lineid') == $task_time->rowid) { |
2344 | 2344 | print '<td class="small">'; |
2345 | - print '<textarea name="timespent_note_line" width="95%" rows="' . ROWS_1 . '">' . dol_escape_htmltag($task_time->note, 0, 1) . '</textarea>'; |
|
2345 | + print '<textarea name="timespent_note_line" width="95%" rows="'.ROWS_1.'">'.dol_escape_htmltag($task_time->note, 0, 1).'</textarea>'; |
|
2346 | 2346 | print '</td>'; |
2347 | 2347 | } else { |
2348 | 2348 | print '<td class="small tdoverflowmax150 classfortooltip" title="'.dol_string_onlythesehtmltags(dol_htmlentitiesbr($task_time->note)).'">'; |
@@ -2353,7 +2353,7 @@ discard block |
||
2353 | 2353 | $totalarray['nbfield']++; |
2354 | 2354 | } |
2355 | 2355 | } elseif ($action == 'editline' && GETPOSTINT('lineid') == $task_time->rowid) { |
2356 | - print '<input type="hidden" name="timespent_note_line" value="' . dol_escape_htmltag($task_time->note, 0, 1) . '">'; |
|
2356 | + print '<input type="hidden" name="timespent_note_line" value="'.dol_escape_htmltag($task_time->note, 0, 1).'">'; |
|
2357 | 2357 | } |
2358 | 2358 | |
2359 | 2359 | // Time spent |
@@ -2414,7 +2414,7 @@ discard block |
||
2414 | 2414 | $value = price2num($task_time->thm * $task_time->element_duration / 3600, 'MT', 1); |
2415 | 2415 | |
2416 | 2416 | print '<td class="nowraponall right">'; |
2417 | - print '<span class="amount" title="' . $langs->trans("THM") . ': ' . price($task_time->thm) . '">'; |
|
2417 | + print '<span class="amount" title="'.$langs->trans("THM").': '.price($task_time->thm).'">'; |
|
2418 | 2418 | print price($value, 1, $langs, 1, -1, -1, $conf->currency); |
2419 | 2419 | print '</span>'; |
2420 | 2420 | print '</td>'; |
@@ -2470,7 +2470,7 @@ discard block |
||
2470 | 2470 | } |
2471 | 2471 | } |
2472 | 2472 | } else { |
2473 | - print '<span class="opacitymedium">' . $langs->trans("NA") . '</span>'; |
|
2473 | + print '<span class="opacitymedium">'.$langs->trans("NA").'</span>'; |
|
2474 | 2474 | } |
2475 | 2475 | } |
2476 | 2476 | print '</td>'; |
@@ -2504,7 +2504,7 @@ discard block |
||
2504 | 2504 | print '</a>'; |
2505 | 2505 | |
2506 | 2506 | if (getDolGlobalString('PROJECT_ALLOW_SPLIT_TIMESPENT')) { |
2507 | - print '<a class="reposition editfielda paddingleft" href="' . $_SERVER["PHP_SELF"] . '?action=splitline&token=' . newToken() . '&lineid=' . $task_time->rowid . $param . ((empty($id) || $tab == 'timespent') ? '&tab=timespent' : '') . '">'; |
|
2507 | + print '<a class="reposition editfielda paddingleft" href="'.$_SERVER["PHP_SELF"].'?action=splitline&token='.newToken().'&lineid='.$task_time->rowid.$param.((empty($id) || $tab == 'timespent') ? '&tab=timespent' : '').'">'; |
|
2508 | 2508 | print img_split('', 'class="pictofixedwidth paddingleft"'); |
2509 | 2509 | print '</a>'; |
2510 | 2510 | } |
@@ -2522,12 +2522,12 @@ discard block |
||
2522 | 2522 | |
2523 | 2523 | // Disable select if task not billable or already invoiced |
2524 | 2524 | $disabled = (intval($task_time->billable) != 1 || $invoiced); |
2525 | - $ctrl = '<input '.($disabled ? 'disabled' : '').' id="cb' . $task_time->rowid . '" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="' . $task_time->rowid . '"' . ($selected ? ' checked="checked"' : '') . '>'; |
|
2525 | + $ctrl = '<input '.($disabled ? 'disabled' : '').' id="cb'.$task_time->rowid.'" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="'.$task_time->rowid.'"'.($selected ? ' checked="checked"' : '').'>'; |
|
2526 | 2526 | if ($disabled) { |
2527 | 2527 | // If disabled, a dbl-click very close outside the control |
2528 | 2528 | // will re-enable it, so that user is not blocked if needed. |
2529 | - print '<span id="cbsp'. $task_time->rowid . '">'.$ctrl.'</span>'; |
|
2530 | - print '<script>$("#cbsp' . $task_time->rowid . '").dblclick(()=>{ $("#cb' . $task_time->rowid . '").removeAttr("disabled") })</script>'; |
|
2529 | + print '<span id="cbsp'.$task_time->rowid.'">'.$ctrl.'</span>'; |
|
2530 | + print '<script>$("#cbsp'.$task_time->rowid.'").dblclick(()=>{ $("#cb'.$task_time->rowid.'").removeAttr("disabled") })</script>'; |
|
2531 | 2531 | } else { |
2532 | 2532 | print $ctrl; |
2533 | 2533 | } |
@@ -2625,7 +2625,7 @@ discard block |
||
2625 | 2625 | print img_object('', 'user', 'class="hideonsmartphone"'); |
2626 | 2626 | print $form->select_dolusers($task_time->fk_user, 'userid_line', 0, '', 0, '', $contactsoftask); |
2627 | 2627 | } else { |
2628 | - print img_error($langs->trans('FirstAddRessourceToAllocateTime')) . $langs->trans('FirstAddRessourceToAllocateTime'); |
|
2628 | + print img_error($langs->trans('FirstAddRessourceToAllocateTime')).$langs->trans('FirstAddRessourceToAllocateTime'); |
|
2629 | 2629 | } |
2630 | 2630 | } else { |
2631 | 2631 | $userstatic->id = $task_time->fk_user; |
@@ -2642,13 +2642,13 @@ discard block |
||
2642 | 2642 | if (!empty($arrayfields['t.note']['checked'])) { |
2643 | 2643 | print '<td class="tdoverflowmax300">'; |
2644 | 2644 | if ($action == 'splitline' && GETPOSTINT('lineid') == $task_time->rowid) { |
2645 | - print '<textarea name="timespent_note_line" width="95%" rows="' . ROWS_1 . '">' . dol_escape_htmltag($task_time->note, 0, 1) . '</textarea>'; |
|
2645 | + print '<textarea name="timespent_note_line" width="95%" rows="'.ROWS_1.'">'.dol_escape_htmltag($task_time->note, 0, 1).'</textarea>'; |
|
2646 | 2646 | } else { |
2647 | 2647 | print dol_nl2br($task_time->note); |
2648 | 2648 | } |
2649 | 2649 | print '</td>'; |
2650 | 2650 | } elseif ($action == 'splitline' && GETPOSTINT('lineid') == $task_time->rowid) { |
2651 | - print '<input type="hidden" name="timespent_note_line" rows="' . ROWS_1 . '" value="' . dol_escape_htmltag($task_time->note, 0, 1) . '">'; |
|
2651 | + print '<input type="hidden" name="timespent_note_line" rows="'.ROWS_1.'" value="'.dol_escape_htmltag($task_time->note, 0, 1).'">'; |
|
2652 | 2652 | } |
2653 | 2653 | |
2654 | 2654 | // Time spent |
@@ -2789,7 +2789,7 @@ discard block |
||
2789 | 2789 | print img_object('', 'user', 'class="hideonsmartphone"'); |
2790 | 2790 | print $form->select_dolusers($task_time->fk_user, 'userid_line_2', 0, '', 0, '', $contactsoftask); |
2791 | 2791 | } else { |
2792 | - print img_error($langs->trans('FirstAddRessourceToAllocateTime')) . $langs->trans('FirstAddRessourceToAllocateTime'); |
|
2792 | + print img_error($langs->trans('FirstAddRessourceToAllocateTime')).$langs->trans('FirstAddRessourceToAllocateTime'); |
|
2793 | 2793 | } |
2794 | 2794 | } else { |
2795 | 2795 | $userstatic->id = $task_time->fk_user; |
@@ -2806,13 +2806,13 @@ discard block |
||
2806 | 2806 | if (!empty($arrayfields['t.note']['checked'])) { |
2807 | 2807 | print '<td class="small tdoverflowmax300"">'; |
2808 | 2808 | if ($action == 'splitline' && GETPOSTINT('lineid') == $task_time->rowid) { |
2809 | - print '<textarea name="timespent_note_line_2" width="95%" rows="' . ROWS_1 . '">' . dol_escape_htmltag($task_time->note, 0, 1) . '</textarea>'; |
|
2809 | + print '<textarea name="timespent_note_line_2" width="95%" rows="'.ROWS_1.'">'.dol_escape_htmltag($task_time->note, 0, 1).'</textarea>'; |
|
2810 | 2810 | } else { |
2811 | 2811 | print dol_nl2br($task_time->note); |
2812 | 2812 | } |
2813 | 2813 | print '</td>'; |
2814 | 2814 | } elseif ($action == 'splitline' && GETPOSTINT('lineid') == $task_time->rowid) { |
2815 | - print '<input type="hidden" name="timespent_note_line_2" value="' . dol_escape_htmltag($task_time->note, 0, 1) . '">'; |
|
2815 | + print '<input type="hidden" name="timespent_note_line_2" value="'.dol_escape_htmltag($task_time->note, 0, 1).'">'; |
|
2816 | 2816 | } |
2817 | 2817 | |
2818 | 2818 | // Time spent |
@@ -2886,14 +2886,14 @@ discard block |
||
2886 | 2886 | $i++; |
2887 | 2887 | if ($i == 1) { |
2888 | 2888 | if ($num < $limit && empty($offset)) { |
2889 | - print '<td class="left">' . $langs->trans("Total") . '</td>'; |
|
2889 | + print '<td class="left">'.$langs->trans("Total").'</td>'; |
|
2890 | 2890 | } else { |
2891 | 2891 | print '<td class="left">'.$form->textwithpicto($langs->trans("Total"), $langs->trans("Totalforthispage")).'</td>'; |
2892 | 2892 | } |
2893 | 2893 | } elseif (isset($totalarray['totaldurationfield']) && $totalarray['totaldurationfield'] == $i) { |
2894 | - print '<td class="right">' . convertSecondToTime($totalarray['totalduration'], 'allhourmin') . '</td>'; |
|
2894 | + print '<td class="right">'.convertSecondToTime($totalarray['totalduration'], 'allhourmin').'</td>'; |
|
2895 | 2895 | } elseif (isset($totalarray['totalvaluefield']) && $totalarray['totalvaluefield'] == $i) { |
2896 | - print '<td class="right">' . price($totalarray['totalvalue']) . '</td>'; |
|
2896 | + print '<td class="right">'.price($totalarray['totalvalue']).'</td>'; |
|
2897 | 2897 | //} elseif ($totalarray['totalvaluebilledfield'] == $i) { print '<td class="center">'.price($totalarray['totalvaluebilled']).'</td>'; |
2898 | 2898 | } else { |
2899 | 2899 | print '<td></td>'; |
@@ -2909,8 +2909,8 @@ discard block |
||
2909 | 2909 | $totalnboffields++; |
2910 | 2910 | } |
2911 | 2911 | } |
2912 | - print '<tr class="oddeven"><td colspan="' . $totalnboffields . '">'; |
|
2913 | - print '<span class="opacitymedium">' . $langs->trans("None") . '</span>'; |
|
2912 | + print '<tr class="oddeven"><td colspan="'.$totalnboffields.'">'; |
|
2913 | + print '<span class="opacitymedium">'.$langs->trans("None").'</span>'; |
|
2914 | 2914 | print '</td></tr>'; |
2915 | 2915 | } |
2916 | 2916 |
@@ -29,17 +29,17 @@ discard block |
||
29 | 29 | * \brief File of withdrawal receipts class |
30 | 30 | */ |
31 | 31 | |
32 | -require_once DOL_DOCUMENT_ROOT . '/core/class/commonobject.class.php'; |
|
33 | -require_once DOL_DOCUMENT_ROOT . '/core/lib/bank.lib.php'; |
|
34 | -require_once DOL_DOCUMENT_ROOT . '/compta/bank/class/account.class.php'; |
|
35 | -require_once DOL_DOCUMENT_ROOT . '/compta/facture/class/facture.class.php'; |
|
36 | -require_once DOL_DOCUMENT_ROOT . '/compta/paiement/class/paiement.class.php'; |
|
37 | -require_once DOL_DOCUMENT_ROOT . '/fourn/class/fournisseur.facture.class.php'; |
|
38 | -require_once DOL_DOCUMENT_ROOT . '/fourn/class/paiementfourn.class.php'; |
|
39 | -require_once DOL_DOCUMENT_ROOT . '/salaries/class/salary.class.php'; |
|
40 | -require_once DOL_DOCUMENT_ROOT . '/salaries/class/paymentsalary.class.php'; |
|
41 | -require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; |
|
42 | -require_once DOL_DOCUMENT_ROOT . '/user/class/userbankaccount.class.php'; |
|
32 | +require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php'; |
|
33 | +require_once DOL_DOCUMENT_ROOT.'/core/lib/bank.lib.php'; |
|
34 | +require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php'; |
|
35 | +require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php'; |
|
36 | +require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php'; |
|
37 | +require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.php'; |
|
38 | +require_once DOL_DOCUMENT_ROOT.'/fourn/class/paiementfourn.class.php'; |
|
39 | +require_once DOL_DOCUMENT_ROOT.'/salaries/class/salary.class.php'; |
|
40 | +require_once DOL_DOCUMENT_ROOT.'/salaries/class/paymentsalary.class.php'; |
|
41 | +require_once DOL_DOCUMENT_ROOT.'/societe/class/societe.class.php'; |
|
42 | +require_once DOL_DOCUMENT_ROOT.'/user/class/userbankaccount.class.php'; |
|
43 | 43 | |
44 | 44 | |
45 | 45 | /** |
@@ -149,8 +149,8 @@ discard block |
||
149 | 149 | |
150 | 150 | const STATUS_DRAFT = 0; |
151 | 151 | const STATUS_TRANSFERED = 1; |
152 | - const STATUS_CREDITED = 2; // STATUS_CREDITED and STATUS_DEBITED is same. Difference is in ->type |
|
153 | - const STATUS_DEBITED = 2; // STATUS_CREDITED and STATUS_DEBITED is same. Difference is in ->type |
|
152 | + const STATUS_CREDITED = 2; // STATUS_CREDITED and STATUS_DEBITED is same. Difference is in ->type |
|
153 | + const STATUS_DEBITED = 2; // STATUS_CREDITED and STATUS_DEBITED is same. Difference is in ->type |
|
154 | 154 | |
155 | 155 | |
156 | 156 | /** |
@@ -339,7 +339,7 @@ discard block |
||
339 | 339 | |
340 | 340 | if ($result == 0) { |
341 | 341 | if ($line_id > 0) { |
342 | - $sql = "INSERT INTO " . MAIN_DB_PREFIX . "prelevement ("; |
|
342 | + $sql = "INSERT INTO ".MAIN_DB_PREFIX."prelevement ("; |
|
343 | 343 | if ($type != 'bank-transfer') { |
344 | 344 | $sql .= "fk_facture"; |
345 | 345 | } else { |
@@ -352,24 +352,24 @@ discard block |
||
352 | 352 | $sql .= ",fk_prelevement_lignes"; |
353 | 353 | $sql .= ") VALUES ("; |
354 | 354 | $sql .= ((int) $invoice_id); |
355 | - $sql .= ", " . ((int) $line_id); |
|
355 | + $sql .= ", ".((int) $line_id); |
|
356 | 356 | $sql .= ")"; |
357 | 357 | |
358 | 358 | if ($this->db->query($sql)) { |
359 | 359 | $result = 0; |
360 | 360 | } else { |
361 | 361 | $result = -1; |
362 | - $this->errors[] = get_class($this) . "::AddFacture " . $this->db->lasterror; |
|
363 | - dol_syslog(get_class($this) . "::AddFacture Error $result"); |
|
362 | + $this->errors[] = get_class($this)."::AddFacture ".$this->db->lasterror; |
|
363 | + dol_syslog(get_class($this)."::AddFacture Error $result"); |
|
364 | 364 | } |
365 | 365 | } else { |
366 | 366 | $result = -2; |
367 | - $this->errors[] = get_class($this) . "::AddFacture linedid Empty"; |
|
368 | - dol_syslog(get_class($this) . "::AddFacture Error $result"); |
|
367 | + $this->errors[] = get_class($this)."::AddFacture linedid Empty"; |
|
368 | + dol_syslog(get_class($this)."::AddFacture Error $result"); |
|
369 | 369 | } |
370 | 370 | } else { |
371 | 371 | $result = -3; |
372 | - dol_syslog(get_class($this) . "::AddFacture Error $result"); |
|
372 | + dol_syslog(get_class($this)."::AddFacture Error $result"); |
|
373 | 373 | } |
374 | 374 | |
375 | 375 | return $result; |
@@ -392,23 +392,23 @@ discard block |
||
392 | 392 | public function addline(&$line_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number, $number_key, $sourcetype = '') |
393 | 393 | { |
394 | 394 | $result = -1; |
395 | - $concat = 0; // ??? what is this for. Seems not used. |
|
395 | + $concat = 0; // ??? what is this for. Seems not used. |
|
396 | 396 | |
397 | 397 | if ($concat == 1) { |
398 | 398 | /* |
399 | 399 | * We aggregate the lines |
400 | 400 | */ |
401 | 401 | $sql = "SELECT rowid"; |
402 | - $sql .= " FROM " . MAIN_DB_PREFIX . "prelevement_lignes"; |
|
403 | - $sql .= " WHERE fk_prelevement_bons = " . ((int) $this->id); |
|
402 | + $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_lignes"; |
|
403 | + $sql .= " WHERE fk_prelevement_bons = ".((int) $this->id); |
|
404 | 404 | if ($sourcetype == 'salary') { |
405 | - $sql .= " AND fk_soc = " . ((int) $client_id); |
|
405 | + $sql .= " AND fk_soc = ".((int) $client_id); |
|
406 | 406 | } else { |
407 | - $sql .= " AND fk_user = " . ((int) $client_id); |
|
407 | + $sql .= " AND fk_user = ".((int) $client_id); |
|
408 | 408 | } |
409 | - $sql .= " AND code_banque = '" . $this->db->escape($code_banque) . "'"; |
|
410 | - $sql .= " AND code_guichet = '" . $this->db->escape($code_guichet) . "'"; |
|
411 | - $sql .= " AND number = '" . $this->db->escape($number) . "'"; |
|
409 | + $sql .= " AND code_banque = '".$this->db->escape($code_banque)."'"; |
|
410 | + $sql .= " AND code_guichet = '".$this->db->escape($code_guichet)."'"; |
|
411 | + $sql .= " AND number = '".$this->db->escape($number)."'"; |
|
412 | 412 | |
413 | 413 | $resql = $this->db->query($sql); |
414 | 414 | if ($resql) { |
@@ -420,7 +420,7 @@ discard block |
||
420 | 420 | /* |
421 | 421 | * No aggregate |
422 | 422 | */ |
423 | - $sql = "INSERT INTO " . MAIN_DB_PREFIX . "prelevement_lignes ("; |
|
423 | + $sql = "INSERT INTO ".MAIN_DB_PREFIX."prelevement_lignes ("; |
|
424 | 424 | $sql .= "fk_prelevement_bons"; |
425 | 425 | $sql .= ", fk_soc"; |
426 | 426 | $sql .= ", client_nom"; |
@@ -432,21 +432,21 @@ discard block |
||
432 | 432 | $sql .= ($sourcetype == 'salary' ? ", fk_user" : ""); |
433 | 433 | $sql .= ") VALUES ("; |
434 | 434 | $sql .= $this->id; |
435 | - $sql .= ", " . (($sourcetype != 'salary') ? ((int) $client_id) : "0"); // fk_soc can't be null |
|
436 | - $sql .= ", '" . $this->db->escape($client_nom) . "'"; |
|
437 | - $sql .= ", " . ((float) price2num($amount)); |
|
438 | - $sql .= ", '" . $this->db->escape($code_banque) . "'"; |
|
439 | - $sql .= ", '" . $this->db->escape($code_guichet) . "'"; |
|
440 | - $sql .= ", '" . $this->db->escape($number) . "'"; |
|
441 | - $sql .= ", '" . $this->db->escape($number_key) . "'"; |
|
442 | - $sql .= (($sourcetype == 'salary') ? ", " . ((int) $client_id) : ''); |
|
435 | + $sql .= ", ".(($sourcetype != 'salary') ? ((int) $client_id) : "0"); // fk_soc can't be null |
|
436 | + $sql .= ", '".$this->db->escape($client_nom)."'"; |
|
437 | + $sql .= ", ".((float) price2num($amount)); |
|
438 | + $sql .= ", '".$this->db->escape($code_banque)."'"; |
|
439 | + $sql .= ", '".$this->db->escape($code_guichet)."'"; |
|
440 | + $sql .= ", '".$this->db->escape($number)."'"; |
|
441 | + $sql .= ", '".$this->db->escape($number_key)."'"; |
|
442 | + $sql .= (($sourcetype == 'salary') ? ", ".((int) $client_id) : ''); |
|
443 | 443 | $sql .= ")"; |
444 | 444 | if ($this->db->query($sql)) { |
445 | - $line_id = $this->db->last_insert_id(MAIN_DB_PREFIX . "prelevement_lignes"); |
|
445 | + $line_id = $this->db->last_insert_id(MAIN_DB_PREFIX."prelevement_lignes"); |
|
446 | 446 | $result = 0; |
447 | 447 | } else { |
448 | - $this->errors[] = get_class($this) . "::addline Error -2 " . $this->db->lasterror; |
|
449 | - dol_syslog(get_class($this) . "::addline Error -2"); |
|
448 | + $this->errors[] = get_class($this)."::addline Error -2 ".$this->db->lasterror; |
|
449 | + dol_syslog(get_class($this)."::addline Error -2"); |
|
450 | 450 | $result = -2; |
451 | 451 | } |
452 | 452 | } |
@@ -489,15 +489,15 @@ discard block |
||
489 | 489 | $sql .= ", p.type"; |
490 | 490 | $sql .= ", p.fk_bank_account"; |
491 | 491 | $sql .= ", p.statut as status"; |
492 | - $sql .= " FROM " . MAIN_DB_PREFIX . "prelevement_bons as p"; |
|
493 | - $sql .= " WHERE p.entity IN (" . getEntity('invoice') . ")"; |
|
492 | + $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_bons as p"; |
|
493 | + $sql .= " WHERE p.entity IN (".getEntity('invoice').")"; |
|
494 | 494 | if ($rowid > 0) { |
495 | - $sql .= " AND p.rowid = " . ((int) $rowid); |
|
495 | + $sql .= " AND p.rowid = ".((int) $rowid); |
|
496 | 496 | } else { |
497 | - $sql .= " AND p.ref = '" . $this->db->escape($ref) . "'"; |
|
497 | + $sql .= " AND p.ref = '".$this->db->escape($ref)."'"; |
|
498 | 498 | } |
499 | 499 | |
500 | - dol_syslog(get_class($this) . "::fetch", LOG_DEBUG); |
|
500 | + dol_syslog(get_class($this)."::fetch", LOG_DEBUG); |
|
501 | 501 | $result = $this->db->query($sql); |
502 | 502 | if ($result) { |
503 | 503 | if ($this->db->num_rows($result)) { |
@@ -523,13 +523,13 @@ discard block |
||
523 | 523 | if (empty($this->status)) { // Value is sometimes null in database |
524 | 524 | $this->status = 0; |
525 | 525 | } |
526 | - $this->statut = $this->status; // For backward compatibility |
|
526 | + $this->statut = $this->status; // For backward compatibility |
|
527 | 527 | |
528 | 528 | $this->fetched = 1; |
529 | 529 | |
530 | 530 | return 1; |
531 | 531 | } else { |
532 | - dol_syslog(get_class($this) . "::Fetch no record found"); |
|
532 | + dol_syslog(get_class($this)."::Fetch no record found"); |
|
533 | 533 | return 0; |
534 | 534 | } |
535 | 535 | } else { |
@@ -570,19 +570,19 @@ discard block |
||
570 | 570 | if ($date < $this->date_trans) { |
571 | 571 | $langs->load("errors"); |
572 | 572 | $this->error = $langs->trans('ErrorDateOfMovementLowerThanDateOfFileTransmission'); |
573 | - dol_syslog("bon-prelevment::set_infocredit 1027 " . $this->error); |
|
573 | + dol_syslog("bon-prelevment::set_infocredit 1027 ".$this->error); |
|
574 | 574 | return -1027; |
575 | 575 | } |
576 | 576 | |
577 | 577 | $this->db->begin(); |
578 | 578 | |
579 | - $sql = " UPDATE " . MAIN_DB_PREFIX . "prelevement_bons"; |
|
580 | - $sql .= " SET fk_user_credit = " . ((int) $user->id); |
|
581 | - $sql .= ", statut = " . self::STATUS_CREDITED; |
|
582 | - $sql .= ", date_credit = '" . $this->db->idate($date) . "'"; |
|
583 | - $sql .= " WHERE rowid = " . ((int) $this->id); |
|
584 | - $sql .= " AND entity = " . ((int) $conf->entity); |
|
585 | - $sql .= " AND statut = " . self::STATUS_TRANSFERED; |
|
579 | + $sql = " UPDATE ".MAIN_DB_PREFIX."prelevement_bons"; |
|
580 | + $sql .= " SET fk_user_credit = ".((int) $user->id); |
|
581 | + $sql .= ", statut = ".self::STATUS_CREDITED; |
|
582 | + $sql .= ", date_credit = '".$this->db->idate($date)."'"; |
|
583 | + $sql .= " WHERE rowid = ".((int) $this->id); |
|
584 | + $sql .= " AND entity = ".((int) $conf->entity); |
|
585 | + $sql .= " AND statut = ".self::STATUS_TRANSFERED; |
|
586 | 586 | |
587 | 587 | $resql = $this->db->query($sql); |
588 | 588 | if ($resql) { |
@@ -696,7 +696,7 @@ discard block |
||
696 | 696 | $error++; |
697 | 697 | $this->error = $paiement->error; |
698 | 698 | $this->errors = $paiement->errors; |
699 | - dol_syslog(get_class($this) . "::set_infocredit AddPayment Error " . $this->error); |
|
699 | + dol_syslog(get_class($this)."::set_infocredit AddPayment Error ".$this->error); |
|
700 | 700 | } else { |
701 | 701 | if ($this->type == 'bank-transfer') { |
702 | 702 | if ($type == 'salary') { |
@@ -711,7 +711,7 @@ discard block |
||
711 | 711 | } else { |
712 | 712 | $modeforaddpayment = 'payment'; |
713 | 713 | $labelforaddpayment = '(CustomerInvoicePayment)'; |
714 | - $addbankurl = 'direct-debit'; // = 'directdebit' |
|
714 | + $addbankurl = 'direct-debit'; // = 'directdebit' |
|
715 | 715 | } |
716 | 716 | |
717 | 717 | |
@@ -726,7 +726,7 @@ discard block |
||
726 | 726 | $error++; |
727 | 727 | $this->error = $paiement->error; |
728 | 728 | $this->errors = $paiement->errors; |
729 | - dol_syslog(get_class($this) . "::set_infocredit AddPaymentToBank Error " . $this->error); |
|
729 | + dol_syslog(get_class($this)."::set_infocredit AddPaymentToBank Error ".$this->error); |
|
730 | 730 | } |
731 | 731 | } |
732 | 732 | } |
@@ -734,24 +734,24 @@ discard block |
||
734 | 734 | // Update withdrawal line |
735 | 735 | // TODO: Translate to ligneprelevement.class.php |
736 | 736 | if (!$error) { |
737 | - $sql = " UPDATE " . MAIN_DB_PREFIX . "prelevement_lignes"; |
|
737 | + $sql = " UPDATE ".MAIN_DB_PREFIX."prelevement_lignes"; |
|
738 | 738 | $sql .= " SET statut = 2"; |
739 | - $sql .= " WHERE fk_prelevement_bons = " . ((int) $this->id); |
|
739 | + $sql .= " WHERE fk_prelevement_bons = ".((int) $this->id); |
|
740 | 740 | |
741 | 741 | if (!$this->db->query($sql)) { |
742 | - dol_syslog(get_class($this) . "::set_infocredit Update lines Error"); |
|
742 | + dol_syslog(get_class($this)."::set_infocredit Update lines Error"); |
|
743 | 743 | $error++; |
744 | 744 | } |
745 | 745 | } |
746 | 746 | } else { |
747 | 747 | $this->error = $this->db->lasterror(); |
748 | - dol_syslog(get_class($this) . "::set_infocredit Update Bons Error"); |
|
748 | + dol_syslog(get_class($this)."::set_infocredit Update Bons Error"); |
|
749 | 749 | $error++; |
750 | 750 | } |
751 | 751 | |
752 | 752 | // End of procedure |
753 | 753 | if ($error == 0) { |
754 | - $this->date_credit = $date; // date credit or debit |
|
754 | + $this->date_credit = $date; // date credit or debit |
|
755 | 755 | $this->statut = self::STATUS_CREDITED; |
756 | 756 | $this->status = self::STATUS_CREDITED; |
757 | 757 | |
@@ -782,17 +782,17 @@ discard block |
||
782 | 782 | |
783 | 783 | $error = 0; |
784 | 784 | |
785 | - dol_syslog(get_class($this) . "::set_infotrans Start", LOG_INFO); |
|
785 | + dol_syslog(get_class($this)."::set_infotrans Start", LOG_INFO); |
|
786 | 786 | |
787 | 787 | if ($this->db->begin()) { |
788 | - $sql = "UPDATE " . MAIN_DB_PREFIX . "prelevement_bons "; |
|
789 | - $sql .= " SET fk_user_trans = " . $user->id; |
|
790 | - $sql .= " , date_trans = '" . $this->db->idate($date) . "'"; |
|
791 | - $sql .= " , method_trans = " . ((int) $method); |
|
792 | - $sql .= " , statut = " . self::STATUS_TRANSFERED; |
|
793 | - $sql .= " WHERE rowid = " . ((int) $this->id); |
|
794 | - $sql .= " AND entity = " . ((int) $conf->entity); |
|
795 | - $sql .= " AND statut = " . self::STATUS_DRAFT; |
|
788 | + $sql = "UPDATE ".MAIN_DB_PREFIX."prelevement_bons "; |
|
789 | + $sql .= " SET fk_user_trans = ".$user->id; |
|
790 | + $sql .= " , date_trans = '".$this->db->idate($date)."'"; |
|
791 | + $sql .= " , method_trans = ".((int) $method); |
|
792 | + $sql .= " , statut = ".self::STATUS_TRANSFERED; |
|
793 | + $sql .= " WHERE rowid = ".((int) $this->id); |
|
794 | + $sql .= " AND entity = ".((int) $conf->entity); |
|
795 | + $sql .= " AND statut = ".self::STATUS_DRAFT; |
|
796 | 796 | |
797 | 797 | if ($this->db->query($sql)) { |
798 | 798 | $this->method_trans = $method; |
@@ -817,12 +817,12 @@ discard block |
||
817 | 817 | return 0; |
818 | 818 | } else { |
819 | 819 | $this->db->rollback(); |
820 | - dol_syslog(get_class($this) . "::set_infotrans ROLLBACK", LOG_ERR); |
|
820 | + dol_syslog(get_class($this)."::set_infotrans ROLLBACK", LOG_ERR); |
|
821 | 821 | |
822 | 822 | return -1; |
823 | 823 | } |
824 | 824 | } else { |
825 | - dol_syslog(get_class($this) . "::set_infotrans Ouverture transaction SQL impossible", LOG_CRIT); |
|
825 | + dol_syslog(get_class($this)."::set_infotrans Ouverture transaction SQL impossible", LOG_CRIT); |
|
826 | 826 | return -2; |
827 | 827 | } |
828 | 828 | } |
@@ -841,7 +841,7 @@ discard block |
||
841 | 841 | |
842 | 842 | $arr = array(); |
843 | 843 | |
844 | - dol_syslog(get_class($this) . "::getListInvoices"); |
|
844 | + dol_syslog(get_class($this)."::getListInvoices"); |
|
845 | 845 | |
846 | 846 | // Returns all invoices presented within same order |
847 | 847 | $sql = "SELECT "; |
@@ -857,13 +857,13 @@ discard block |
||
857 | 857 | if ($amounts) { |
858 | 858 | $sql .= ", SUM(pl.amount)"; |
859 | 859 | } |
860 | - $sql .= " FROM " . MAIN_DB_PREFIX . "prelevement_bons as pb,"; |
|
861 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_lignes as pl,"; |
|
862 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement as p"; |
|
860 | + $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_bons as pb,"; |
|
861 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_lignes as pl,"; |
|
862 | + $sql .= " ".MAIN_DB_PREFIX."prelevement as p"; |
|
863 | 863 | $sql .= " WHERE p.fk_prelevement_lignes = pl.rowid"; |
864 | 864 | $sql .= " AND pl.fk_prelevement_bons = pb.rowid"; |
865 | - $sql .= " AND pb.rowid = " . ((int) $this->id); |
|
866 | - $sql .= " AND pb.entity = " . ((int) $conf->entity); |
|
865 | + $sql .= " AND pb.rowid = ".((int) $this->id); |
|
866 | + $sql .= " AND pb.entity = ".((int) $conf->entity); |
|
867 | 867 | if ($amounts) { |
868 | 868 | if ($this->type == 'bank-transfer') { |
869 | 869 | if ($type == 'salary') { |
@@ -917,17 +917,17 @@ discard block |
||
917 | 917 | $sql = "SELECT sum(pd.amount) as nb"; |
918 | 918 | if ($type !== 'salary') { |
919 | 919 | if ($mode != 'bank-transfer') { |
920 | - $sql .= " FROM " . MAIN_DB_PREFIX . "facture as f,"; |
|
920 | + $sql .= " FROM ".MAIN_DB_PREFIX."facture as f,"; |
|
921 | 921 | } else { |
922 | - $sql .= " FROM " . MAIN_DB_PREFIX . "facture_fourn as f,"; |
|
922 | + $sql .= " FROM ".MAIN_DB_PREFIX."facture_fourn as f,"; |
|
923 | 923 | } |
924 | 924 | } else { |
925 | - $sql .= " FROM " . MAIN_DB_PREFIX . "salary as s,"; |
|
925 | + $sql .= " FROM ".MAIN_DB_PREFIX."salary as s,"; |
|
926 | 926 | } |
927 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_demande as pd"; |
|
928 | - $sql .= ($type !== 'salary' ? " WHERE f.entity IN (" . getEntity('invoice') . ")" : " WHERE s.entity IN (" . getEntity('salary') . ")"); |
|
927 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_demande as pd"; |
|
928 | + $sql .= ($type !== 'salary' ? " WHERE f.entity IN (".getEntity('invoice').")" : " WHERE s.entity IN (".getEntity('salary').")"); |
|
929 | 929 | if (!getDolGlobalString('WITHDRAWAL_ALLOW_ANY_INVOICE_STATUS')) { |
930 | - $sql .= ($type !== 'salary' ? " AND f.fk_statut = " . Facture::STATUS_VALIDATED : " AND s.paye = " . Salary::STATUS_UNPAID); |
|
930 | + $sql .= ($type !== 'salary' ? " AND f.fk_statut = ".Facture::STATUS_VALIDATED : " AND s.paye = ".Salary::STATUS_UNPAID); |
|
931 | 931 | } |
932 | 932 | if ($type !== 'salary') { |
933 | 933 | if ($mode != 'bank-transfer') { |
@@ -952,7 +952,7 @@ discard block |
||
952 | 952 | return $obj->nb; |
953 | 953 | } else { |
954 | 954 | $error = 1; |
955 | - dol_syslog(get_class($this) . "::SommeAPrelever Erreur -1"); |
|
955 | + dol_syslog(get_class($this)."::SommeAPrelever Erreur -1"); |
|
956 | 956 | dol_syslog($this->db->error()); |
957 | 957 | |
958 | 958 | return -1; |
@@ -988,26 +988,26 @@ discard block |
||
988 | 988 | // phpcs:enable |
989 | 989 | if ($forsalary == 1) { |
990 | 990 | $sql = "SELECT count(s.rowid) as nb"; |
991 | - $sql .= " FROM " . MAIN_DB_PREFIX . "salary as s"; |
|
991 | + $sql .= " FROM ".MAIN_DB_PREFIX."salary as s"; |
|
992 | 992 | } else { |
993 | 993 | $sql = "SELECT count(f.rowid) as nb"; |
994 | 994 | |
995 | 995 | if ($type == 'bank-transfer') { |
996 | - $sql .= " FROM " . MAIN_DB_PREFIX . "facture_fourn as f"; |
|
996 | + $sql .= " FROM ".MAIN_DB_PREFIX."facture_fourn as f"; |
|
997 | 997 | } else { |
998 | - $sql .= " FROM " . MAIN_DB_PREFIX . "facture as f"; |
|
998 | + $sql .= " FROM ".MAIN_DB_PREFIX."facture as f"; |
|
999 | 999 | } |
1000 | 1000 | } |
1001 | - $sql .= ", " . MAIN_DB_PREFIX . "prelevement_demande as pd"; |
|
1001 | + $sql .= ", ".MAIN_DB_PREFIX."prelevement_demande as pd"; |
|
1002 | 1002 | if ($forsalary == 1) { |
1003 | - $sql .= " WHERE s.entity IN (" . getEntity('invoice') . ")"; |
|
1003 | + $sql .= " WHERE s.entity IN (".getEntity('invoice').")"; |
|
1004 | 1004 | if (!getDolGlobalString('WITHDRAWAL_ALLOW_ANY_INVOICE_STATUS')) { |
1005 | 1005 | $sql .= " AND s.paye = 0"; |
1006 | 1006 | } |
1007 | 1007 | } else { |
1008 | - $sql .= " WHERE f.entity IN (" . getEntity('invoice') . ")"; |
|
1008 | + $sql .= " WHERE f.entity IN (".getEntity('invoice').")"; |
|
1009 | 1009 | if (!getDolGlobalString('WITHDRAWAL_ALLOW_ANY_INVOICE_STATUS')) { |
1010 | - $sql .= " AND f.fk_statut = " . Facture::STATUS_VALIDATED; |
|
1010 | + $sql .= " AND f.fk_statut = ".Facture::STATUS_VALIDATED; |
|
1011 | 1011 | } |
1012 | 1012 | } |
1013 | 1013 | if ($forsalary == 1) { |
@@ -1027,7 +1027,7 @@ discard block |
||
1027 | 1027 | $sql .= " AND s.paye = 0"; |
1028 | 1028 | } |
1029 | 1029 | |
1030 | - dol_syslog(get_class($this) . "::NbFactureAPrelever"); |
|
1030 | + dol_syslog(get_class($this)."::NbFactureAPrelever"); |
|
1031 | 1031 | $resql = $this->db->query($sql); |
1032 | 1032 | |
1033 | 1033 | if ($resql) { |
@@ -1036,7 +1036,7 @@ discard block |
||
1036 | 1036 | |
1037 | 1037 | return $obj->nb; |
1038 | 1038 | } else { |
1039 | - $this->error = get_class($this) . "::NbFactureAPrelever Erreur -1 sql=" . $this->db->error(); |
|
1039 | + $this->error = get_class($this)."::NbFactureAPrelever Erreur -1 sql=".$this->db->error(); |
|
1040 | 1040 | return -1; |
1041 | 1041 | } |
1042 | 1042 | } |
@@ -1068,10 +1068,10 @@ discard block |
||
1068 | 1068 | // phpcs:enable |
1069 | 1069 | global $conf, $langs, $user; |
1070 | 1070 | |
1071 | - dol_syslog(__METHOD__ . " Bank=".$banque." Office=".$agence." mode=".$mode." format=".$format." type=".$type." did=".$did." fk_bank_account=".$fk_bank_account." sourcetype=".$sourcetype, LOG_DEBUG); |
|
1071 | + dol_syslog(__METHOD__." Bank=".$banque." Office=".$agence." mode=".$mode." format=".$format." type=".$type." did=".$did." fk_bank_account=".$fk_bank_account." sourcetype=".$sourcetype, LOG_DEBUG); |
|
1072 | 1072 | |
1073 | - require_once DOL_DOCUMENT_ROOT . "/compta/facture/class/facture.class.php"; |
|
1074 | - require_once DOL_DOCUMENT_ROOT . "/societe/class/societe.class.php"; |
|
1073 | + require_once DOL_DOCUMENT_ROOT."/compta/facture/class/facture.class.php"; |
|
1074 | + require_once DOL_DOCUMENT_ROOT."/societe/class/societe.class.php"; |
|
1075 | 1075 | |
1076 | 1076 | // Check params |
1077 | 1077 | if ($type != 'bank-transfer') { |
@@ -1105,14 +1105,14 @@ discard block |
||
1105 | 1105 | // Check if there is an iban associated to the bank transfer request or if we take the default |
1106 | 1106 | if ($did > 0) { |
1107 | 1107 | $sql = "SELECT pd.fk_societe_rib"; |
1108 | - $sql .= " FROM " . $this->db->prefix() . "prelevement_demande as pd"; |
|
1108 | + $sql .= " FROM ".$this->db->prefix()."prelevement_demande as pd"; |
|
1109 | 1109 | $sql .= " WHERE pd.rowid = ".((int) $did); |
1110 | 1110 | |
1111 | 1111 | $resql = $this->db->query($sql); |
1112 | 1112 | |
1113 | 1113 | if (!$resql) { |
1114 | 1114 | $this->error = $this->db->lasterror(); |
1115 | - dol_syslog(__METHOD__ . " Read fk_societe_rib error " . $this->db->lasterror(), LOG_ERR); |
|
1115 | + dol_syslog(__METHOD__." Read fk_societe_rib error ".$this->db->lasterror(), LOG_ERR); |
|
1116 | 1116 | return -1; |
1117 | 1117 | } |
1118 | 1118 | |
@@ -1120,7 +1120,7 @@ discard block |
||
1120 | 1120 | if ($obj) { |
1121 | 1121 | $thirdpartyBANId = $obj->fk_societe_rib; |
1122 | 1122 | |
1123 | - dol_syslog(__METHOD__ . " Found an BAN ID to use: ".$thirdpartyBANId); |
|
1123 | + dol_syslog(__METHOD__." Found an BAN ID to use: ".$thirdpartyBANId); |
|
1124 | 1124 | } |
1125 | 1125 | |
1126 | 1126 | $this->db->free($resql); |
@@ -1146,10 +1146,10 @@ discard block |
||
1146 | 1146 | $factures_errors = array(); |
1147 | 1147 | |
1148 | 1148 | if (!$error) { |
1149 | - dol_syslog(__METHOD__ . " Read invoices for did=" . ((int) $did), LOG_DEBUG); |
|
1149 | + dol_syslog(__METHOD__." Read invoices for did=".((int) $did), LOG_DEBUG); |
|
1150 | 1150 | |
1151 | 1151 | $sql = "SELECT f.rowid, pd.rowid as pfdrowid"; |
1152 | - $sql .= ", f.".$this->db->sanitize($socOrUser); // fk_soc or fk_user |
|
1152 | + $sql .= ", f.".$this->db->sanitize($socOrUser); // fk_soc or fk_user |
|
1153 | 1153 | $sql .= ", pd.code_banque, pd.code_guichet, pd.number, pd.cle_rib"; |
1154 | 1154 | $sql .= ", pd.amount"; |
1155 | 1155 | if ($sourcetype != 'salary') { |
@@ -1159,13 +1159,13 @@ discard block |
||
1159 | 1159 | $sql .= ", CONCAT(s.firstname,' ',s.lastname) as name"; |
1160 | 1160 | $sql .= ", f.ref, sr.bic, sr.iban_prefix, 'FRST' as frstrecur"; |
1161 | 1161 | } |
1162 | - $sql .= " FROM " . $this->db->prefix() . $sqlTable . " as f"; // f is salary, facture or facture_fourn |
|
1163 | - $sql .= " LEFT JOIN " . $this->db->prefix() . "prelevement_demande as pd ON f.rowid = pd.fk_".$this->db->sanitize($sqlTable); |
|
1164 | - $sql .= " LEFT JOIN " . $this->db->prefix() . $this->db->sanitize($societeOrUser)." as s ON s.rowid = f.".$this->db->sanitize($socOrUser); |
|
1165 | - $sql .= " LEFT JOIN " . $this->db->prefix() . $this->db->sanitize($societeOrUser."_rib")." as sr ON s.rowid = sr.".$this->db->sanitize($socOrUser); |
|
1162 | + $sql .= " FROM ".$this->db->prefix().$sqlTable." as f"; // f is salary, facture or facture_fourn |
|
1163 | + $sql .= " LEFT JOIN ".$this->db->prefix()."prelevement_demande as pd ON f.rowid = pd.fk_".$this->db->sanitize($sqlTable); |
|
1164 | + $sql .= " LEFT JOIN ".$this->db->prefix().$this->db->sanitize($societeOrUser)." as s ON s.rowid = f.".$this->db->sanitize($socOrUser); |
|
1165 | + $sql .= " LEFT JOIN ".$this->db->prefix().$this->db->sanitize($societeOrUser."_rib")." as sr ON s.rowid = sr.".$this->db->sanitize($socOrUser); |
|
1166 | 1166 | if ($sourcetype != 'salary') { |
1167 | 1167 | if (!empty($thirdpartyBANId)) { |
1168 | - $sql .= " AND sr.rowid = " . ((int) $thirdpartyBANId); |
|
1168 | + $sql .= " AND sr.rowid = ".((int) $thirdpartyBANId); |
|
1169 | 1169 | } else { |
1170 | 1170 | $sql .= " AND sr.default_rib = 1"; |
1171 | 1171 | } |
@@ -1185,10 +1185,10 @@ discard block |
||
1185 | 1185 | $sql .= " AND pd.traite = 0"; |
1186 | 1186 | $sql .= " AND pd.ext_payment_id IS NULL"; |
1187 | 1187 | if ($sourcetype != 'salary') { |
1188 | - $sql .= " AND sr.type = 'ban'"; // TODO Add AND sr.type = 'ban' for users too |
|
1188 | + $sql .= " AND sr.type = 'ban'"; // TODO Add AND sr.type = 'ban' for users too |
|
1189 | 1189 | } |
1190 | 1190 | if ($did > 0) { |
1191 | - $sql .= " AND pd.rowid = " . ((int) $did); |
|
1191 | + $sql .= " AND pd.rowid = ".((int) $did); |
|
1192 | 1192 | } |
1193 | 1193 | |
1194 | 1194 | $resql = $this->db->query($sql); |
@@ -1197,7 +1197,7 @@ discard block |
||
1197 | 1197 | $i = 0; |
1198 | 1198 | |
1199 | 1199 | while ($i < $num) { |
1200 | - $row = $this->db->fetch_row($resql); // TODO Replace with fetch_object() |
|
1200 | + $row = $this->db->fetch_row($resql); // TODO Replace with fetch_object() |
|
1201 | 1201 | '@phan-var-force array<int<0,12>,string> $row'; |
1202 | 1202 | |
1203 | 1203 | // All fields: 0=rowid, 1=pfdrowid, 2=$socOrUser, 3=code_banque, 4=code_guichet, 5=number, 6=key, 7=amount, 8=name, 9=ref, 10=bic, 11=iban, 12=frstrecur |
@@ -1208,35 +1208,35 @@ discard block |
||
1208 | 1208 | |
1209 | 1209 | if ($row[7] == 0) { |
1210 | 1210 | $error++; |
1211 | - dol_syslog(__METHOD__ . " Read invoices/salary error Found a null amount", LOG_ERR); |
|
1212 | - $this->invoice_in_error[$row[0]] = "Error for invoice or salary id " . $row[0] . ", found a null amount"; |
|
1211 | + dol_syslog(__METHOD__." Read invoices/salary error Found a null amount", LOG_ERR); |
|
1212 | + $this->invoice_in_error[$row[0]] = "Error for invoice or salary id ".$row[0].", found a null amount"; |
|
1213 | 1213 | break; |
1214 | 1214 | } |
1215 | 1215 | $i++; |
1216 | 1216 | } |
1217 | 1217 | |
1218 | 1218 | $this->db->free($resql); |
1219 | - dol_syslog(__METHOD__ . " Read invoices/salary, " . $i . " invoices/salary to withdraw", LOG_DEBUG); |
|
1219 | + dol_syslog(__METHOD__." Read invoices/salary, ".$i." invoices/salary to withdraw", LOG_DEBUG); |
|
1220 | 1220 | } else { |
1221 | 1221 | $this->error = $this->db->lasterror(); |
1222 | - dol_syslog(__METHOD__ . " Read invoices/salary error " . $this->db->lasterror(), LOG_ERR); |
|
1222 | + dol_syslog(__METHOD__." Read invoices/salary error ".$this->db->lasterror(), LOG_ERR); |
|
1223 | 1223 | return -1; |
1224 | 1224 | } |
1225 | 1225 | } |
1226 | 1226 | |
1227 | 1227 | if (!$error) { |
1228 | 1228 | // Make some checks |
1229 | - require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; |
|
1230 | - require_once DOL_DOCUMENT_ROOT . '/user/class/user.class.php'; |
|
1231 | - require_once DOL_DOCUMENT_ROOT . '/societe/class/companybankaccount.class.php'; |
|
1232 | - require_once DOL_DOCUMENT_ROOT . '/core/lib/bank.lib.php'; |
|
1229 | + require_once DOL_DOCUMENT_ROOT.'/societe/class/societe.class.php'; |
|
1230 | + require_once DOL_DOCUMENT_ROOT.'/user/class/user.class.php'; |
|
1231 | + require_once DOL_DOCUMENT_ROOT.'/societe/class/companybankaccount.class.php'; |
|
1232 | + require_once DOL_DOCUMENT_ROOT.'/core/lib/bank.lib.php'; |
|
1233 | 1233 | |
1234 | 1234 | $tmpsoc = new Societe($this->db); |
1235 | 1235 | $tmpuser = new User($this->db); |
1236 | 1236 | |
1237 | 1237 | // Check BAN |
1238 | 1238 | $i = 0; |
1239 | - dol_syslog(__METHOD__ . " Check BAN for each invoices or salary", LOG_DEBUG); |
|
1239 | + dol_syslog(__METHOD__." Check BAN for each invoices or salary", LOG_DEBUG); |
|
1240 | 1240 | |
1241 | 1241 | if (count($factures) > 0) { |
1242 | 1242 | foreach ($factures as $key => $fac) { |
@@ -1267,31 +1267,31 @@ discard block |
||
1267 | 1267 | if ($type != 'bank-transfer') { |
1268 | 1268 | $tmpsoc->id = (int) $fac[2]; |
1269 | 1269 | $tmpsoc->name = $fac[8]; |
1270 | - $invoice_url = "<a href='" . DOL_URL_ROOT . '/compta/facture/card.php?facid=' . $fac[0] . "'>" . $fac[9] . "</a>"; |
|
1271 | - $this->invoice_in_error[$fac[0]] = "Error on default bank number IBAN/BIC for invoice " . $invoice_url . " for thirdparty " . $tmpsoc->getNomUrl(0); |
|
1272 | - $this->thirdparty_in_error[$tmpsoc->id] = "Error on default bank number IBAN/BIC for invoice " . $invoice_url . " for thirdparty " . $tmpsoc->getNomUrl(0); |
|
1270 | + $invoice_url = "<a href='".DOL_URL_ROOT.'/compta/facture/card.php?facid='.$fac[0]."'>".$fac[9]."</a>"; |
|
1271 | + $this->invoice_in_error[$fac[0]] = "Error on default bank number IBAN/BIC for invoice ".$invoice_url." for thirdparty ".$tmpsoc->getNomUrl(0); |
|
1272 | + $this->thirdparty_in_error[$tmpsoc->id] = "Error on default bank number IBAN/BIC for invoice ".$invoice_url." for thirdparty ".$tmpsoc->getNomUrl(0); |
|
1273 | 1273 | $error++; |
1274 | 1274 | } |
1275 | 1275 | if ($type == 'bank-transfer' && $sourcetype != 'salary') { |
1276 | 1276 | $tmpsoc->id = (int) $fac[2]; |
1277 | 1277 | $tmpsoc->name = $fac[8]; |
1278 | - $invoice_url = "<a href='" . DOL_URL_ROOT . '/fourn/facture/card.php?facid=' . $fac[0] . "'>" . $fac[9] . "</a>"; |
|
1279 | - $this->invoice_in_error[$fac[0]] = "Error on default bank number IBAN/BIC for invoice " . $invoice_url . " for thirdparty " . $tmpsoc->getNomUrl(0); |
|
1280 | - $this->thirdparty_in_error[$tmpsoc->id] = "Error on default bank number IBAN/BIC for invoice " . $invoice_url . " for thirdparty " . $tmpsoc->getNomUrl(0); |
|
1278 | + $invoice_url = "<a href='".DOL_URL_ROOT.'/fourn/facture/card.php?facid='.$fac[0]."'>".$fac[9]."</a>"; |
|
1279 | + $this->invoice_in_error[$fac[0]] = "Error on default bank number IBAN/BIC for invoice ".$invoice_url." for thirdparty ".$tmpsoc->getNomUrl(0); |
|
1280 | + $this->thirdparty_in_error[$tmpsoc->id] = "Error on default bank number IBAN/BIC for invoice ".$invoice_url." for thirdparty ".$tmpsoc->getNomUrl(0); |
|
1281 | 1281 | $error++; |
1282 | 1282 | } |
1283 | 1283 | if ($type == 'bank-transfer' && $sourcetype == 'salary') { |
1284 | 1284 | $tmpuser->id = (int) $fac[2]; |
1285 | 1285 | $tmpuser->firstname = $fac[8]; |
1286 | - $salary_url = "<a href='" . DOL_URL_ROOT . '/salaries/card.php?id=' . $fac[0] . "'>" . $fac[0] . "</a>"; |
|
1287 | - $this->invoice_in_error[$fac[0]] = "Error on default bank number IBAN/BIC for salary " . $salary_url . " for employee " . $tmpuser->getNomUrl(0); |
|
1288 | - $this->thirdparty_in_error[$tmpuser->id] = "Error on default bank number IBAN/BIC for salary " . $salary_url . " for employee " . $tmpuser->getNomUrl(0); |
|
1286 | + $salary_url = "<a href='".DOL_URL_ROOT.'/salaries/card.php?id='.$fac[0]."'>".$fac[0]."</a>"; |
|
1287 | + $this->invoice_in_error[$fac[0]] = "Error on default bank number IBAN/BIC for salary ".$salary_url." for employee ".$tmpuser->getNomUrl(0); |
|
1288 | + $this->thirdparty_in_error[$tmpuser->id] = "Error on default bank number IBAN/BIC for salary ".$salary_url." for employee ".$tmpuser->getNomUrl(0); |
|
1289 | 1289 | $error++; |
1290 | 1290 | } |
1291 | - dol_syslog(__METHOD__ . " Check BAN Error on default bank number IBAN/BIC reported by verif(): " . implode(', ', $fac), LOG_WARNING); |
|
1291 | + dol_syslog(__METHOD__." Check BAN Error on default bank number IBAN/BIC reported by verif(): ".implode(', ', $fac), LOG_WARNING); |
|
1292 | 1292 | } |
1293 | 1293 | } else { |
1294 | - dol_syslog(__METHOD__ . " Check BAN Failed to read company", LOG_WARNING); |
|
1294 | + dol_syslog(__METHOD__." Check BAN Failed to read company", LOG_WARNING); |
|
1295 | 1295 | } |
1296 | 1296 | /* |
1297 | 1297 | } else { |
@@ -1300,14 +1300,14 @@ discard block |
||
1300 | 1300 | */ |
1301 | 1301 | } |
1302 | 1302 | } else { |
1303 | - dol_syslog(__METHOD__ . " Check BAN No invoice to process", LOG_WARNING); |
|
1303 | + dol_syslog(__METHOD__." Check BAN No invoice to process", LOG_WARNING); |
|
1304 | 1304 | } |
1305 | 1305 | } |
1306 | 1306 | |
1307 | 1307 | $ok = 0; |
1308 | 1308 | |
1309 | 1309 | // Withdraw invoices in factures_prev array |
1310 | - $out = count($factures_prev) . " invoices or salaries will be included."; |
|
1310 | + $out = count($factures_prev)." invoices or salaries will be included."; |
|
1311 | 1311 | //print $out."\n"; |
1312 | 1312 | dol_syslog($out); |
1313 | 1313 | |
@@ -1341,32 +1341,32 @@ discard block |
||
1341 | 1341 | * Process order generation |
1342 | 1342 | */ |
1343 | 1343 | if (!$error) { |
1344 | - $ref = substr($year, -2) . $month; |
|
1344 | + $ref = substr($year, -2).$month; |
|
1345 | 1345 | |
1346 | 1346 | // Get next free number for the ref of bon prelevement |
1347 | - $sql = "SELECT substring(ref from char_length(ref) - 1)"; // To extract "YYMMXX" from "TYYMMXX" |
|
1348 | - $sql .= " FROM " . MAIN_DB_PREFIX . "prelevement_bons"; |
|
1349 | - $sql .= " WHERE ref LIKE '_" . $this->db->escape($ref) . "%'"; |
|
1350 | - $sql .= " AND entity = " . ((int) $conf->entity); |
|
1347 | + $sql = "SELECT substring(ref from char_length(ref) - 1)"; // To extract "YYMMXX" from "TYYMMXX" |
|
1348 | + $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_bons"; |
|
1349 | + $sql .= " WHERE ref LIKE '_".$this->db->escape($ref)."%'"; |
|
1350 | + $sql .= " AND entity = ".((int) $conf->entity); |
|
1351 | 1351 | $sql .= " ORDER BY ref DESC LIMIT 1"; |
1352 | 1352 | |
1353 | - dol_syslog(get_class($this) . " get next free number", LOG_DEBUG); |
|
1353 | + dol_syslog(get_class($this)." get next free number", LOG_DEBUG); |
|
1354 | 1354 | $resql = $this->db->query($sql); |
1355 | 1355 | |
1356 | 1356 | if ($resql) { |
1357 | 1357 | $row = $this->db->fetch_row($resql); |
1358 | 1358 | |
1359 | 1359 | // Build the new ref |
1360 | - $ref = "T" . $ref . sprintf("%02d", (intval($row[0]) + 1)); |
|
1360 | + $ref = "T".$ref.sprintf("%02d", (intval($row[0]) + 1)); |
|
1361 | 1361 | |
1362 | 1362 | // $conf->abc->dir_output may be: |
1363 | 1363 | // /home/ldestailleur/git/dolibarr_15.0/documents/abc/ |
1364 | 1364 | // or |
1365 | 1365 | // /home/ldestailleur/git/dolibarr_15.0/documents/X/abc with X >= 2 with multicompany. |
1366 | 1366 | if ($type != 'bank-transfer') { |
1367 | - $dir = $conf->prelevement->dir_output . '/receipts'; |
|
1367 | + $dir = $conf->prelevement->dir_output.'/receipts'; |
|
1368 | 1368 | } else { |
1369 | - $dir = $conf->paymentbybanktransfer->dir_output . '/receipts'; |
|
1369 | + $dir = $conf->paymentbybanktransfer->dir_output.'/receipts'; |
|
1370 | 1370 | } |
1371 | 1371 | if (!is_dir($dir)) { |
1372 | 1372 | dol_mkdir($dir); |
@@ -1374,41 +1374,41 @@ discard block |
||
1374 | 1374 | |
1375 | 1375 | if (isModEnabled('multicompany')) { |
1376 | 1376 | $labelentity = $conf->entity; |
1377 | - $this->filename = $dir . '/' . $ref . '-' . $labelentity . '.xml'; |
|
1377 | + $this->filename = $dir.'/'.$ref.'-'.$labelentity.'.xml'; |
|
1378 | 1378 | } else { |
1379 | - $this->filename = $dir . '/' . $ref . '.xml'; |
|
1379 | + $this->filename = $dir.'/'.$ref.'.xml'; |
|
1380 | 1380 | } |
1381 | 1381 | |
1382 | 1382 | // Create withdraw order in database |
1383 | - $sql = "INSERT INTO " . MAIN_DB_PREFIX . "prelevement_bons ("; |
|
1383 | + $sql = "INSERT INTO ".MAIN_DB_PREFIX."prelevement_bons ("; |
|
1384 | 1384 | $sql .= "ref, entity, datec, type, fk_bank_account"; |
1385 | 1385 | $sql .= ") VALUES ("; |
1386 | - $sql .= "'" . $this->db->escape($ref) . "'"; |
|
1387 | - $sql .= ", " . ((int) $conf->entity); |
|
1388 | - $sql .= ", '" . $this->db->idate($now) . "'"; |
|
1389 | - $sql .= ", '" . ($type == 'bank-transfer' ? 'bank-transfer' : 'debit-order') . "'"; |
|
1390 | - $sql .= ", " . ((int) $fk_bank_account); |
|
1386 | + $sql .= "'".$this->db->escape($ref)."'"; |
|
1387 | + $sql .= ", ".((int) $conf->entity); |
|
1388 | + $sql .= ", '".$this->db->idate($now)."'"; |
|
1389 | + $sql .= ", '".($type == 'bank-transfer' ? 'bank-transfer' : 'debit-order')."'"; |
|
1390 | + $sql .= ", ".((int) $fk_bank_account); |
|
1391 | 1391 | $sql .= ")"; |
1392 | 1392 | |
1393 | 1393 | $resql = $this->db->query($sql); |
1394 | 1394 | |
1395 | 1395 | |
1396 | 1396 | if ($resql) { |
1397 | - $prev_id = $this->db->last_insert_id(MAIN_DB_PREFIX . "prelevement_bons"); |
|
1397 | + $prev_id = $this->db->last_insert_id(MAIN_DB_PREFIX."prelevement_bons"); |
|
1398 | 1398 | $this->id = $prev_id; |
1399 | 1399 | $this->ref = $ref; |
1400 | 1400 | } else { |
1401 | 1401 | $error++; |
1402 | - dol_syslog(__METHOD__ . " Create withdraw receipt " . $this->db->lasterror(), LOG_ERR); |
|
1402 | + dol_syslog(__METHOD__." Create withdraw receipt ".$this->db->lasterror(), LOG_ERR); |
|
1403 | 1403 | } |
1404 | 1404 | } else { |
1405 | 1405 | $error++; |
1406 | - dol_syslog(__METHOD__ . " Get last withdraw receipt " . $this->db->lasterror(), LOG_ERR); |
|
1406 | + dol_syslog(__METHOD__." Get last withdraw receipt ".$this->db->lasterror(), LOG_ERR); |
|
1407 | 1407 | } |
1408 | 1408 | } |
1409 | 1409 | |
1410 | 1410 | if (!$error) { |
1411 | - dol_syslog(__METHOD__ . " Now loop on each document to insert them in llx_prelevement_demande"); |
|
1411 | + dol_syslog(__METHOD__." Now loop on each document to insert them in llx_prelevement_demande"); |
|
1412 | 1412 | |
1413 | 1413 | // Add lines for the bon |
1414 | 1414 | if (count($factures_prev) > 0) { |
@@ -1437,17 +1437,17 @@ discard block |
||
1437 | 1437 | } |
1438 | 1438 | |
1439 | 1439 | // Update invoice requests as done |
1440 | - $sql = "UPDATE " . MAIN_DB_PREFIX . "prelevement_demande"; |
|
1440 | + $sql = "UPDATE ".MAIN_DB_PREFIX."prelevement_demande"; |
|
1441 | 1441 | $sql .= " SET traite = 1"; |
1442 | - $sql .= ", date_traite = '" . $this->db->idate($now) . "'"; |
|
1443 | - $sql .= ", fk_prelevement_bons = " . ((int) $this->id); |
|
1444 | - $sql .= " WHERE rowid = " . ((int) $fac[1]); |
|
1442 | + $sql .= ", date_traite = '".$this->db->idate($now)."'"; |
|
1443 | + $sql .= ", fk_prelevement_bons = ".((int) $this->id); |
|
1444 | + $sql .= " WHERE rowid = ".((int) $fac[1]); |
|
1445 | 1445 | |
1446 | 1446 | $resql = $this->db->query($sql); |
1447 | 1447 | if (!$resql) { |
1448 | 1448 | $error++; |
1449 | 1449 | $this->errors[] = $this->db->lasterror(); |
1450 | - dol_syslog(__METHOD__ . " Update Error=" . $this->db->lasterror(), LOG_ERR); |
|
1450 | + dol_syslog(__METHOD__." Update Error=".$this->db->lasterror(), LOG_ERR); |
|
1451 | 1451 | } |
1452 | 1452 | } |
1453 | 1453 | } |
@@ -1458,7 +1458,7 @@ discard block |
||
1458 | 1458 | * Create file of type='direct-debit' for direct debit order or type='bank-transfer' for credit transfer into a XML file |
1459 | 1459 | */ |
1460 | 1460 | |
1461 | - dol_syslog(__METHOD__ . " Init direct debit or credit transfer file for " . count($factures_prev) . " invoices", LOG_DEBUG); |
|
1461 | + dol_syslog(__METHOD__." Init direct debit or credit transfer file for ".count($factures_prev)." invoices", LOG_DEBUG); |
|
1462 | 1462 | |
1463 | 1463 | if (count($factures_prev) > 0) { |
1464 | 1464 | $this->date_echeance = $datetimeprev; |
@@ -1474,7 +1474,7 @@ discard block |
||
1474 | 1474 | $this->emetteur_iban = $account->iban; |
1475 | 1475 | $this->emetteur_bic = $account->bic; |
1476 | 1476 | |
1477 | - $this->emetteur_ics = (($type == 'bank-transfer' && getDolGlobalString("SEPA_USE_IDS")) ? $account->ics_transfer : $account->ics); // Example "FR78ZZZ123456" |
|
1477 | + $this->emetteur_ics = (($type == 'bank-transfer' && getDolGlobalString("SEPA_USE_IDS")) ? $account->ics_transfer : $account->ics); // Example "FR78ZZZ123456" |
|
1478 | 1478 | |
1479 | 1479 | $this->raison_sociale = $account->owner_name; |
1480 | 1480 | } |
@@ -1493,7 +1493,7 @@ discard block |
||
1493 | 1493 | $error++; |
1494 | 1494 | } |
1495 | 1495 | } |
1496 | - dol_syslog(__METHOD__ . " Bank order file has been generated under filename " . $this->filename, LOG_DEBUG); |
|
1496 | + dol_syslog(__METHOD__." Bank order file has been generated under filename ".$this->filename, LOG_DEBUG); |
|
1497 | 1497 | } |
1498 | 1498 | |
1499 | 1499 | |
@@ -1501,15 +1501,15 @@ discard block |
||
1501 | 1501 | * Update total defined after generation of file |
1502 | 1502 | */ |
1503 | 1503 | if (!$error) { |
1504 | - $sql = "UPDATE " . MAIN_DB_PREFIX . "prelevement_bons"; |
|
1505 | - $sql .= " SET amount = " . price2num($this->total); |
|
1506 | - $sql .= " WHERE rowid = " . ((int) $this->id); |
|
1507 | - $sql .= " AND entity = " . ((int) $conf->entity); |
|
1504 | + $sql = "UPDATE ".MAIN_DB_PREFIX."prelevement_bons"; |
|
1505 | + $sql .= " SET amount = ".price2num($this->total); |
|
1506 | + $sql .= " WHERE rowid = ".((int) $this->id); |
|
1507 | + $sql .= " AND entity = ".((int) $conf->entity); |
|
1508 | 1508 | $resql = $this->db->query($sql); |
1509 | 1509 | |
1510 | 1510 | if (!$resql) { |
1511 | 1511 | $error++; |
1512 | - dol_syslog(__METHOD__ . " Error update total: " . $this->db->error(), LOG_ERR); |
|
1512 | + dol_syslog(__METHOD__." Error update total: ".$this->db->error(), LOG_ERR); |
|
1513 | 1513 | } |
1514 | 1514 | } |
1515 | 1515 | |
@@ -1529,7 +1529,7 @@ discard block |
||
1529 | 1529 | |
1530 | 1530 | if (!$error) { |
1531 | 1531 | $this->db->commit(); |
1532 | - return count($factures_prev); // The error of failed lines are into $this->invoice_in_error and $this->thirdparty_in_error |
|
1532 | + return count($factures_prev); // The error of failed lines are into $this->invoice_in_error and $this->thirdparty_in_error |
|
1533 | 1533 | } else { |
1534 | 1534 | $this->db->rollback(); |
1535 | 1535 | return -1; |
@@ -1568,7 +1568,7 @@ discard block |
||
1568 | 1568 | } |
1569 | 1569 | |
1570 | 1570 | if (!$error) { |
1571 | - $sql = "DELETE FROM " . MAIN_DB_PREFIX . "prelevement WHERE fk_prelevement_lignes IN (SELECT rowid FROM " . MAIN_DB_PREFIX . "prelevement_lignes WHERE fk_prelevement_bons = " . ((int) $this->id) . ")"; |
|
1571 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."prelevement WHERE fk_prelevement_lignes IN (SELECT rowid FROM ".MAIN_DB_PREFIX."prelevement_lignes WHERE fk_prelevement_bons = ".((int) $this->id).")"; |
|
1572 | 1572 | $resql1 = $this->db->query($sql); |
1573 | 1573 | if (!$resql1) { |
1574 | 1574 | dol_print_error($this->db); |
@@ -1576,7 +1576,7 @@ discard block |
||
1576 | 1576 | } |
1577 | 1577 | |
1578 | 1578 | if (!$error) { |
1579 | - $sql = "DELETE FROM " . MAIN_DB_PREFIX . "prelevement_lignes WHERE fk_prelevement_bons = " . ((int) $this->id); |
|
1579 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."prelevement_lignes WHERE fk_prelevement_bons = ".((int) $this->id); |
|
1580 | 1580 | $resql2 = $this->db->query($sql); |
1581 | 1581 | if (!$resql2) { |
1582 | 1582 | dol_print_error($this->db); |
@@ -1584,7 +1584,7 @@ discard block |
||
1584 | 1584 | } |
1585 | 1585 | |
1586 | 1586 | if (!$error) { |
1587 | - $sql = "DELETE FROM " . MAIN_DB_PREFIX . "prelevement_bons WHERE rowid = " . ((int) $this->id); |
|
1587 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."prelevement_bons WHERE rowid = ".((int) $this->id); |
|
1588 | 1588 | $resql3 = $this->db->query($sql); |
1589 | 1589 | if (!$resql3) { |
1590 | 1590 | dol_print_error($this->db); |
@@ -1592,7 +1592,7 @@ discard block |
||
1592 | 1592 | } |
1593 | 1593 | |
1594 | 1594 | if (!$error) { |
1595 | - $sql = "UPDATE " . MAIN_DB_PREFIX . "prelevement_demande SET fk_prelevement_bons = NULL, traite = 0 WHERE fk_prelevement_bons = " . ((int) $this->id); |
|
1595 | + $sql = "UPDATE ".MAIN_DB_PREFIX."prelevement_demande SET fk_prelevement_bons = NULL, traite = 0 WHERE fk_prelevement_bons = ".((int) $this->id); |
|
1596 | 1596 | $resql4 = $this->db->query($sql); |
1597 | 1597 | if (!$resql4) { |
1598 | 1598 | dol_print_error($this->db); |
@@ -1634,22 +1634,22 @@ discard block |
||
1634 | 1634 | $labeltoshow = 'PaymentByBankTransfer'; |
1635 | 1635 | } |
1636 | 1636 | |
1637 | - $label = img_picto('', $this->picto) . ' <u>' . $langs->trans($labeltoshow) . '</u> ' . $this->getLibStatut(5); |
|
1637 | + $label = img_picto('', $this->picto).' <u>'.$langs->trans($labeltoshow).'</u> '.$this->getLibStatut(5); |
|
1638 | 1638 | $label .= '<br>'; |
1639 | - $label .= '<b>' . $langs->trans('Ref') . ':</b> ' . $this->ref; |
|
1639 | + $label .= '<b>'.$langs->trans('Ref').':</b> '.$this->ref; |
|
1640 | 1640 | if (isset($this->amount)) { |
1641 | - $label .= '<br><b>' . $langs->trans("Amount") . ":</b> " . price($this->amount); |
|
1641 | + $label .= '<br><b>'.$langs->trans("Amount").":</b> ".price($this->amount); |
|
1642 | 1642 | } |
1643 | 1643 | if (isset($this->date_trans)) { |
1644 | - $label .= '<br><b>' . $langs->trans("TransData") . ":</b> " . dol_print_date($this->date_trans, 'dayhour', 'tzuserrel'); |
|
1644 | + $label .= '<br><b>'.$langs->trans("TransData").":</b> ".dol_print_date($this->date_trans, 'dayhour', 'tzuserrel'); |
|
1645 | 1645 | } |
1646 | 1646 | /*if (isset($this->date_credit)) { |
1647 | 1647 | $label .= '<br><b>'.$langs->trans("TransData").":</b> ".dol_print_date($this->date_credit, 'dayhour', 'tzuserrel'); |
1648 | 1648 | }*/ |
1649 | 1649 | |
1650 | - $url = DOL_URL_ROOT . '/compta/prelevement/card.php?id=' . $this->id; |
|
1650 | + $url = DOL_URL_ROOT.'/compta/prelevement/card.php?id='.$this->id; |
|
1651 | 1651 | if (!empty($this->type) && $this->type == 'bank-transfer') { |
1652 | - $url = DOL_URL_ROOT . '/compta/prelevement/card.php?id=' . $this->id; |
|
1652 | + $url = DOL_URL_ROOT.'/compta/prelevement/card.php?id='.$this->id; |
|
1653 | 1653 | } |
1654 | 1654 | |
1655 | 1655 | if ($option != 'nolink') { |
@@ -1667,21 +1667,21 @@ discard block |
||
1667 | 1667 | if (empty($notooltip)) { |
1668 | 1668 | if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) { |
1669 | 1669 | $label = $langs->trans("ShowMyObject"); |
1670 | - $linkclose .= ' alt="' . dol_escape_htmltag($label, 1) . '"'; |
|
1670 | + $linkclose .= ' alt="'.dol_escape_htmltag($label, 1).'"'; |
|
1671 | 1671 | } |
1672 | - $linkclose .= ' title="' . dol_escape_htmltag($label, 1) . '"'; |
|
1673 | - $linkclose .= ' class="classfortooltip' . ($morecss ? ' ' . $morecss : '') . '"'; |
|
1672 | + $linkclose .= ' title="'.dol_escape_htmltag($label, 1).'"'; |
|
1673 | + $linkclose .= ' class="classfortooltip'.($morecss ? ' '.$morecss : '').'"'; |
|
1674 | 1674 | } else { |
1675 | - $linkclose = ($morecss ? ' class="' . $morecss . '"' : ''); |
|
1675 | + $linkclose = ($morecss ? ' class="'.$morecss.'"' : ''); |
|
1676 | 1676 | } |
1677 | 1677 | |
1678 | - $linkstart = '<a href="' . $url . '"'; |
|
1679 | - $linkstart .= $linkclose . '>'; |
|
1678 | + $linkstart = '<a href="'.$url.'"'; |
|
1679 | + $linkstart .= $linkclose.'>'; |
|
1680 | 1680 | $linkend = '</a>'; |
1681 | 1681 | |
1682 | 1682 | $result .= $linkstart; |
1683 | 1683 | if ($withpicto) { |
1684 | - $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); |
|
1684 | + $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); |
|
1685 | 1685 | } |
1686 | 1686 | if ($withpicto != 2) { |
1687 | 1687 | $result .= $this->ref; |
@@ -1710,8 +1710,8 @@ discard block |
||
1710 | 1710 | */ |
1711 | 1711 | public function deleteNotificationById($rowid) |
1712 | 1712 | { |
1713 | - $sql = "DELETE FROM " . MAIN_DB_PREFIX . "notify_def"; |
|
1714 | - $sql .= " WHERE rowid = " . ((int) $rowid); |
|
1713 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."notify_def"; |
|
1714 | + $sql .= " WHERE rowid = ".((int) $rowid); |
|
1715 | 1715 | |
1716 | 1716 | if ($this->db->query($sql)) { |
1717 | 1717 | return 0; |
@@ -1735,8 +1735,8 @@ discard block |
||
1735 | 1735 | $userid = $user; |
1736 | 1736 | } |
1737 | 1737 | |
1738 | - $sql = "DELETE FROM " . MAIN_DB_PREFIX . "notify_def"; |
|
1739 | - $sql .= " WHERE fk_user=" . ((int) $userid) . " AND fk_action='" . $this->db->escape($action) . "'"; |
|
1738 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."notify_def"; |
|
1739 | + $sql .= " WHERE fk_user=".((int) $userid)." AND fk_action='".$this->db->escape($action)."'"; |
|
1740 | 1740 | |
1741 | 1741 | if ($this->db->query($sql)) { |
1742 | 1742 | return 0; |
@@ -1768,15 +1768,15 @@ discard block |
||
1768 | 1768 | if ($this->deleteNotification($user, $action) == 0) { |
1769 | 1769 | $now = dol_now(); |
1770 | 1770 | |
1771 | - $sql = "INSERT INTO " . MAIN_DB_PREFIX . "notify_def (datec,fk_user, fk_soc, fk_contact, fk_action)"; |
|
1772 | - $sql .= " VALUES ('" . $this->db->idate($now) . "', " . ((int) $userid) . ", 'NULL', 'NULL', '" . $this->db->escape($action) . "')"; |
|
1771 | + $sql = "INSERT INTO ".MAIN_DB_PREFIX."notify_def (datec,fk_user, fk_soc, fk_contact, fk_action)"; |
|
1772 | + $sql .= " VALUES ('".$this->db->idate($now)."', ".((int) $userid).", 'NULL', 'NULL', '".$this->db->escape($action)."')"; |
|
1773 | 1773 | |
1774 | - dol_syslog("adnotiff: " . $sql); |
|
1774 | + dol_syslog("adnotiff: ".$sql); |
|
1775 | 1775 | if ($this->db->query($sql)) { |
1776 | 1776 | $result = 0; |
1777 | 1777 | } else { |
1778 | 1778 | $result = -1; |
1779 | - dol_syslog(get_class($this) . "::addNotification Error $result"); |
|
1779 | + dol_syslog(get_class($this)."::addNotification Error $result"); |
|
1780 | 1780 | } |
1781 | 1781 | } |
1782 | 1782 | |
@@ -1812,7 +1812,7 @@ discard block |
||
1812 | 1812 | |
1813 | 1813 | $result = 0; |
1814 | 1814 | |
1815 | - dol_syslog(get_class($this) . "::generate build file=" . $this->filename . " type=" . $type); |
|
1815 | + dol_syslog(get_class($this)."::generate build file=".$this->filename." type=".$type); |
|
1816 | 1816 | |
1817 | 1817 | $this->file = fopen($this->filename, "w"); |
1818 | 1818 | if ($this->file == false) { |
@@ -1858,20 +1858,20 @@ discard block |
||
1858 | 1858 | $sql .= " f.ref as reffac, p.fk_facture as idfac,"; |
1859 | 1859 | $sql .= " rib.rowid, rib.datec, rib.iban_prefix as iban, rib.bic as bic, rib.rowid as drum, rib.rum, rib.date_rum"; |
1860 | 1860 | $sql .= " FROM"; |
1861 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_lignes as pl,"; |
|
1862 | - $sql .= " " . MAIN_DB_PREFIX . "facture as f,"; |
|
1863 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement as p,"; |
|
1864 | - $sql .= " " . MAIN_DB_PREFIX . "societe as soc,"; |
|
1865 | - $sql .= " " . MAIN_DB_PREFIX . "c_country as c,"; |
|
1866 | - $sql .= " " . MAIN_DB_PREFIX . "societe_rib as rib"; |
|
1867 | - $sql .= " WHERE pl.fk_prelevement_bons = " . ((int) $this->id); |
|
1861 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_lignes as pl,"; |
|
1862 | + $sql .= " ".MAIN_DB_PREFIX."facture as f,"; |
|
1863 | + $sql .= " ".MAIN_DB_PREFIX."prelevement as p,"; |
|
1864 | + $sql .= " ".MAIN_DB_PREFIX."societe as soc,"; |
|
1865 | + $sql .= " ".MAIN_DB_PREFIX."c_country as c,"; |
|
1866 | + $sql .= " ".MAIN_DB_PREFIX."societe_rib as rib"; |
|
1867 | + $sql .= " WHERE pl.fk_prelevement_bons = ".((int) $this->id); |
|
1868 | 1868 | $sql .= " AND pl.rowid = p.fk_prelevement_lignes"; |
1869 | 1869 | $sql .= " AND p.fk_facture = f.rowid"; |
1870 | 1870 | $sql .= " AND f.fk_soc = soc.rowid"; |
1871 | 1871 | $sql .= " AND soc.fk_pays = c.rowid"; |
1872 | 1872 | $sql .= " AND rib.fk_soc = f.fk_soc"; |
1873 | 1873 | if (!empty($thirdpartyBANId)) { |
1874 | - $sql .= " AND rib.rowid = " . ((int) $thirdpartyBANId); |
|
1874 | + $sql .= " AND rib.rowid = ".((int) $thirdpartyBANId); |
|
1875 | 1875 | } else { |
1876 | 1876 | $sql .= " AND rib.default_rib = 1"; |
1877 | 1877 | } |
@@ -1906,7 +1906,7 @@ discard block |
||
1906 | 1906 | $nbtotalDrctDbtTxInf = $i; |
1907 | 1907 | } else { |
1908 | 1908 | $this->error = $this->db->lasterror(); |
1909 | - fwrite($this->file, 'ERROR DEBITOR ' . $sql . $CrLf); // DEBITOR = Customers |
|
1909 | + fwrite($this->file, 'ERROR DEBITOR '.$sql.$CrLf); // DEBITOR = Customers |
|
1910 | 1910 | $result = -2; |
1911 | 1911 | } |
1912 | 1912 | |
@@ -1923,26 +1923,26 @@ discard block |
||
1923 | 1923 | * SECTION CREATION SEPA FILE - ISO200022 |
1924 | 1924 | */ |
1925 | 1925 | // SEPA File Header |
1926 | - fwrite($this->file, '<' . '?xml version="1.0" encoding="UTF-8" standalone="yes"?' . '>' . $CrLf); |
|
1927 | - fwrite($this->file, '<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' . $CrLf); |
|
1928 | - fwrite($this->file, ' <CstmrDrctDbtInitn>' . $CrLf); |
|
1926 | + fwrite($this->file, '<'.'?xml version="1.0" encoding="UTF-8" standalone="yes"?'.'>'.$CrLf); |
|
1927 | + fwrite($this->file, '<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">'.$CrLf); |
|
1928 | + fwrite($this->file, ' <CstmrDrctDbtInitn>'.$CrLf); |
|
1929 | 1929 | // SEPA Group header |
1930 | - fwrite($this->file, ' <GrpHdr>' . $CrLf); |
|
1931 | - fwrite($this->file, ' <MsgId>' . ('DOL/' . $dateTime_YMD . '/DD' . $this->id) . '</MsgId>' . $CrLf); |
|
1932 | - fwrite($this->file, ' <CreDtTm>' . $dateTime_ECMA . '</CreDtTm>' . $CrLf); |
|
1933 | - fwrite($this->file, ' <NbOfTxs>' . $i . '</NbOfTxs>' . $CrLf); |
|
1934 | - fwrite($this->file, ' <CtrlSum>' . $this->total . '</CtrlSum>' . $CrLf); |
|
1935 | - fwrite($this->file, ' <InitgPty>' . $CrLf); |
|
1936 | - fwrite($this->file, ' <Nm>' . dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))) . '</Nm>' . $CrLf); |
|
1937 | - fwrite($this->file, ' <Id>' . $CrLf); |
|
1938 | - fwrite($this->file, ' <PrvtId>' . $CrLf); |
|
1939 | - fwrite($this->file, ' <Othr>' . $CrLf); |
|
1940 | - fwrite($this->file, ' <Id>' . $this->emetteur_ics . '</Id>' . $CrLf); |
|
1941 | - fwrite($this->file, ' </Othr>' . $CrLf); |
|
1942 | - fwrite($this->file, ' </PrvtId>' . $CrLf); |
|
1943 | - fwrite($this->file, ' </Id>' . $CrLf); |
|
1944 | - fwrite($this->file, ' </InitgPty>' . $CrLf); |
|
1945 | - fwrite($this->file, ' </GrpHdr>' . $CrLf); |
|
1930 | + fwrite($this->file, ' <GrpHdr>'.$CrLf); |
|
1931 | + fwrite($this->file, ' <MsgId>'.('DOL/'.$dateTime_YMD.'/DD'.$this->id).'</MsgId>'.$CrLf); |
|
1932 | + fwrite($this->file, ' <CreDtTm>'.$dateTime_ECMA.'</CreDtTm>'.$CrLf); |
|
1933 | + fwrite($this->file, ' <NbOfTxs>'.$i.'</NbOfTxs>'.$CrLf); |
|
1934 | + fwrite($this->file, ' <CtrlSum>'.$this->total.'</CtrlSum>'.$CrLf); |
|
1935 | + fwrite($this->file, ' <InitgPty>'.$CrLf); |
|
1936 | + fwrite($this->file, ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))).'</Nm>'.$CrLf); |
|
1937 | + fwrite($this->file, ' <Id>'.$CrLf); |
|
1938 | + fwrite($this->file, ' <PrvtId>'.$CrLf); |
|
1939 | + fwrite($this->file, ' <Othr>'.$CrLf); |
|
1940 | + fwrite($this->file, ' <Id>'.$this->emetteur_ics.'</Id>'.$CrLf); |
|
1941 | + fwrite($this->file, ' </Othr>'.$CrLf); |
|
1942 | + fwrite($this->file, ' </PrvtId>'.$CrLf); |
|
1943 | + fwrite($this->file, ' </Id>'.$CrLf); |
|
1944 | + fwrite($this->file, ' </InitgPty>'.$CrLf); |
|
1945 | + fwrite($this->file, ' </GrpHdr>'.$CrLf); |
|
1946 | 1946 | // SEPA File Emetteur |
1947 | 1947 | if ($result != -2) { |
1948 | 1948 | fwrite($this->file, $fileEmetteurSection); |
@@ -1952,9 +1952,9 @@ discard block |
||
1952 | 1952 | fwrite($this->file, $fileDebiteurSection); |
1953 | 1953 | } |
1954 | 1954 | // SEPA FILE FOOTER |
1955 | - fwrite($this->file, ' </PmtInf>' . $CrLf); |
|
1956 | - fwrite($this->file, ' </CstmrDrctDbtInitn>' . $CrLf); |
|
1957 | - fwrite($this->file, '</Document>' . $CrLf); |
|
1955 | + fwrite($this->file, ' </PmtInf>'.$CrLf); |
|
1956 | + fwrite($this->file, ' </CstmrDrctDbtInitn>'.$CrLf); |
|
1957 | + fwrite($this->file, '</Document>'.$CrLf); |
|
1958 | 1958 | } else { |
1959 | 1959 | /** |
1960 | 1960 | * SECTION CREATION FICHIER SEPA - CREDIT TRANSFER |
@@ -1986,13 +1986,13 @@ discard block |
||
1986 | 1986 | $sql .= " s.ref as reffac, p.fk_salary as idfac,"; |
1987 | 1987 | $sql .= " rib.rowid, rib.datec, rib.iban_prefix as iban, rib.bic as bic, rib.rowid as drum, '' as rum, '' as date_rum"; |
1988 | 1988 | $sql .= " FROM"; |
1989 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_lignes as pl,"; |
|
1990 | - $sql .= " " . MAIN_DB_PREFIX . "salary as s,"; |
|
1991 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement as p,"; |
|
1992 | - $sql .= " " . MAIN_DB_PREFIX . "user as u"; |
|
1993 | - $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "c_country as c ON u.fk_country = c.rowid,"; |
|
1994 | - $sql .= " " . MAIN_DB_PREFIX . "user_rib as rib"; |
|
1995 | - $sql .= " WHERE pl.fk_prelevement_bons=" . ((int) $this->id); |
|
1989 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_lignes as pl,"; |
|
1990 | + $sql .= " ".MAIN_DB_PREFIX."salary as s,"; |
|
1991 | + $sql .= " ".MAIN_DB_PREFIX."prelevement as p,"; |
|
1992 | + $sql .= " ".MAIN_DB_PREFIX."user as u"; |
|
1993 | + $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_country as c ON u.fk_country = c.rowid,"; |
|
1994 | + $sql .= " ".MAIN_DB_PREFIX."user_rib as rib"; |
|
1995 | + $sql .= " WHERE pl.fk_prelevement_bons=".((int) $this->id); |
|
1996 | 1996 | $sql .= " AND pl.rowid = p.fk_prelevement_lignes"; |
1997 | 1997 | $sql .= " AND p.fk_salary = s.rowid"; |
1998 | 1998 | $sql .= " AND s.fk_user = u.rowid"; |
@@ -2003,19 +2003,19 @@ discard block |
||
2003 | 2003 | $sql .= " f.ref as reffac, f.ref_supplier as fac_ref_supplier, p.fk_facture_fourn as idfac,"; |
2004 | 2004 | $sql .= " rib.rowid, rib.datec, rib.iban_prefix as iban, rib.bic as bic, rib.rowid as drum, rib.rum, rib.date_rum"; |
2005 | 2005 | $sql .= " FROM"; |
2006 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_lignes as pl,"; |
|
2007 | - $sql .= " " . MAIN_DB_PREFIX . "facture_fourn as f,"; |
|
2008 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement as p,"; |
|
2009 | - $sql .= " " . MAIN_DB_PREFIX . "societe as soc"; |
|
2010 | - $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "c_country as c ON soc.fk_pays = c.rowid,"; |
|
2011 | - $sql .= " " . MAIN_DB_PREFIX . "societe_rib as rib"; |
|
2012 | - $sql .= " WHERE pl.fk_prelevement_bons = " . ((int) $this->id); |
|
2006 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_lignes as pl,"; |
|
2007 | + $sql .= " ".MAIN_DB_PREFIX."facture_fourn as f,"; |
|
2008 | + $sql .= " ".MAIN_DB_PREFIX."prelevement as p,"; |
|
2009 | + $sql .= " ".MAIN_DB_PREFIX."societe as soc"; |
|
2010 | + $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_country as c ON soc.fk_pays = c.rowid,"; |
|
2011 | + $sql .= " ".MAIN_DB_PREFIX."societe_rib as rib"; |
|
2012 | + $sql .= " WHERE pl.fk_prelevement_bons = ".((int) $this->id); |
|
2013 | 2013 | $sql .= " AND pl.rowid = p.fk_prelevement_lignes"; |
2014 | 2014 | $sql .= " AND p.fk_facture_fourn = f.rowid"; |
2015 | 2015 | $sql .= " AND f.fk_soc = soc.rowid"; |
2016 | 2016 | $sql .= " AND rib.fk_soc = f.fk_soc"; |
2017 | 2017 | if (!empty($thirdpartyBANId)) { |
2018 | - $sql .= " AND rib.rowid = " . ((int) $thirdpartyBANId); |
|
2018 | + $sql .= " AND rib.rowid = ".((int) $thirdpartyBANId); |
|
2019 | 2019 | } else { |
2020 | 2020 | $sql .= " AND rib.default_rib = 1"; |
2021 | 2021 | } |
@@ -2043,7 +2043,7 @@ discard block |
||
2043 | 2043 | $iban = dolDecrypt($obj->iban); |
2044 | 2044 | $refobj = $obj->reffac; |
2045 | 2045 | if (empty($refobj) && !empty($forsalary)) { // If ref of salary not defined, we force a value |
2046 | - $refobj = "SAL" . $obj->idfac; |
|
2046 | + $refobj = "SAL".$obj->idfac; |
|
2047 | 2047 | } |
2048 | 2048 | |
2049 | 2049 | $fileCrediteurSection .= $this->EnregDestinataireSEPA($obj->code, $obj->nom, $obj->address, $obj->zip, $obj->town, $obj->country_code, $obj->cb, $obj->cg, $obj->cc, $obj->somme, $refobj, $obj->idfac, $iban, $obj->bic, $daterum, $obj->drum, $obj->rum, $type, $obj->fac_ref_supplier); |
@@ -2054,7 +2054,7 @@ discard block |
||
2054 | 2054 | $nbtotalDrctDbtTxInf = $i; |
2055 | 2055 | } else { |
2056 | 2056 | $this->error = $this->db->lasterror(); |
2057 | - fwrite($this->file, 'ERROR CREDITOR ' . $sql . $CrLf); // CREDITORS = Suppliers |
|
2057 | + fwrite($this->file, 'ERROR CREDITOR '.$sql.$CrLf); // CREDITORS = Suppliers |
|
2058 | 2058 | $result = -2; |
2059 | 2059 | } |
2060 | 2060 | // Define $fileEmetteurSection. Start of block PmtInf. Will contains all $nbtotalDrctDbtTxInf |
@@ -2070,26 +2070,26 @@ discard block |
||
2070 | 2070 | * SECTION CREATION SEPA FILE - CREDIT TRANSFER - ISO200022 |
2071 | 2071 | */ |
2072 | 2072 | // SEPA File Header |
2073 | - fwrite($this->file, '<' . '?xml version="1.0" encoding="UTF-8" standalone="yes"?' . '>' . $CrLf); |
|
2074 | - fwrite($this->file, '<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' . $CrLf); |
|
2075 | - fwrite($this->file, ' <CstmrCdtTrfInitn>' . $CrLf); |
|
2073 | + fwrite($this->file, '<'.'?xml version="1.0" encoding="UTF-8" standalone="yes"?'.'>'.$CrLf); |
|
2074 | + fwrite($this->file, '<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">'.$CrLf); |
|
2075 | + fwrite($this->file, ' <CstmrCdtTrfInitn>'.$CrLf); |
|
2076 | 2076 | // SEPA Group header |
2077 | - fwrite($this->file, ' <GrpHdr>' . $CrLf); |
|
2078 | - fwrite($this->file, ' <MsgId>' . ('DOL/' . $dateTime_YMD . '/CT' . $this->id) . '</MsgId>' . $CrLf); |
|
2079 | - fwrite($this->file, ' <CreDtTm>' . $dateTime_ECMA . '</CreDtTm>' . $CrLf); |
|
2080 | - fwrite($this->file, ' <NbOfTxs>' . $i . '</NbOfTxs>' . $CrLf); |
|
2081 | - fwrite($this->file, ' <CtrlSum>' . $this->total . '</CtrlSum>' . $CrLf); |
|
2082 | - fwrite($this->file, ' <InitgPty>' . $CrLf); |
|
2083 | - fwrite($this->file, ' <Nm>' . dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))) . '</Nm>' . $CrLf); |
|
2084 | - fwrite($this->file, ' <Id>' . $CrLf); |
|
2085 | - fwrite($this->file, ' <PrvtId>' . $CrLf); |
|
2086 | - fwrite($this->file, ' <Othr>' . $CrLf); |
|
2087 | - fwrite($this->file, ' <Id>' . $this->emetteur_ics . '</Id>' . $CrLf); |
|
2088 | - fwrite($this->file, ' </Othr>' . $CrLf); |
|
2089 | - fwrite($this->file, ' </PrvtId>' . $CrLf); |
|
2090 | - fwrite($this->file, ' </Id>' . $CrLf); |
|
2091 | - fwrite($this->file, ' </InitgPty>' . $CrLf); |
|
2092 | - fwrite($this->file, ' </GrpHdr>' . $CrLf); |
|
2077 | + fwrite($this->file, ' <GrpHdr>'.$CrLf); |
|
2078 | + fwrite($this->file, ' <MsgId>'.('DOL/'.$dateTime_YMD.'/CT'.$this->id).'</MsgId>'.$CrLf); |
|
2079 | + fwrite($this->file, ' <CreDtTm>'.$dateTime_ECMA.'</CreDtTm>'.$CrLf); |
|
2080 | + fwrite($this->file, ' <NbOfTxs>'.$i.'</NbOfTxs>'.$CrLf); |
|
2081 | + fwrite($this->file, ' <CtrlSum>'.$this->total.'</CtrlSum>'.$CrLf); |
|
2082 | + fwrite($this->file, ' <InitgPty>'.$CrLf); |
|
2083 | + fwrite($this->file, ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))).'</Nm>'.$CrLf); |
|
2084 | + fwrite($this->file, ' <Id>'.$CrLf); |
|
2085 | + fwrite($this->file, ' <PrvtId>'.$CrLf); |
|
2086 | + fwrite($this->file, ' <Othr>'.$CrLf); |
|
2087 | + fwrite($this->file, ' <Id>'.$this->emetteur_ics.'</Id>'.$CrLf); |
|
2088 | + fwrite($this->file, ' </Othr>'.$CrLf); |
|
2089 | + fwrite($this->file, ' </PrvtId>'.$CrLf); |
|
2090 | + fwrite($this->file, ' </Id>'.$CrLf); |
|
2091 | + fwrite($this->file, ' </InitgPty>'.$CrLf); |
|
2092 | + fwrite($this->file, ' </GrpHdr>'.$CrLf); |
|
2093 | 2093 | // SEPA File Emetteur (mycompany) |
2094 | 2094 | if ($result != -2) { |
2095 | 2095 | fwrite($this->file, $fileEmetteurSection); |
@@ -2099,9 +2099,9 @@ discard block |
||
2099 | 2099 | fwrite($this->file, $fileCrediteurSection); |
2100 | 2100 | } |
2101 | 2101 | // SEPA FILE FOOTER |
2102 | - fwrite($this->file, ' </PmtInf>' . $CrLf); |
|
2103 | - fwrite($this->file, ' </CstmrCdtTrfInitn>' . $CrLf); |
|
2104 | - fwrite($this->file, '</Document>' . $CrLf); |
|
2102 | + fwrite($this->file, ' </PmtInf>'.$CrLf); |
|
2103 | + fwrite($this->file, ' </CstmrCdtTrfInitn>'.$CrLf); |
|
2104 | + fwrite($this->file, '</Document>'.$CrLf); |
|
2105 | 2105 | } |
2106 | 2106 | } |
2107 | 2107 | |
@@ -2110,10 +2110,10 @@ discard block |
||
2110 | 2110 | if ($type != 'bank-transfer') { |
2111 | 2111 | $sql = "SELECT pl.amount"; |
2112 | 2112 | $sql .= " FROM"; |
2113 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_lignes as pl,"; |
|
2114 | - $sql .= " " . MAIN_DB_PREFIX . "facture as f,"; |
|
2115 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement as p"; |
|
2116 | - $sql .= " WHERE pl.fk_prelevement_bons = " . ((int) $this->id); |
|
2113 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_lignes as pl,"; |
|
2114 | + $sql .= " ".MAIN_DB_PREFIX."facture as f,"; |
|
2115 | + $sql .= " ".MAIN_DB_PREFIX."prelevement as p"; |
|
2116 | + $sql .= " WHERE pl.fk_prelevement_bons = ".((int) $this->id); |
|
2117 | 2117 | $sql .= " AND pl.rowid = p.fk_prelevement_lignes"; |
2118 | 2118 | $sql .= " AND p.fk_facture = f.rowid"; |
2119 | 2119 | |
@@ -2136,10 +2136,10 @@ discard block |
||
2136 | 2136 | } else { |
2137 | 2137 | $sql = "SELECT pl.amount"; |
2138 | 2138 | $sql .= " FROM"; |
2139 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement_lignes as pl,"; |
|
2140 | - $sql .= " " . MAIN_DB_PREFIX . "facture_fourn as f,"; |
|
2141 | - $sql .= " " . MAIN_DB_PREFIX . "prelevement as p"; |
|
2142 | - $sql .= " WHERE pl.fk_prelevement_bons = " . ((int) $this->id); |
|
2139 | + $sql .= " ".MAIN_DB_PREFIX."prelevement_lignes as pl,"; |
|
2140 | + $sql .= " ".MAIN_DB_PREFIX."facture_fourn as f,"; |
|
2141 | + $sql .= " ".MAIN_DB_PREFIX."prelevement as p"; |
|
2142 | + $sql .= " WHERE pl.fk_prelevement_bons = ".((int) $this->id); |
|
2143 | 2143 | $sql .= " AND pl.rowid = p.fk_prelevement_lignes"; |
2144 | 2144 | $sql .= " AND p.fk_facture_fourn = f.rowid"; |
2145 | 2145 | // Lines |
@@ -2188,7 +2188,7 @@ discard block |
||
2188 | 2188 | $pre = substr(dol_string_nospecial(dol_string_unaccent($langs->transnoentitiesnoconv('RUM'))), 0, 3); // Must always be on 3 char ('RUM' or 'UMR'. This is a protection against bad translation) |
2189 | 2189 | |
2190 | 2190 | // 3 char + '-' + 12 + '-' + id + '-' + code Must be lower than 32. |
2191 | - return $pre . '-' . dol_print_date($row_datec, 'dayhourlogsmall') . '-' . dol_trunc($row_drum . ($row_code_client ? '-' . $row_code_client : ''), 13, 'right', 'UTF-8', 1); |
|
2191 | + return $pre.'-'.dol_print_date($row_datec, 'dayhourlogsmall').'-'.dol_trunc($row_drum.($row_code_client ? '-'.$row_code_client : ''), 13, 'right', 'UTF-8', 1); |
|
2192 | 2192 | } |
2193 | 2193 | |
2194 | 2194 | |
@@ -2227,11 +2227,11 @@ discard block |
||
2227 | 2227 | |
2228 | 2228 | // Raison Sociale Destinataire C2 |
2229 | 2229 | |
2230 | - fwrite($this->file, substr(strtoupper($client_nom) . " ", 0, 24)); |
|
2230 | + fwrite($this->file, substr(strtoupper($client_nom)." ", 0, 24)); |
|
2231 | 2231 | |
2232 | 2232 | // Address optional D1 |
2233 | 2233 | $address = strtr($rib_dom, array(" " => "-", chr(13) => " ", chr(10) => "")); |
2234 | - fwrite($this->file, substr($address . " ", 0, 24)); |
|
2234 | + fwrite($this->file, substr($address." ", 0, 24)); |
|
2235 | 2235 | |
2236 | 2236 | // Zone Reservee D2 |
2237 | 2237 | |
@@ -2243,17 +2243,17 @@ discard block |
||
2243 | 2243 | |
2244 | 2244 | // Numero de compte D4 |
2245 | 2245 | |
2246 | - fwrite($this->file, substr("000000000000000" . $rib_number, -11)); |
|
2246 | + fwrite($this->file, substr("000000000000000".$rib_number, -11)); |
|
2247 | 2247 | |
2248 | 2248 | // Zone E Montant |
2249 | 2249 | |
2250 | 2250 | $montant = (round($amount, 2) * 100); |
2251 | 2251 | |
2252 | - fwrite($this->file, substr("000000000000000" . $montant, -16)); |
|
2252 | + fwrite($this->file, substr("000000000000000".$montant, -16)); |
|
2253 | 2253 | |
2254 | 2254 | // Label F |
2255 | 2255 | |
2256 | - fwrite($this->file, substr("*_" . $ref . "_RDVnet" . $rowid . " ", 0, 31)); |
|
2256 | + fwrite($this->file, substr("*_".$ref."_RDVnet".$rowid." ", 0, 31)); |
|
2257 | 2257 | |
2258 | 2258 | // Code etablissement G1 |
2259 | 2259 | |
@@ -2304,7 +2304,7 @@ discard block |
||
2304 | 2304 | $row_somme = round((float) $row_somme, 2); |
2305 | 2305 | } |
2306 | 2306 | |
2307 | - include_once DOL_DOCUMENT_ROOT . '/core/lib/functions2.lib.php'; |
|
2307 | + include_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php'; |
|
2308 | 2308 | |
2309 | 2309 | $CrLf = "\n"; |
2310 | 2310 | $Rowing = sprintf("%010d", $row_idfac); |
@@ -2319,46 +2319,46 @@ discard block |
||
2319 | 2319 | if ($type != 'bank-transfer') { |
2320 | 2320 | // SEPA Paiement Information of buyer for Direct Debit |
2321 | 2321 | $XML_DEBITOR = ''; |
2322 | - $XML_DEBITOR .= ' <DrctDbtTxInf>' . $CrLf; |
|
2323 | - $XML_DEBITOR .= ' <PmtId>' . $CrLf; |
|
2322 | + $XML_DEBITOR .= ' <DrctDbtTxInf>'.$CrLf; |
|
2323 | + $XML_DEBITOR .= ' <PmtId>'.$CrLf; |
|
2324 | 2324 | // Add EndToEndId. Must be a unique ID for each payment (for example by including bank, buyer or seller, date, checksum) |
2325 | - $XML_DEBITOR .= ' <EndToEndId>' . ((getDolGlobalString('PRELEVEMENT_END_TO_END') != "") ? $conf->global->PRELEVEMENT_END_TO_END : ('DD-' . dol_trunc($row_idfac . '-' . $row_ref, 20, 'right', 'UTF-8', 1)) . '-' . $Rowing) . '</EndToEndId>' . $CrLf; // ISO20022 states that EndToEndId has a MaxLength of 35 characters |
|
2326 | - $XML_DEBITOR .= ' </PmtId>' . $CrLf; |
|
2327 | - $XML_DEBITOR .= ' <InstdAmt Ccy="EUR">' . $row_somme . '</InstdAmt>' . $CrLf; |
|
2328 | - $XML_DEBITOR .= ' <DrctDbtTx>' . $CrLf; |
|
2329 | - $XML_DEBITOR .= ' <MndtRltdInf>' . $CrLf; |
|
2330 | - $XML_DEBITOR .= ' <MndtId>' . $Rum . '</MndtId>' . $CrLf; |
|
2331 | - $XML_DEBITOR .= ' <DtOfSgntr>' . $DtOfSgntr . '</DtOfSgntr>' . $CrLf; |
|
2332 | - $XML_DEBITOR .= ' <AmdmntInd>false</AmdmntInd>' . $CrLf; |
|
2333 | - $XML_DEBITOR .= ' </MndtRltdInf>' . $CrLf; |
|
2334 | - $XML_DEBITOR .= ' </DrctDbtTx>' . $CrLf; |
|
2335 | - $XML_DEBITOR .= ' <DbtrAgt>' . $CrLf; |
|
2336 | - $XML_DEBITOR .= ' <FinInstnId>' . $CrLf; |
|
2325 | + $XML_DEBITOR .= ' <EndToEndId>'.((getDolGlobalString('PRELEVEMENT_END_TO_END') != "") ? $conf->global->PRELEVEMENT_END_TO_END : ('DD-'.dol_trunc($row_idfac.'-'.$row_ref, 20, 'right', 'UTF-8', 1)).'-'.$Rowing).'</EndToEndId>'.$CrLf; // ISO20022 states that EndToEndId has a MaxLength of 35 characters |
|
2326 | + $XML_DEBITOR .= ' </PmtId>'.$CrLf; |
|
2327 | + $XML_DEBITOR .= ' <InstdAmt Ccy="EUR">'.$row_somme.'</InstdAmt>'.$CrLf; |
|
2328 | + $XML_DEBITOR .= ' <DrctDbtTx>'.$CrLf; |
|
2329 | + $XML_DEBITOR .= ' <MndtRltdInf>'.$CrLf; |
|
2330 | + $XML_DEBITOR .= ' <MndtId>'.$Rum.'</MndtId>'.$CrLf; |
|
2331 | + $XML_DEBITOR .= ' <DtOfSgntr>'.$DtOfSgntr.'</DtOfSgntr>'.$CrLf; |
|
2332 | + $XML_DEBITOR .= ' <AmdmntInd>false</AmdmntInd>'.$CrLf; |
|
2333 | + $XML_DEBITOR .= ' </MndtRltdInf>'.$CrLf; |
|
2334 | + $XML_DEBITOR .= ' </DrctDbtTx>'.$CrLf; |
|
2335 | + $XML_DEBITOR .= ' <DbtrAgt>'.$CrLf; |
|
2336 | + $XML_DEBITOR .= ' <FinInstnId>'.$CrLf; |
|
2337 | 2337 | if (getDolGlobalInt('WITHDRAWAL_WITHOUT_BIC') == 0) { |
2338 | - $XML_DEBITOR .= ' <BIC>' . $row_bic . '</BIC>' . $CrLf; |
|
2338 | + $XML_DEBITOR .= ' <BIC>'.$row_bic.'</BIC>'.$CrLf; |
|
2339 | 2339 | } |
2340 | - $XML_DEBITOR .= ' </FinInstnId>' . $CrLf; |
|
2341 | - $XML_DEBITOR .= ' </DbtrAgt>' . $CrLf; |
|
2342 | - $XML_DEBITOR .= ' <Dbtr>' . $CrLf; |
|
2343 | - $XML_DEBITOR .= ' <Nm>' . dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($row_nom), ' '))) . '</Nm>' . $CrLf; |
|
2344 | - $XML_DEBITOR .= ' <PstlAdr>' . $CrLf; |
|
2345 | - $XML_DEBITOR .= ' <Ctry>' . $row_country_code . '</Ctry>' . $CrLf; |
|
2340 | + $XML_DEBITOR .= ' </FinInstnId>'.$CrLf; |
|
2341 | + $XML_DEBITOR .= ' </DbtrAgt>'.$CrLf; |
|
2342 | + $XML_DEBITOR .= ' <Dbtr>'.$CrLf; |
|
2343 | + $XML_DEBITOR .= ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($row_nom), ' '))).'</Nm>'.$CrLf; |
|
2344 | + $XML_DEBITOR .= ' <PstlAdr>'.$CrLf; |
|
2345 | + $XML_DEBITOR .= ' <Ctry>'.$row_country_code.'</Ctry>'.$CrLf; |
|
2346 | 2346 | $addressline1 = strtr($row_address, array(chr(13) => ", ", chr(10) => "")); |
2347 | - $addressline2 = strtr($row_zip . (($row_zip && $row_town) ? ' ' : (string) $row_town), array(chr(13) => ", ", chr(10) => "")); |
|
2347 | + $addressline2 = strtr($row_zip.(($row_zip && $row_town) ? ' ' : (string) $row_town), array(chr(13) => ", ", chr(10) => "")); |
|
2348 | 2348 | if (trim($addressline1)) { |
2349 | - $XML_DEBITOR .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2349 | + $XML_DEBITOR .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2350 | 2350 | } |
2351 | 2351 | if (trim($addressline2)) { |
2352 | - $XML_DEBITOR .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2352 | + $XML_DEBITOR .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2353 | 2353 | } |
2354 | - $XML_DEBITOR .= ' </PstlAdr>' . $CrLf; |
|
2355 | - $XML_DEBITOR .= ' </Dbtr>' . $CrLf; |
|
2356 | - $XML_DEBITOR .= ' <DbtrAcct>' . $CrLf; |
|
2357 | - $XML_DEBITOR .= ' <Id>' . $CrLf; |
|
2358 | - $XML_DEBITOR .= ' <IBAN>' . preg_replace('/\s/', '', $row_iban) . '</IBAN>' . $CrLf; |
|
2359 | - $XML_DEBITOR .= ' </Id>' . $CrLf; |
|
2360 | - $XML_DEBITOR .= ' </DbtrAcct>' . $CrLf; |
|
2361 | - $XML_DEBITOR .= ' <RmtInf>' . $CrLf; |
|
2354 | + $XML_DEBITOR .= ' </PstlAdr>'.$CrLf; |
|
2355 | + $XML_DEBITOR .= ' </Dbtr>'.$CrLf; |
|
2356 | + $XML_DEBITOR .= ' <DbtrAcct>'.$CrLf; |
|
2357 | + $XML_DEBITOR .= ' <Id>'.$CrLf; |
|
2358 | + $XML_DEBITOR .= ' <IBAN>'.preg_replace('/\s/', '', $row_iban).'</IBAN>'.$CrLf; |
|
2359 | + $XML_DEBITOR .= ' </Id>'.$CrLf; |
|
2360 | + $XML_DEBITOR .= ' </DbtrAcct>'.$CrLf; |
|
2361 | + $XML_DEBITOR .= ' <RmtInf>'.$CrLf; |
|
2362 | 2362 | |
2363 | 2363 | // Structured data for Belgium |
2364 | 2364 | if (getDolGlobalString('INVOICE_PAYMENT_ENABLE_STRUCTURED_COMMUNICATION') && $mysoc->country_code == 'BE') { |
@@ -2368,24 +2368,24 @@ discard block |
||
2368 | 2368 | $invoicestatic->fetch($row_idfac); |
2369 | 2369 | |
2370 | 2370 | $invoicePaymentKey = dolBECalculateStructuredCommunication($invoicestatic->ref, $invoicestatic->type); |
2371 | - $XML_DEBITOR .= ' <strd>' . $invoicePaymentKey . '</strd>' . $CrLf; |
|
2371 | + $XML_DEBITOR .= ' <strd>'.$invoicePaymentKey.'</strd>'.$CrLf; |
|
2372 | 2372 | } else { |
2373 | 2373 | // A string with some information on payment - 140 max |
2374 | - $XML_DEBITOR .= ' <Ustrd>' . getDolGlobalString('PRELEVEMENT_USTRD', dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($row_ref . ($row_comment ? ' - ' . $row_comment : '')), '', '', '', 1), 135, 'right', 'UTF-8', 1))) . '</Ustrd>' . $CrLf; // Free unstuctured data - 140 max |
|
2374 | + $XML_DEBITOR .= ' <Ustrd>'.getDolGlobalString('PRELEVEMENT_USTRD', dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($row_ref.($row_comment ? ' - '.$row_comment : '')), '', '', '', 1), 135, 'right', 'UTF-8', 1))).'</Ustrd>'.$CrLf; // Free unstuctured data - 140 max |
|
2375 | 2375 | } |
2376 | - $XML_DEBITOR .= ' </RmtInf>' . $CrLf; |
|
2377 | - $XML_DEBITOR .= ' </DrctDbtTxInf>' . $CrLf; |
|
2376 | + $XML_DEBITOR .= ' </RmtInf>'.$CrLf; |
|
2377 | + $XML_DEBITOR .= ' </DrctDbtTxInf>'.$CrLf; |
|
2378 | 2378 | return $XML_DEBITOR; |
2379 | 2379 | } else { |
2380 | 2380 | // SEPA Payment Information of seller for Credit Transfer |
2381 | 2381 | $XML_CREDITOR = ''; |
2382 | - $XML_CREDITOR .= ' <CdtTrfTxInf>' . $CrLf; |
|
2383 | - $XML_CREDITOR .= ' <PmtId>' . $CrLf; |
|
2382 | + $XML_CREDITOR .= ' <CdtTrfTxInf>'.$CrLf; |
|
2383 | + $XML_CREDITOR .= ' <PmtId>'.$CrLf; |
|
2384 | 2384 | // Add EndToEndId. Must be a unique ID for each payment (for example by including bank, buyer or seller, date, checksum) |
2385 | - $XML_CREDITOR .= ' <EndToEndId>' . ((getDolGlobalString('PRELEVEMENT_END_TO_END') != "") ? $conf->global->PRELEVEMENT_END_TO_END : ('CT-' . dol_trunc($row_idfac . '-' . $row_ref, 20, 'right', 'UTF-8', 1)) . '-' . $Rowing) . '</EndToEndId>' . $CrLf; // ISO20022 states that EndToEndId has a MaxLength of 35 characters |
|
2386 | - $XML_CREDITOR .= ' </PmtId>' . $CrLf; |
|
2385 | + $XML_CREDITOR .= ' <EndToEndId>'.((getDolGlobalString('PRELEVEMENT_END_TO_END') != "") ? $conf->global->PRELEVEMENT_END_TO_END : ('CT-'.dol_trunc($row_idfac.'-'.$row_ref, 20, 'right', 'UTF-8', 1)).'-'.$Rowing).'</EndToEndId>'.$CrLf; // ISO20022 states that EndToEndId has a MaxLength of 35 characters |
|
2386 | + $XML_CREDITOR .= ' </PmtId>'.$CrLf; |
|
2387 | 2387 | if (!empty($this->sepa_xml_pti_in_ctti)) { |
2388 | - $XML_CREDITOR .= ' <PmtTpInf>' . $CrLf; |
|
2388 | + $XML_CREDITOR .= ' <PmtTpInf>'.$CrLf; |
|
2389 | 2389 | |
2390 | 2390 | // Can be 'NORM' for normal or 'HIGH' for high priority level |
2391 | 2391 | if (getDolGlobalString('PAYMENTBYBANKTRANSFER_FORCE_HIGH_PRIORITY')) { |
@@ -2397,18 +2397,18 @@ discard block |
||
2397 | 2397 | // Set $categoryPurpose: CORE, TREA, SUPP, ... |
2398 | 2398 | $categoryPurpose = getDolGlobalString('PAYMENTBYBANKTRANSFER_CUSTOM_CATEGORY_PURPOSE', 'CORE'); |
2399 | 2399 | |
2400 | - $XML_CREDITOR .= ' <InstrPrty>' . $instrprty . '</InstrPrty>' . $CrLf; |
|
2401 | - $XML_CREDITOR .= ' <SvcLvl>' . $CrLf; |
|
2402 | - $XML_CREDITOR .= ' <Cd>SEPA</Cd>' . $CrLf; |
|
2403 | - $XML_CREDITOR .= ' </SvcLvl>' . $CrLf; |
|
2404 | - $XML_CREDITOR .= ' <CtgyPurp>' . $CrLf; |
|
2405 | - $XML_CREDITOR .= ' <Cd>' . $categoryPurpose . '</Cd>' . $CrLf; |
|
2406 | - $XML_CREDITOR .= ' </CtgyPurp>' . $CrLf; |
|
2407 | - $XML_CREDITOR .= ' </PmtTpInf>' . $CrLf; |
|
2400 | + $XML_CREDITOR .= ' <InstrPrty>'.$instrprty.'</InstrPrty>'.$CrLf; |
|
2401 | + $XML_CREDITOR .= ' <SvcLvl>'.$CrLf; |
|
2402 | + $XML_CREDITOR .= ' <Cd>SEPA</Cd>'.$CrLf; |
|
2403 | + $XML_CREDITOR .= ' </SvcLvl>'.$CrLf; |
|
2404 | + $XML_CREDITOR .= ' <CtgyPurp>'.$CrLf; |
|
2405 | + $XML_CREDITOR .= ' <Cd>'.$categoryPurpose.'</Cd>'.$CrLf; |
|
2406 | + $XML_CREDITOR .= ' </CtgyPurp>'.$CrLf; |
|
2407 | + $XML_CREDITOR .= ' </PmtTpInf>'.$CrLf; |
|
2408 | 2408 | } |
2409 | - $XML_CREDITOR .= ' <Amt>' . $CrLf; |
|
2409 | + $XML_CREDITOR .= ' <Amt>'.$CrLf; |
|
2410 | 2410 | $XML_CREDITOR .= ' <InstdAmt Ccy="EUR">'.round((float) $row_somme, 2).'</InstdAmt>'.$CrLf; |
2411 | - $XML_CREDITOR .= ' </Amt>' . $CrLf; |
|
2411 | + $XML_CREDITOR .= ' </Amt>'.$CrLf; |
|
2412 | 2412 | /* |
2413 | 2413 | $XML_CREDITOR .= ' <DrctDbtTx>'.$CrLf; |
2414 | 2414 | $XML_CREDITOR .= ' <MndtRltdInf>'.$CrLf; |
@@ -2419,35 +2419,35 @@ discard block |
||
2419 | 2419 | $XML_CREDITOR .= ' </DrctDbtTx>'.$CrLf; |
2420 | 2420 | */ |
2421 | 2421 | //$XML_CREDITOR .= ' <ChrgBr>SLEV</ChrgBr>'.$CrLf; |
2422 | - $XML_CREDITOR .= ' <CdtrAgt>' . $CrLf; |
|
2423 | - $XML_CREDITOR .= ' <FinInstnId>' . $CrLf; |
|
2424 | - $XML_CREDITOR .= ' <BIC>' . $row_bic . '</BIC>' . $CrLf; |
|
2425 | - $XML_CREDITOR .= ' </FinInstnId>' . $CrLf; |
|
2426 | - $XML_CREDITOR .= ' </CdtrAgt>' . $CrLf; |
|
2427 | - $XML_CREDITOR .= ' <Cdtr>' . $CrLf; |
|
2428 | - $XML_CREDITOR .= ' <Nm>' . dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($row_nom), ' '))) . '</Nm>' . $CrLf; |
|
2429 | - $XML_CREDITOR .= ' <PstlAdr>' . $CrLf; |
|
2430 | - $XML_CREDITOR .= ' <Ctry>' . $row_country_code . '</Ctry>' . $CrLf; |
|
2422 | + $XML_CREDITOR .= ' <CdtrAgt>'.$CrLf; |
|
2423 | + $XML_CREDITOR .= ' <FinInstnId>'.$CrLf; |
|
2424 | + $XML_CREDITOR .= ' <BIC>'.$row_bic.'</BIC>'.$CrLf; |
|
2425 | + $XML_CREDITOR .= ' </FinInstnId>'.$CrLf; |
|
2426 | + $XML_CREDITOR .= ' </CdtrAgt>'.$CrLf; |
|
2427 | + $XML_CREDITOR .= ' <Cdtr>'.$CrLf; |
|
2428 | + $XML_CREDITOR .= ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($row_nom), ' '))).'</Nm>'.$CrLf; |
|
2429 | + $XML_CREDITOR .= ' <PstlAdr>'.$CrLf; |
|
2430 | + $XML_CREDITOR .= ' <Ctry>'.$row_country_code.'</Ctry>'.$CrLf; |
|
2431 | 2431 | $addressline1 = strtr($row_address, array(chr(13) => ", ", chr(10) => "")); |
2432 | - $addressline2 = strtr($row_zip . (($row_zip && $row_town) ? ' ' : (string) $row_town), array(chr(13) => ", ", chr(10) => "")); |
|
2432 | + $addressline2 = strtr($row_zip.(($row_zip && $row_town) ? ' ' : (string) $row_town), array(chr(13) => ", ", chr(10) => "")); |
|
2433 | 2433 | if (trim($addressline1)) { |
2434 | - $XML_CREDITOR .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2434 | + $XML_CREDITOR .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2435 | 2435 | } |
2436 | 2436 | if (trim($addressline2)) { |
2437 | - $XML_CREDITOR .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2437 | + $XML_CREDITOR .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2438 | 2438 | } |
2439 | - $XML_CREDITOR .= ' </PstlAdr>' . $CrLf; |
|
2440 | - $XML_CREDITOR .= ' </Cdtr>' . $CrLf; |
|
2441 | - $XML_CREDITOR .= ' <CdtrAcct>' . $CrLf; |
|
2442 | - $XML_CREDITOR .= ' <Id>' . $CrLf; |
|
2443 | - $XML_CREDITOR .= ' <IBAN>' . preg_replace('/\s/', '', $row_iban) . '</IBAN>' . $CrLf; |
|
2444 | - $XML_CREDITOR .= ' </Id>' . $CrLf; |
|
2445 | - $XML_CREDITOR .= ' </CdtrAcct>' . $CrLf; |
|
2446 | - $XML_CREDITOR .= ' <RmtInf>' . $CrLf; |
|
2439 | + $XML_CREDITOR .= ' </PstlAdr>'.$CrLf; |
|
2440 | + $XML_CREDITOR .= ' </Cdtr>'.$CrLf; |
|
2441 | + $XML_CREDITOR .= ' <CdtrAcct>'.$CrLf; |
|
2442 | + $XML_CREDITOR .= ' <Id>'.$CrLf; |
|
2443 | + $XML_CREDITOR .= ' <IBAN>'.preg_replace('/\s/', '', $row_iban).'</IBAN>'.$CrLf; |
|
2444 | + $XML_CREDITOR .= ' </Id>'.$CrLf; |
|
2445 | + $XML_CREDITOR .= ' </CdtrAcct>'.$CrLf; |
|
2446 | + $XML_CREDITOR .= ' <RmtInf>'.$CrLf; |
|
2447 | 2447 | // A string with some information on payment - 140 max |
2448 | - $XML_CREDITOR .= ' <Ustrd>' . getDolGlobalString('CREDITTRANSFER_USTRD', dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($row_ref . ($row_comment ? ' - ' . $row_comment : '')), '', '', '', 1), 135, 'right', 'UTF-8', 1))) . '</Ustrd>' . $CrLf; // Free unstructured data - 140 max |
|
2449 | - $XML_CREDITOR .= ' </RmtInf>' . $CrLf; |
|
2450 | - $XML_CREDITOR .= ' </CdtTrfTxInf>' . $CrLf; |
|
2448 | + $XML_CREDITOR .= ' <Ustrd>'.getDolGlobalString('CREDITTRANSFER_USTRD', dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($row_ref.($row_comment ? ' - '.$row_comment : '')), '', '', '', 1), 135, 'right', 'UTF-8', 1))).'</Ustrd>'.$CrLf; // Free unstructured data - 140 max |
|
2449 | + $XML_CREDITOR .= ' </RmtInf>'.$CrLf; |
|
2450 | + $XML_CREDITOR .= ' </CdtTrfTxInf>'.$CrLf; |
|
2451 | 2451 | return $XML_CREDITOR; |
2452 | 2452 | } |
2453 | 2453 | } |
@@ -2480,11 +2480,11 @@ discard block |
||
2480 | 2480 | |
2481 | 2481 | // Raison Sociale C2 |
2482 | 2482 | |
2483 | - fwrite($this->file, substr($this->raison_sociale . " ", 0, 24)); |
|
2483 | + fwrite($this->file, substr($this->raison_sociale." ", 0, 24)); |
|
2484 | 2484 | |
2485 | 2485 | // Ref of thirdparty on 7 characters |
2486 | 2486 | |
2487 | - fwrite($this->file, substr($this->reference_remise . " ", 0, 7)); |
|
2487 | + fwrite($this->file, substr($this->reference_remise." ", 0, 7)); |
|
2488 | 2488 | |
2489 | 2489 | // Zone Reservee D1-2 |
2490 | 2490 | |
@@ -2502,7 +2502,7 @@ discard block |
||
2502 | 2502 | |
2503 | 2503 | // Numero de compte D4 |
2504 | 2504 | |
2505 | - fwrite($this->file, substr("000000000000000" . $this->emetteur_numero_compte, -11)); |
|
2505 | + fwrite($this->file, substr("000000000000000".$this->emetteur_numero_compte, -11)); |
|
2506 | 2506 | |
2507 | 2507 | // Zone Reservee E |
2508 | 2508 | |
@@ -2564,15 +2564,15 @@ discard block |
||
2564 | 2564 | $this->emetteur_iban = $account->iban; |
2565 | 2565 | $this->emetteur_bic = $account->bic; |
2566 | 2566 | |
2567 | - $this->emetteur_ics = (($type == 'bank-transfer' && getDolGlobalString("SEPA_USE_IDS")) ? $account->ics_transfer : $account->ics); // Ex: PRELEVEMENT_ICS = "FR78ZZZ123456"; |
|
2567 | + $this->emetteur_ics = (($type == 'bank-transfer' && getDolGlobalString("SEPA_USE_IDS")) ? $account->ics_transfer : $account->ics); // Ex: PRELEVEMENT_ICS = "FR78ZZZ123456"; |
|
2568 | 2568 | |
2569 | 2569 | $this->raison_sociale = $account->owner_name; |
2570 | 2570 | } |
2571 | 2571 | |
2572 | 2572 | // Get pending payments |
2573 | 2573 | $sql = "SELECT rowid, ref"; |
2574 | - $sql .= " FROM " . MAIN_DB_PREFIX . "prelevement_bons as pb"; |
|
2575 | - $sql .= " WHERE pb.rowid = " . ((int) $this->id); |
|
2574 | + $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_bons as pb"; |
|
2575 | + $sql .= " WHERE pb.rowid = ".((int) $this->id); |
|
2576 | 2576 | |
2577 | 2577 | $resql = $this->db->query($sql); |
2578 | 2578 | if ($resql) { |
@@ -2590,45 +2590,45 @@ discard block |
||
2590 | 2590 | if ($type != 'bank-transfer') { |
2591 | 2591 | // SEPA Paiement Information of my company for Direct Debit |
2592 | 2592 | $XML_SEPA_INFO = ''; |
2593 | - $XML_SEPA_INFO .= ' <PmtInf>' . $CrLf; |
|
2594 | - $XML_SEPA_INFO .= ' <PmtInfId>' . ('DOL/' . $dateTime_YMD . '/DD' . $IdBon . '-' . $RefBon) . '</PmtInfId>' . $CrLf; |
|
2595 | - $XML_SEPA_INFO .= ' <PmtMtd>DD</PmtMtd>' . $CrLf; |
|
2596 | - $XML_SEPA_INFO .= ' <NbOfTxs>' . $nombre . '</NbOfTxs>' . $CrLf; |
|
2597 | - $XML_SEPA_INFO .= ' <CtrlSum>' . $total . '</CtrlSum>' . $CrLf; |
|
2598 | - $XML_SEPA_INFO .= ' <PmtTpInf>' . $CrLf; |
|
2599 | - $XML_SEPA_INFO .= ' <SvcLvl>' . $CrLf; |
|
2600 | - $XML_SEPA_INFO .= ' <Cd>SEPA</Cd>' . $CrLf; |
|
2601 | - $XML_SEPA_INFO .= ' </SvcLvl>' . $CrLf; |
|
2602 | - $XML_SEPA_INFO .= ' <LclInstrm>' . $CrLf; |
|
2603 | - $XML_SEPA_INFO .= ' <Cd>' . $localInstrument . '</Cd>' . $CrLf; |
|
2604 | - $XML_SEPA_INFO .= ' </LclInstrm>' . $CrLf; |
|
2605 | - $XML_SEPA_INFO .= ' <SeqTp>' . $format . '</SeqTp>' . $CrLf; |
|
2606 | - $XML_SEPA_INFO .= ' </PmtTpInf>' . $CrLf; |
|
2607 | - $XML_SEPA_INFO .= ' <ReqdColltnDt>' . $dateTime_ETAD . '</ReqdColltnDt>' . $CrLf; |
|
2608 | - $XML_SEPA_INFO .= ' <Cdtr>' . $CrLf; |
|
2609 | - $XML_SEPA_INFO .= ' <Nm>' . dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))) . '</Nm>' . $CrLf; |
|
2610 | - $XML_SEPA_INFO .= ' <PstlAdr>' . $CrLf; |
|
2611 | - $XML_SEPA_INFO .= ' <Ctry>' . $country[1] . '</Ctry>' . $CrLf; |
|
2593 | + $XML_SEPA_INFO .= ' <PmtInf>'.$CrLf; |
|
2594 | + $XML_SEPA_INFO .= ' <PmtInfId>'.('DOL/'.$dateTime_YMD.'/DD'.$IdBon.'-'.$RefBon).'</PmtInfId>'.$CrLf; |
|
2595 | + $XML_SEPA_INFO .= ' <PmtMtd>DD</PmtMtd>'.$CrLf; |
|
2596 | + $XML_SEPA_INFO .= ' <NbOfTxs>'.$nombre.'</NbOfTxs>'.$CrLf; |
|
2597 | + $XML_SEPA_INFO .= ' <CtrlSum>'.$total.'</CtrlSum>'.$CrLf; |
|
2598 | + $XML_SEPA_INFO .= ' <PmtTpInf>'.$CrLf; |
|
2599 | + $XML_SEPA_INFO .= ' <SvcLvl>'.$CrLf; |
|
2600 | + $XML_SEPA_INFO .= ' <Cd>SEPA</Cd>'.$CrLf; |
|
2601 | + $XML_SEPA_INFO .= ' </SvcLvl>'.$CrLf; |
|
2602 | + $XML_SEPA_INFO .= ' <LclInstrm>'.$CrLf; |
|
2603 | + $XML_SEPA_INFO .= ' <Cd>'.$localInstrument.'</Cd>'.$CrLf; |
|
2604 | + $XML_SEPA_INFO .= ' </LclInstrm>'.$CrLf; |
|
2605 | + $XML_SEPA_INFO .= ' <SeqTp>'.$format.'</SeqTp>'.$CrLf; |
|
2606 | + $XML_SEPA_INFO .= ' </PmtTpInf>'.$CrLf; |
|
2607 | + $XML_SEPA_INFO .= ' <ReqdColltnDt>'.$dateTime_ETAD.'</ReqdColltnDt>'.$CrLf; |
|
2608 | + $XML_SEPA_INFO .= ' <Cdtr>'.$CrLf; |
|
2609 | + $XML_SEPA_INFO .= ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))).'</Nm>'.$CrLf; |
|
2610 | + $XML_SEPA_INFO .= ' <PstlAdr>'.$CrLf; |
|
2611 | + $XML_SEPA_INFO .= ' <Ctry>'.$country[1].'</Ctry>'.$CrLf; |
|
2612 | 2612 | $addressline1 = strtr($configuration->global->MAIN_INFO_SOCIETE_ADDRESS, array(chr(13) => ", ", chr(10) => "")); |
2613 | - $addressline2 = strtr($configuration->global->MAIN_INFO_SOCIETE_ZIP . (($configuration->global->MAIN_INFO_SOCIETE_ZIP || ' ' . $configuration->global->MAIN_INFO_SOCIETE_TOWN) ? ' ' : '') . $configuration->global->MAIN_INFO_SOCIETE_TOWN, array(chr(13) => ", ", chr(10) => "")); |
|
2613 | + $addressline2 = strtr($configuration->global->MAIN_INFO_SOCIETE_ZIP.(($configuration->global->MAIN_INFO_SOCIETE_ZIP || ' '.$configuration->global->MAIN_INFO_SOCIETE_TOWN) ? ' ' : '').$configuration->global->MAIN_INFO_SOCIETE_TOWN, array(chr(13) => ", ", chr(10) => "")); |
|
2614 | 2614 | if ($addressline1) { |
2615 | - $XML_SEPA_INFO .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2615 | + $XML_SEPA_INFO .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2616 | 2616 | } |
2617 | 2617 | if ($addressline2) { |
2618 | - $XML_SEPA_INFO .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2618 | + $XML_SEPA_INFO .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2619 | 2619 | } |
2620 | - $XML_SEPA_INFO .= ' </PstlAdr>' . $CrLf; |
|
2621 | - $XML_SEPA_INFO .= ' </Cdtr>' . $CrLf; |
|
2622 | - $XML_SEPA_INFO .= ' <CdtrAcct>' . $CrLf; |
|
2623 | - $XML_SEPA_INFO .= ' <Id>' . $CrLf; |
|
2624 | - $XML_SEPA_INFO .= ' <IBAN>' . preg_replace('/\s/', '', $this->emetteur_iban) . '</IBAN>' . $CrLf; |
|
2625 | - $XML_SEPA_INFO .= ' </Id>' . $CrLf; |
|
2626 | - $XML_SEPA_INFO .= ' </CdtrAcct>' . $CrLf; |
|
2627 | - $XML_SEPA_INFO .= ' <CdtrAgt>' . $CrLf; |
|
2628 | - $XML_SEPA_INFO .= ' <FinInstnId>' . $CrLf; |
|
2629 | - $XML_SEPA_INFO .= ' <BIC>' . $this->emetteur_bic . '</BIC>' . $CrLf; |
|
2630 | - $XML_SEPA_INFO .= ' </FinInstnId>' . $CrLf; |
|
2631 | - $XML_SEPA_INFO .= ' </CdtrAgt>' . $CrLf; |
|
2620 | + $XML_SEPA_INFO .= ' </PstlAdr>'.$CrLf; |
|
2621 | + $XML_SEPA_INFO .= ' </Cdtr>'.$CrLf; |
|
2622 | + $XML_SEPA_INFO .= ' <CdtrAcct>'.$CrLf; |
|
2623 | + $XML_SEPA_INFO .= ' <Id>'.$CrLf; |
|
2624 | + $XML_SEPA_INFO .= ' <IBAN>'.preg_replace('/\s/', '', $this->emetteur_iban).'</IBAN>'.$CrLf; |
|
2625 | + $XML_SEPA_INFO .= ' </Id>'.$CrLf; |
|
2626 | + $XML_SEPA_INFO .= ' </CdtrAcct>'.$CrLf; |
|
2627 | + $XML_SEPA_INFO .= ' <CdtrAgt>'.$CrLf; |
|
2628 | + $XML_SEPA_INFO .= ' <FinInstnId>'.$CrLf; |
|
2629 | + $XML_SEPA_INFO .= ' <BIC>'.$this->emetteur_bic.'</BIC>'.$CrLf; |
|
2630 | + $XML_SEPA_INFO .= ' </FinInstnId>'.$CrLf; |
|
2631 | + $XML_SEPA_INFO .= ' </CdtrAgt>'.$CrLf; |
|
2632 | 2632 | /* $XML_SEPA_INFO .= ' <UltmtCdtr>'.$CrLf; |
2633 | 2633 | $XML_SEPA_INFO .= ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))).'</Nm>'.$CrLf; |
2634 | 2634 | $XML_SEPA_INFO .= ' <PstlAdr>'.$CrLf; |
@@ -2637,64 +2637,64 @@ discard block |
||
2637 | 2637 | $XML_SEPA_INFO .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($conf->global->MAIN_INFO_SOCIETE_ZIP.' '.$conf->global->MAIN_INFO_SOCIETE_TOWN), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
2638 | 2638 | $XML_SEPA_INFO .= ' </PstlAdr>'.$CrLf; |
2639 | 2639 | $XML_SEPA_INFO .= ' </UltmtCdtr>'.$CrLf;*/ |
2640 | - $XML_SEPA_INFO .= ' <ChrgBr>SLEV</ChrgBr>' . $CrLf; // Field "Responsible of fees". Must be SLEV |
|
2641 | - $XML_SEPA_INFO .= ' <CdtrSchmeId>' . $CrLf; |
|
2642 | - $XML_SEPA_INFO .= ' <Id>' . $CrLf; |
|
2643 | - $XML_SEPA_INFO .= ' <PrvtId>' . $CrLf; |
|
2644 | - $XML_SEPA_INFO .= ' <Othr>' . $CrLf; |
|
2645 | - $XML_SEPA_INFO .= ' <Id>' . $this->emetteur_ics . '</Id>' . $CrLf; |
|
2646 | - $XML_SEPA_INFO .= ' <SchmeNm>' . $CrLf; |
|
2647 | - $XML_SEPA_INFO .= ' <Prtry>SEPA</Prtry>' . $CrLf; |
|
2648 | - $XML_SEPA_INFO .= ' </SchmeNm>' . $CrLf; |
|
2649 | - $XML_SEPA_INFO .= ' </Othr>' . $CrLf; |
|
2650 | - $XML_SEPA_INFO .= ' </PrvtId>' . $CrLf; |
|
2651 | - $XML_SEPA_INFO .= ' </Id>' . $CrLf; |
|
2652 | - $XML_SEPA_INFO .= ' </CdtrSchmeId>' . $CrLf; |
|
2640 | + $XML_SEPA_INFO .= ' <ChrgBr>SLEV</ChrgBr>'.$CrLf; // Field "Responsible of fees". Must be SLEV |
|
2641 | + $XML_SEPA_INFO .= ' <CdtrSchmeId>'.$CrLf; |
|
2642 | + $XML_SEPA_INFO .= ' <Id>'.$CrLf; |
|
2643 | + $XML_SEPA_INFO .= ' <PrvtId>'.$CrLf; |
|
2644 | + $XML_SEPA_INFO .= ' <Othr>'.$CrLf; |
|
2645 | + $XML_SEPA_INFO .= ' <Id>'.$this->emetteur_ics.'</Id>'.$CrLf; |
|
2646 | + $XML_SEPA_INFO .= ' <SchmeNm>'.$CrLf; |
|
2647 | + $XML_SEPA_INFO .= ' <Prtry>SEPA</Prtry>'.$CrLf; |
|
2648 | + $XML_SEPA_INFO .= ' </SchmeNm>'.$CrLf; |
|
2649 | + $XML_SEPA_INFO .= ' </Othr>'.$CrLf; |
|
2650 | + $XML_SEPA_INFO .= ' </PrvtId>'.$CrLf; |
|
2651 | + $XML_SEPA_INFO .= ' </Id>'.$CrLf; |
|
2652 | + $XML_SEPA_INFO .= ' </CdtrSchmeId>'.$CrLf; |
|
2653 | 2653 | } else { |
2654 | 2654 | // SEPA Paiement Information of my company for Credit Transfer |
2655 | 2655 | $XML_SEPA_INFO = ''; |
2656 | - $XML_SEPA_INFO .= ' <PmtInf>' . $CrLf; |
|
2657 | - $XML_SEPA_INFO .= ' <PmtInfId>' . ('DOL/' . $dateTime_YMD . '/CT' . $IdBon . '-' . $RefBon) . '</PmtInfId>' . $CrLf; |
|
2658 | - $XML_SEPA_INFO .= ' <PmtMtd>TRF</PmtMtd>' . $CrLf; |
|
2656 | + $XML_SEPA_INFO .= ' <PmtInf>'.$CrLf; |
|
2657 | + $XML_SEPA_INFO .= ' <PmtInfId>'.('DOL/'.$dateTime_YMD.'/CT'.$IdBon.'-'.$RefBon).'</PmtInfId>'.$CrLf; |
|
2658 | + $XML_SEPA_INFO .= ' <PmtMtd>TRF</PmtMtd>'.$CrLf; |
|
2659 | 2659 | //$XML_SEPA_INFO .= ' <BtchBookg>False</BtchBookg>'.$CrLf; |
2660 | - $XML_SEPA_INFO .= ' <NbOfTxs>' . $nombre . '</NbOfTxs>' . $CrLf; |
|
2661 | - $XML_SEPA_INFO .= ' <CtrlSum>' . $total . '</CtrlSum>' . $CrLf; |
|
2660 | + $XML_SEPA_INFO .= ' <NbOfTxs>'.$nombre.'</NbOfTxs>'.$CrLf; |
|
2661 | + $XML_SEPA_INFO .= ' <CtrlSum>'.$total.'</CtrlSum>'.$CrLf; |
|
2662 | 2662 | if (!empty($this->sepa_xml_pti_in_ctti) && !empty($format)) { // @TODO Using $format (FRST ou RCUR) in a section for a Credit Transfer looks strange. |
2663 | - $XML_SEPA_INFO .= ' <PmtTpInf>' . $CrLf; |
|
2664 | - $XML_SEPA_INFO .= ' <SvcLvl>' . $CrLf; |
|
2665 | - $XML_SEPA_INFO .= ' <Cd>SEPA</Cd>' . $CrLf; |
|
2666 | - $XML_SEPA_INFO .= ' </SvcLvl>' . $CrLf; |
|
2667 | - $XML_SEPA_INFO .= ' <LclInstrm>' . $CrLf; |
|
2668 | - $XML_SEPA_INFO .= ' <Cd>' . $localInstrument . '</Cd>' . $CrLf; |
|
2669 | - $XML_SEPA_INFO .= ' </LclInstrm>' . $CrLf; |
|
2670 | - $XML_SEPA_INFO .= ' <SeqTp>' . $format . '</SeqTp>' . $CrLf; |
|
2671 | - $XML_SEPA_INFO .= ' </PmtTpInf>' . $CrLf; |
|
2663 | + $XML_SEPA_INFO .= ' <PmtTpInf>'.$CrLf; |
|
2664 | + $XML_SEPA_INFO .= ' <SvcLvl>'.$CrLf; |
|
2665 | + $XML_SEPA_INFO .= ' <Cd>SEPA</Cd>'.$CrLf; |
|
2666 | + $XML_SEPA_INFO .= ' </SvcLvl>'.$CrLf; |
|
2667 | + $XML_SEPA_INFO .= ' <LclInstrm>'.$CrLf; |
|
2668 | + $XML_SEPA_INFO .= ' <Cd>'.$localInstrument.'</Cd>'.$CrLf; |
|
2669 | + $XML_SEPA_INFO .= ' </LclInstrm>'.$CrLf; |
|
2670 | + $XML_SEPA_INFO .= ' <SeqTp>'.$format.'</SeqTp>'.$CrLf; |
|
2671 | + $XML_SEPA_INFO .= ' </PmtTpInf>'.$CrLf; |
|
2672 | 2672 | } |
2673 | - $XML_SEPA_INFO .= ' <ReqdExctnDt>' . dol_print_date($dateTime_ETAD, 'dayrfc') . '</ReqdExctnDt>' . $CrLf; |
|
2674 | - $XML_SEPA_INFO .= ' <Dbtr>' . $CrLf; |
|
2675 | - $XML_SEPA_INFO .= ' <Nm>' . dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))) . '</Nm>' . $CrLf; |
|
2676 | - $XML_SEPA_INFO .= ' <PstlAdr>' . $CrLf; |
|
2677 | - $XML_SEPA_INFO .= ' <Ctry>' . $country[1] . '</Ctry>' . $CrLf; |
|
2673 | + $XML_SEPA_INFO .= ' <ReqdExctnDt>'.dol_print_date($dateTime_ETAD, 'dayrfc').'</ReqdExctnDt>'.$CrLf; |
|
2674 | + $XML_SEPA_INFO .= ' <Dbtr>'.$CrLf; |
|
2675 | + $XML_SEPA_INFO .= ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))).'</Nm>'.$CrLf; |
|
2676 | + $XML_SEPA_INFO .= ' <PstlAdr>'.$CrLf; |
|
2677 | + $XML_SEPA_INFO .= ' <Ctry>'.$country[1].'</Ctry>'.$CrLf; |
|
2678 | 2678 | $addressline1 = strtr($configuration->global->MAIN_INFO_SOCIETE_ADDRESS, array(chr(13) => ", ", chr(10) => "")); |
2679 | - $addressline2 = strtr($configuration->global->MAIN_INFO_SOCIETE_ZIP . (($configuration->global->MAIN_INFO_SOCIETE_ZIP || ' ' . $configuration->global->MAIN_INFO_SOCIETE_TOWN) ? ' ' : '') . $configuration->global->MAIN_INFO_SOCIETE_TOWN, array(chr(13) => ", ", chr(10) => "")); |
|
2679 | + $addressline2 = strtr($configuration->global->MAIN_INFO_SOCIETE_ZIP.(($configuration->global->MAIN_INFO_SOCIETE_ZIP || ' '.$configuration->global->MAIN_INFO_SOCIETE_TOWN) ? ' ' : '').$configuration->global->MAIN_INFO_SOCIETE_TOWN, array(chr(13) => ", ", chr(10) => "")); |
|
2680 | 2680 | if ($addressline1) { |
2681 | - $XML_SEPA_INFO .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2681 | + $XML_SEPA_INFO .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline1), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2682 | 2682 | } |
2683 | 2683 | if ($addressline2) { |
2684 | - $XML_SEPA_INFO .= ' <AdrLine>' . dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)) . '</AdrLine>' . $CrLf; |
|
2684 | + $XML_SEPA_INFO .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($addressline2), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
|
2685 | 2685 | } |
2686 | - $XML_SEPA_INFO .= ' </PstlAdr>' . $CrLf; |
|
2687 | - $XML_SEPA_INFO .= ' </Dbtr>' . $CrLf; |
|
2688 | - $XML_SEPA_INFO .= ' <DbtrAcct>' . $CrLf; |
|
2689 | - $XML_SEPA_INFO .= ' <Id>' . $CrLf; |
|
2690 | - $XML_SEPA_INFO .= ' <IBAN>' . preg_replace('/\s/', '', $this->emetteur_iban) . '</IBAN>' . $CrLf; |
|
2691 | - $XML_SEPA_INFO .= ' </Id>' . $CrLf; |
|
2692 | - $XML_SEPA_INFO .= ' </DbtrAcct>' . $CrLf; |
|
2693 | - $XML_SEPA_INFO .= ' <DbtrAgt>' . $CrLf; |
|
2694 | - $XML_SEPA_INFO .= ' <FinInstnId>' . $CrLf; |
|
2695 | - $XML_SEPA_INFO .= ' <BIC>' . $this->emetteur_bic . '</BIC>' . $CrLf; |
|
2696 | - $XML_SEPA_INFO .= ' </FinInstnId>' . $CrLf; |
|
2697 | - $XML_SEPA_INFO .= ' </DbtrAgt>' . $CrLf; |
|
2686 | + $XML_SEPA_INFO .= ' </PstlAdr>'.$CrLf; |
|
2687 | + $XML_SEPA_INFO .= ' </Dbtr>'.$CrLf; |
|
2688 | + $XML_SEPA_INFO .= ' <DbtrAcct>'.$CrLf; |
|
2689 | + $XML_SEPA_INFO .= ' <Id>'.$CrLf; |
|
2690 | + $XML_SEPA_INFO .= ' <IBAN>'.preg_replace('/\s/', '', $this->emetteur_iban).'</IBAN>'.$CrLf; |
|
2691 | + $XML_SEPA_INFO .= ' </Id>'.$CrLf; |
|
2692 | + $XML_SEPA_INFO .= ' </DbtrAcct>'.$CrLf; |
|
2693 | + $XML_SEPA_INFO .= ' <DbtrAgt>'.$CrLf; |
|
2694 | + $XML_SEPA_INFO .= ' <FinInstnId>'.$CrLf; |
|
2695 | + $XML_SEPA_INFO .= ' <BIC>'.$this->emetteur_bic.'</BIC>'.$CrLf; |
|
2696 | + $XML_SEPA_INFO .= ' </FinInstnId>'.$CrLf; |
|
2697 | + $XML_SEPA_INFO .= ' </DbtrAgt>'.$CrLf; |
|
2698 | 2698 | /* $XML_SEPA_INFO .= ' <UltmtCdtr>'.$CrLf; |
2699 | 2699 | $XML_SEPA_INFO .= ' <Nm>'.dolEscapeXML(strtoupper(dol_string_nospecial(dol_string_unaccent($this->raison_sociale), ' '))).'</Nm>'.$CrLf; |
2700 | 2700 | $XML_SEPA_INFO .= ' <PstlAdr>'.$CrLf; |
@@ -2703,7 +2703,7 @@ discard block |
||
2703 | 2703 | $XML_SEPA_INFO .= ' <AdrLine>'.dolEscapeXML(dol_trunc(dol_string_nospecial(dol_string_unaccent($conf->global->MAIN_INFO_SOCIETE_ZIP.' '.$conf->global->MAIN_INFO_SOCIETE_TOWN), ' '), 70, 'right', 'UTF-8', 1)).'</AdrLine>'.$CrLf; |
2704 | 2704 | $XML_SEPA_INFO .= ' </PstlAdr>'.$CrLf; |
2705 | 2705 | $XML_SEPA_INFO .= ' </UltmtCdtr>'.$CrLf;*/ |
2706 | - $XML_SEPA_INFO .= ' <ChrgBr>SLEV</ChrgBr>' . $CrLf; // Field "Responsible of fees". Must be SLEV |
|
2706 | + $XML_SEPA_INFO .= ' <ChrgBr>SLEV</ChrgBr>'.$CrLf; // Field "Responsible of fees". Must be SLEV |
|
2707 | 2707 | /*$XML_SEPA_INFO .= ' <CdtrSchmeId>'.$CrLf; |
2708 | 2708 | $XML_SEPA_INFO .= ' <Id>'.$CrLf; |
2709 | 2709 | $XML_SEPA_INFO .= ' <PrvtId>'.$CrLf; |
@@ -2718,7 +2718,7 @@ discard block |
||
2718 | 2718 | $XML_SEPA_INFO .= ' </CdtrSchmeId>'.$CrLf;*/ |
2719 | 2719 | } |
2720 | 2720 | } else { |
2721 | - fwrite($this->file, 'INCORRECT EMETTEUR ' . $this->raison_sociale . $CrLf); |
|
2721 | + fwrite($this->file, 'INCORRECT EMETTEUR '.$this->raison_sociale.$CrLf); |
|
2722 | 2722 | $XML_SEPA_INFO = ''; |
2723 | 2723 | } |
2724 | 2724 | return $XML_SEPA_INFO; |
@@ -2770,7 +2770,7 @@ discard block |
||
2770 | 2770 | |
2771 | 2771 | $montant = ($total * 100); |
2772 | 2772 | |
2773 | - fwrite($this->file, substr("000000000000000" . $montant, -16)); |
|
2773 | + fwrite($this->file, substr("000000000000000".$montant, -16)); |
|
2774 | 2774 | |
2775 | 2775 | // Zone Reservee F |
2776 | 2776 | |
@@ -2927,18 +2927,18 @@ discard block |
||
2927 | 2927 | $return .= img_picto('', $this->picto); |
2928 | 2928 | $return .= '</span>'; |
2929 | 2929 | $return .= '<div class="info-box-content">'; |
2930 | - $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . (method_exists($this, 'getNomUrl') ? $this->getNomUrl(1) : $this->ref) . '</span>'; |
|
2930 | + $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl(1) : $this->ref).'</span>'; |
|
2931 | 2931 | if ($selected >= 0) { |
2932 | - $return .= '<input id="cb' . $this->id . '" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="' . $this->id . '"' . ($selected ? ' checked="checked"' : '') . '>'; |
|
2932 | + $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>'; |
|
2933 | 2933 | } |
2934 | 2934 | if (property_exists($this, 'date_echeance')) { |
2935 | - $return .= '<br><span class="opacitymedium">' . $langs->trans("Date") . '</span> : <span class="info-box-label">' . dol_print_date($this->db->jdate($this->date_echeance), 'day') . '</span>'; |
|
2935 | + $return .= '<br><span class="opacitymedium">'.$langs->trans("Date").'</span> : <span class="info-box-label">'.dol_print_date($this->db->jdate($this->date_echeance), 'day').'</span>'; |
|
2936 | 2936 | } |
2937 | 2937 | if (property_exists($this, 'total')) { |
2938 | - $return .= '<br><span class="opacitymedium">' . $langs->trans("Amount") . '</span> : <span class="amount">' . price($this->total) . '</span>'; |
|
2938 | + $return .= '<br><span class="opacitymedium">'.$langs->trans("Amount").'</span> : <span class="amount">'.price($this->total).'</span>'; |
|
2939 | 2939 | } |
2940 | 2940 | if (method_exists($this, 'LibStatut')) { |
2941 | - $return .= '<br><div class="info-box-status">' . $this->getLibStatut(3) . '</div>'; |
|
2941 | + $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>'; |
|
2942 | 2942 | } |
2943 | 2943 | $return .= '</div>'; |
2944 | 2944 | $return .= '</div>'; |
@@ -2959,9 +2959,9 @@ discard block |
||
2959 | 2959 | return 0; |
2960 | 2960 | } |
2961 | 2961 | if ($id) { |
2962 | - $sql = "SELECT COUNT(*) AS nb FROM " . MAIN_DB_PREFIX . "prelevement_lignes"; |
|
2963 | - $sql .= " WHERE fk_prelevement_bons = " . ((int) $id); |
|
2964 | - $sql .= " AND fk_soc = 0"; // fk_soc can't be NULL |
|
2962 | + $sql = "SELECT COUNT(*) AS nb FROM ".MAIN_DB_PREFIX."prelevement_lignes"; |
|
2963 | + $sql .= " WHERE fk_prelevement_bons = ".((int) $id); |
|
2964 | + $sql .= " AND fk_soc = 0"; // fk_soc can't be NULL |
|
2965 | 2965 | $sql .= " AND fk_user IS NOT NULL"; |
2966 | 2966 | |
2967 | 2967 | $num = 0; |