@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | */ |
70 | 70 | public $fk_website; |
71 | 71 | |
72 | - public $fk_page; // If translation of another page |
|
72 | + public $fk_page; // If translation of another page |
|
73 | 73 | |
74 | 74 | public $pageurl; |
75 | 75 | public $aliasalt; |
@@ -134,8 +134,8 @@ discard block |
||
134 | 134 | */ |
135 | 135 | public $fk_object; |
136 | 136 | |
137 | - const STATUS_DRAFT = 0; // offline |
|
138 | - const STATUS_VALIDATED = 1; // online |
|
137 | + const STATUS_DRAFT = 0; // offline |
|
138 | + const STATUS_VALIDATED = 1; // online |
|
139 | 139 | |
140 | 140 | |
141 | 141 | /** |
@@ -1145,7 +1145,7 @@ discard block |
||
1145 | 1145 | $stringtoexport = str_replace('medias/image/' . $website->ref . '/', "medias/image/__WEBSITE_KEY__/", $stringtoexport); |
1146 | 1146 | $stringtoexport = str_replace('medias/js/' . $website->ref . '/', "medias/js/__WEBSITE_KEY__/", $stringtoexport); |
1147 | 1147 | $stringtoexport = str_replace('"image/' . $website->ref . '/', '"image/__WEBSITE_KEY__/', $stringtoexport); // When we have a link src="image/websiteref/file.png" into html content |
1148 | - $stringtoexport = str_replace('"/image/' . $website->ref . '/', '"/image/__WEBSITE_KEY__/', $stringtoexport); // When we have a link src="/image/websiteref/file.png" into html content |
|
1148 | + $stringtoexport = str_replace('"/image/' . $website->ref . '/', '"/image/__WEBSITE_KEY__/', $stringtoexport); // When we have a link src="/image/websiteref/file.png" into html content |
|
1149 | 1149 | $stringtoexport = str_replace('"js/' . $website->ref . '/', '"js/__WEBSITE_KEY__/', $stringtoexport); |
1150 | 1150 | $stringtoexport = str_replace('"/js/' . $website->ref . '/', '"/js/__WEBSITE_KEY__/', $stringtoexport); |
1151 | 1151 | |
@@ -1464,7 +1464,7 @@ discard block |
||
1464 | 1464 | $filetpl = $pathofwebsite . '/page' . $object->fk_default_home . '.tpl.php'; |
1465 | 1465 | } |
1466 | 1466 | $filewrapper = $pathofwebsite . '/wrapper.php'; |
1467 | - dolSaveIndexPage($pathofwebsite, $fileindex, $filetpl, $filewrapper, $object); // This includes also a version of index.php into sublanguage directories |
|
1467 | + dolSaveIndexPage($pathofwebsite, $fileindex, $filetpl, $filewrapper, $object); // This includes also a version of index.php into sublanguage directories |
|
1468 | 1468 | } |
1469 | 1469 | |
1470 | 1470 | if ($error) { |
@@ -1867,7 +1867,7 @@ discard block |
||
1867 | 1867 | $destContent = file_get_contents($fileNeeded['fullname']); |
1868 | 1868 | |
1869 | 1869 | $numOfPageDest = $this->extractNumberFromFilename($fileNeeded['name']); |
1870 | - $differences = $this->showDifferences($destContent, $sourceContent, array($numOfPageDest,$numOfPageSource)); |
|
1870 | + $differences = $this->showDifferences($destContent, $sourceContent, array($numOfPageDest, $numOfPageSource)); |
|
1871 | 1871 | $differences['file_destination'] = $fileNeeded; |
1872 | 1872 | } |
1873 | 1873 | return $differences; |
@@ -1908,7 +1908,7 @@ discard block |
||
1908 | 1908 | $linefound = array(); |
1909 | 1909 | $countNumPage = count($exceptNumPge); |
1910 | 1910 | |
1911 | - for ($i = 0;$i < $countNumPage; $i++) { |
|
1911 | + for ($i = 0; $i < $countNumPage; $i++) { |
|
1912 | 1912 | $linefound[$i] = array(); |
1913 | 1913 | $linefound[$i]['meta'] = '/content="' . preg_quote($exceptNumPge[$i], '/') . '" \/>/'; |
1914 | 1914 | $linefound[$i]['output'] = '/dolWebsiteOutput\(\$tmp, "html", ' . preg_quote($exceptNumPge[$i], '/') . '\);/'; |
@@ -84,7 +84,7 @@ |
||
84 | 84 | $search_multicurrency_montant_ht = GETPOST('search_multicurrency_montant_ht', 'alpha'); |
85 | 85 | $search_multicurrency_montant_vat = GETPOST('search_multicurrency_montant_vat', 'alpha'); |
86 | 86 | $search_multicurrency_montant_ttc = GETPOST('search_multicurrency_montant_ttc', 'alpha'); |
87 | -$search_status = GETPOST('search_status', 'intcomma'); // Can be '' or a numeric |
|
87 | +$search_status = GETPOST('search_status', 'intcomma'); // Can be '' or a numeric |
|
88 | 88 | $search_paymentmode = GETPOSTINT('search_paymentmode'); |
89 | 89 | $search_paymentcond = GETPOSTINT('search_paymentcond'); |
90 | 90 | $search_town = GETPOST('search_town', 'alpha'); |
@@ -312,14 +312,14 @@ discard block |
||
312 | 312 | |
313 | 313 | // Creation of payment line |
314 | 314 | $paiement = new PaiementFourn($db); |
315 | - $paiement->datepaye = $datepaye; |
|
315 | + $paiement->datepaye = $datepaye; |
|
316 | 316 | |
317 | 317 | $correctedAmounts = []; |
318 | 318 | foreach ($amounts as $key => $value) { |
319 | 319 | $correctedAmounts[$key] = (float) $value; |
320 | 320 | } |
321 | 321 | |
322 | - $paiement->amounts = $correctedAmounts; // Array of amounts |
|
322 | + $paiement->amounts = $correctedAmounts; // Array of amounts |
|
323 | 323 | $paiement->multicurrency_amounts = $multicurrency_amounts; |
324 | 324 | $paiement->multicurrency_code = $multicurrency_code; // Array with all currency of payments dispatching |
325 | 325 | $paiement->multicurrency_tx = $multicurrency_tx; // Array with all currency tx of payments dispatching |
@@ -610,8 +610,8 @@ discard block |
||
610 | 610 | $total = 0; |
611 | 611 | $total_ttc = 0; |
612 | 612 | $totalrecu = 0; |
613 | - $totalrecucreditnote = 0; // PHP Warning: Undefined variable $totalrecucreditnote |
|
614 | - $totalrecudeposits = 0; // PHP Warning: Undefined variable $totalrecudeposits |
|
613 | + $totalrecucreditnote = 0; // PHP Warning: Undefined variable $totalrecucreditnote |
|
614 | + $totalrecudeposits = 0; // PHP Warning: Undefined variable $totalrecudeposits |
|
615 | 615 | while ($i < $num) { |
616 | 616 | $objp = $db->fetch_object($resql); |
617 | 617 |
@@ -84,10 +84,10 @@ discard block |
||
84 | 84 | $page = 0; |
85 | 85 | } // If $page is not defined, or '' or -1 |
86 | 86 | $offset = $limit * $page; |
87 | -if (! $sortorder) { |
|
87 | +if (!$sortorder) { |
|
88 | 88 | $sortorder = 'DESC'; |
89 | 89 | } |
90 | -if (! $sortfield) { |
|
90 | +if (!$sortfield) { |
|
91 | 91 | $sortfield = 'f.titre'; |
92 | 92 | } |
93 | 93 | $pageprev = $page - 1; |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | $object = new FactureFournisseurRec($db); |
97 | 97 | if (($id > 0 || $title) && $action != 'create' && $action != 'add') { |
98 | 98 | $ret = $object->fetch($id, $title); |
99 | - if (! $ret) { |
|
99 | + if (!$ret) { |
|
100 | 100 | setEventMessages($langs->trans("ErrorRecordNotFound"), null, 'errors'); |
101 | 101 | } |
102 | 102 | } |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | $action = 'list'; |
141 | 141 | $massaction = ''; |
142 | 142 | } |
143 | -if (! GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') { |
|
143 | +if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') { |
|
144 | 144 | $massaction = ''; |
145 | 145 | } |
146 | 146 | |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | |
168 | 168 | // Create predefined invoice |
169 | 169 | if ($action == 'add') { |
170 | - if (! GETPOST('title', 'alphanohtml')) { |
|
170 | + if (!GETPOST('title', 'alphanohtml')) { |
|
171 | 171 | setEventMessages($langs->transnoentities("ErrorFieldRequired", $langs->trans("Title")), null, 'errors'); |
172 | 172 | $action = "create"; |
173 | 173 | $error++; |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | } |
191 | 191 | } |
192 | 192 | |
193 | - if (! $error) { |
|
193 | + if (!$error) { |
|
194 | 194 | $object->titre = GETPOST('title', 'alphanohtml'); // deprecated |
195 | 195 | $object->title = GETPOST('title', 'alphanohtml'); |
196 | 196 | $object->libelle = GETPOST('libelle', 'alpha'); // deprecated |
@@ -239,7 +239,7 @@ discard block |
||
239 | 239 | $action = "create"; |
240 | 240 | } |
241 | 241 | |
242 | - if (! $error) { |
|
242 | + if (!$error) { |
|
243 | 243 | $db->commit(); |
244 | 244 | |
245 | 245 | header("Location: " . $_SERVER['PHP_SELF'] . '?facid=' . $object->id); |
@@ -289,7 +289,7 @@ discard block |
||
289 | 289 | $result = $object->setValueFrom('titre', $title, '', null, 'text', '', $user); |
290 | 290 | |
291 | 291 | if ($result > 0) { |
292 | - $object->titre = $title; // deprecated |
|
292 | + $object->titre = $title; // deprecated |
|
293 | 293 | $object->title = $title; |
294 | 294 | $object->ref = $object->title; |
295 | 295 | } else { |
@@ -336,7 +336,7 @@ discard block |
||
336 | 336 | $error++; |
337 | 337 | } |
338 | 338 | |
339 | - if (! $error) { |
|
339 | + if (!$error) { |
|
340 | 340 | $db->commit(); |
341 | 341 | } else { |
342 | 342 | $db->rollback(); |
@@ -353,7 +353,7 @@ discard block |
||
353 | 353 | $error++; |
354 | 354 | } |
355 | 355 | |
356 | - if (! $error) { |
|
356 | + if (!$error) { |
|
357 | 357 | $db->commit(); |
358 | 358 | } else { |
359 | 359 | $db->rollback(); |
@@ -412,7 +412,7 @@ discard block |
||
412 | 412 | $error++; |
413 | 413 | } |
414 | 414 | |
415 | - if (! $error) { |
|
415 | + if (!$error) { |
|
416 | 416 | $result = $object->insertExtraFields('BILLREC_MODIFY'); |
417 | 417 | if ($result < 0) { |
418 | 418 | setEventMessages($object->error, $object->errors, 'errors'); |
@@ -463,7 +463,7 @@ discard block |
||
463 | 463 | setEventMessages($langs->trans('ErrorFieldRequired', $langs->transnoentitiesnoconv('Type')), null, 'errors'); |
464 | 464 | $error++; |
465 | 465 | } |
466 | - if ($prod_entry_mode == 'free' && (empty($idprod) || $idprod < 0) && (! ($price_ht >= 0) || $price_ht == '')) { // Unit price can be 0 but not '' |
|
466 | + if ($prod_entry_mode == 'free' && (empty($idprod) || $idprod < 0) && (!($price_ht >= 0) || $price_ht == '')) { // Unit price can be 0 but not '' |
|
467 | 467 | setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("UnitPriceHT")), null, 'errors'); |
468 | 468 | $error++; |
469 | 469 | } |
@@ -512,7 +512,7 @@ discard block |
||
512 | 512 | } |
513 | 513 | } |
514 | 514 | |
515 | - if (! $error && ($qty >= 0) && (!empty($product_desc) || (!empty($idprod) && $idprod > 0))) { |
|
515 | + if (!$error && ($qty >= 0) && (!empty($product_desc) || (!empty($idprod) && $idprod > 0))) { |
|
516 | 516 | $ret = $object->fetch($id); |
517 | 517 | if ($ret < 0) { |
518 | 518 | dol_print_error($db, $object->error); |
@@ -728,8 +728,8 @@ discard block |
||
728 | 728 | $action = ''; |
729 | 729 | } |
730 | 730 | } |
731 | - } elseif ($action == 'updateline' && $usercancreate && ! GETPOST('cancel', 'alpha')) { |
|
732 | - if (! $object->fetch($id) > 0) { |
|
731 | + } elseif ($action == 'updateline' && $usercancreate && !GETPOST('cancel', 'alpha')) { |
|
732 | + if (!$object->fetch($id) > 0) { |
|
733 | 733 | dol_print_error($db); |
734 | 734 | } |
735 | 735 | $object->fetch_thirdparty(); |
@@ -780,7 +780,7 @@ discard block |
||
780 | 780 | |
781 | 781 | // Define special_code for special lines |
782 | 782 | $special_code = GETPOSTINT('special_code'); |
783 | - if (! GETPOST('qty', 'alpha')) { |
|
783 | + if (!GETPOST('qty', 'alpha')) { |
|
784 | 784 | $special_code = 3; |
785 | 785 | } |
786 | 786 | |
@@ -826,7 +826,7 @@ discard block |
||
826 | 826 | $date_end_fill = !empty(GETPOSTINT('date_end_fill')) ? GETPOSTINT('date_end_fill') : 'NULL'; |
827 | 827 | |
828 | 828 | // Update line |
829 | - if (! $error) { |
|
829 | + if (!$error) { |
|
830 | 830 | $result = $object->updateline(GETPOSTINT('lineid'), GETPOSTINT('productid'), $ref_fourn, $label, $description, $pu_ht, $qty, $remise_percent, $vat_rate, $localtax1_rate, $localtax1_rate, 'HT', $type, $date_start_fill, $date_end_fill, $info_bits, $special_code, -1); |
831 | 831 | if ($result >= 0) { |
832 | 832 | $object->fetch($object->id); // Reload lines |
@@ -1456,8 +1456,8 @@ discard block |
||
1456 | 1456 | print $form->editfieldval($langs->trans("NextDateToExecution"), 'date_when', $object->date_when, $object, $usercancreate, 'day', $object->date_when, null, '', '', 0, 'strikeIfMaxNbGenReached'); |
1457 | 1457 | } |
1458 | 1458 | //var_dump(dol_print_date($object->date_when+60, 'dayhour').' - '.dol_print_date($now, 'dayhour')); |
1459 | - if (! $object->isMaxNbGenReached()) { |
|
1460 | - if (! $object->suspended && $action != 'editdate_when' && $object->frequency > 0 && $object->date_when && $object->date_when < $now) { |
|
1459 | + if (!$object->isMaxNbGenReached()) { |
|
1460 | + if (!$object->suspended && $action != 'editdate_when' && $object->frequency > 0 && $object->date_when && $object->date_when < $now) { |
|
1461 | 1461 | print img_warning($langs->trans("Late")); |
1462 | 1462 | } |
1463 | 1463 | } else { |
@@ -81,7 +81,7 @@ discard block |
||
81 | 81 | $search_date_endday = GETPOSTINT('search_date_endday'); |
82 | 82 | $search_date_endmonth = GETPOSTINT('search_date_endmonth'); |
83 | 83 | $search_date_endyear = GETPOSTINT('search_date_endyear'); |
84 | -$search_date_start = dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear); // Use tzserver |
|
84 | +$search_date_start = dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear); // Use tzserver |
|
85 | 85 | $search_date_end = dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear); |
86 | 86 | $search_date_when_startday = GETPOSTINT('search_date_when_startday'); |
87 | 87 | $search_date_when_startmonth = GETPOSTINT('search_date_when_startmonth'); |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | $search_date_when_endday = GETPOSTINT('search_date_when_endday'); |
90 | 90 | $search_date_when_endmonth = GETPOSTINT('search_date_when_endmonth'); |
91 | 91 | $search_date_when_endyear = GETPOSTINT('search_date_when_endyear'); |
92 | -$search_date_when_start = dol_mktime(0, 0, 0, $search_date_when_startmonth, $search_date_when_startday, $search_date_when_startyear); // Use tzserver |
|
92 | +$search_date_when_start = dol_mktime(0, 0, 0, $search_date_when_startmonth, $search_date_when_startday, $search_date_when_startyear); // Use tzserver |
|
93 | 93 | $search_date_when_end = dol_mktime(23, 59, 59, $search_date_when_endmonth, $search_date_when_endday, $search_date_when_endyear); |
94 | 94 | $search_recurring = GETPOSTINT('search_recurring'); |
95 | 95 | $search_frequency = GETPOST('search_frequency', 'alpha'); |
@@ -776,7 +776,7 @@ discard block |
||
776 | 776 | $error++; |
777 | 777 | } |
778 | 778 | |
779 | - $dateinvoice = dol_mktime(0, 0, 0, GETPOSTINT('remonth'), GETPOSTINT('reday'), GETPOSTINT('reyear'), 'tzserver'); // If we enter the 02 january, we need to save the 02 january for server |
|
779 | + $dateinvoice = dol_mktime(0, 0, 0, GETPOSTINT('remonth'), GETPOSTINT('reday'), GETPOSTINT('reyear'), 'tzserver'); // If we enter the 02 january, we need to save the 02 january for server |
|
780 | 780 | $datedue = dol_mktime(0, 0, 0, GETPOSTINT('echmonth'), GETPOSTINT('echday'), GETPOSTINT('echyear'), 'tzserver'); |
781 | 781 | //var_dump($dateinvoice.' '.dol_print_date($dateinvoice, 'dayhour')); |
782 | 782 | //var_dump(dol_now('tzuserrel').' '.dol_get_last_hour(dol_now('tzuserrel')).' '.dol_print_date(dol_now('tzuserrel'),'dayhour').' '.dol_print_date(dol_get_last_hour(dol_now('tzuserrel')), 'dayhour')); |
@@ -1058,7 +1058,7 @@ discard block |
||
1058 | 1058 | $object->ref = GETPOST('ref', 'alphanohtml'); |
1059 | 1059 | $object->ref_supplier = GETPOST('ref_supplier', 'alphanohtml'); |
1060 | 1060 | $object->socid = GETPOSTINT('socid'); |
1061 | - $object->libelle = GETPOST('label', 'alphanohtml'); // deprecated |
|
1061 | + $object->libelle = GETPOST('label', 'alphanohtml'); // deprecated |
|
1062 | 1062 | $object->label = GETPOST('label', 'alphanohtml'); |
1063 | 1063 | $object->date = $dateinvoice; |
1064 | 1064 | $object->date_echeance = $datedue; |
@@ -1414,7 +1414,7 @@ discard block |
||
1414 | 1414 | // Edit line |
1415 | 1415 | $db->begin(); |
1416 | 1416 | |
1417 | - if (! $object->fetch($id) > 0) { |
|
1417 | + if (!$object->fetch($id) > 0) { |
|
1418 | 1418 | dol_print_error($db); |
1419 | 1419 | } |
1420 | 1420 | $object->fetch_thirdparty(); |
@@ -1558,7 +1558,7 @@ discard block |
||
1558 | 1558 | $idprod = GETPOSTINT('idprod'); |
1559 | 1559 | } |
1560 | 1560 | |
1561 | - $tva_tx = (GETPOST('tva_tx') ? GETPOST('tva_tx') : 0); // Can be '1.2' or '1.2 (CODE)' |
|
1561 | + $tva_tx = (GETPOST('tva_tx') ? GETPOST('tva_tx') : 0); // Can be '1.2' or '1.2 (CODE)' |
|
1562 | 1562 | |
1563 | 1563 | $price_ht = price2num(GETPOST('price_ht'), 'MU', 2); |
1564 | 1564 | $price_ht_devise = price2num(GETPOST('multicurrency_price_ht'), 'CU', 2); |
@@ -2257,7 +2257,7 @@ discard block |
||
2257 | 2257 | print '<form name="add" action="' . $_SERVER['PHP_SELF'] . '" method="post">'; |
2258 | 2258 | print '<input type="hidden" name="token" value="' . newToken() . '">'; |
2259 | 2259 | print '<input type="hidden" name="action" value="add">'; |
2260 | - print '<input type="hidden" name="changecompany" value="0">'; // will be set to 1 by javascript so we know post is done after a company change |
|
2260 | + print '<input type="hidden" name="changecompany" value="0">'; // will be set to 1 by javascript so we know post is done after a company change |
|
2261 | 2261 | |
2262 | 2262 | if (!empty($societe->id) && $societe->id > 0) { |
2263 | 2263 | print '<input type="hidden" name="socid" value="' . $societe->id . '">' . "\n"; |
@@ -4147,7 +4147,7 @@ discard block |
||
4147 | 4147 | } |
4148 | 4148 | |
4149 | 4149 | // Clone as predefined / Create template |
4150 | - if (($object->type == FactureFournisseur::TYPE_STANDARD || $object->type == FactureFournisseur::TYPE_DEPOSIT) && $object->statut == 0 && $usercancreate) { |
|
4150 | + if (($object->type == FactureFournisseur::TYPE_STANDARD || $object->type == FactureFournisseur::TYPE_DEPOSIT) && $object->statut == 0 && $usercancreate) { |
|
4151 | 4151 | if (!$objectidnext && count($object->lines) > 0) { |
4152 | 4152 | print '<a class="butAction" href="' . DOL_URL_ROOT . '/fourn/facture/card-rec.php?facid=' . $object->id . '&action=create">' . $langs->trans("ChangeIntoRepeatableInvoice") . '</a>'; |
4153 | 4153 | } |
@@ -49,7 +49,7 @@ |
||
49 | 49 | $socid = $user->socid; |
50 | 50 | } |
51 | 51 | $result = restrictedArea($user, 'fournisseur', $id, 'facture_fourn', 'facture'); |
52 | -$hookmanager->initHooks(array('invoicesuppliercardcontact','invoicesuppliercontactcard', 'globalcard')); |
|
52 | +$hookmanager->initHooks(array('invoicesuppliercardcontact', 'invoicesuppliercontactcard', 'globalcard')); |
|
53 | 53 | |
54 | 54 | $object = new FactureFournisseur($db); |
55 | 55 |
@@ -60,7 +60,7 @@ discard block |
||
60 | 60 | $search_date_endday = GETPOSTINT('search_date_endday'); |
61 | 61 | $search_date_endmonth = GETPOSTINT('search_date_endmonth'); |
62 | 62 | $search_date_endyear = GETPOSTINT('search_date_endyear'); |
63 | -$search_date_start = dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear); // Use tzserver |
|
63 | +$search_date_start = dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear); // Use tzserver |
|
64 | 64 | $search_date_end = dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear); |
65 | 65 | $search_company = GETPOST('search_company', 'alpha'); |
66 | 66 | $search_payment_type = GETPOST('search_payment_type'); |
@@ -204,7 +204,7 @@ discard block |
||
204 | 204 | $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'facture_fourn AS f ON f.rowid = pf.fk_facturefourn'; |
205 | 205 | $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe AS s ON s.rowid = f.fk_soc'; |
206 | 206 | |
207 | -$sql .= ' WHERE f.entity IN (' . getEntity('supplier_invoice') . ')'; // TODO We should use p.entity that does not exists yet in this table |
|
207 | +$sql .= ' WHERE f.entity IN (' . getEntity('supplier_invoice') . ')'; // TODO We should use p.entity that does not exists yet in this table |
|
208 | 208 | if ($socid > 0) { |
209 | 209 | $sql .= " AND EXISTS (SELECT f.fk_soc FROM " . MAIN_DB_PREFIX . "facture_fourn as f, " . MAIN_DB_PREFIX . "paiementfourn_facturefourn as pf"; |
210 | 210 | $sql .= " WHERE p.rowid = pf.fk_paiementfourn AND pf.fk_facturefourn = f.rowid AND f.fk_soc = " . ((int) $socid) . ")"; |