@@ -537,8 +537,8 @@ |
||
| 537 | 537 | // Ref customer |
| 538 | 538 | //$morehtmlref.=$form->editfieldkey("RefCustomer", 'ref_client', $fichinter->ref_client, $fichinter, $user->rights->ficheinter->creer, 'string', '', 0, 1); |
| 539 | 539 | //$morehtmlref.=$form->editfieldval("RefCustomer", 'ref_client', $fichinter->ref_client, $fichinter, $user->rights->ficheinter->creer, 'string', '', null, null, '', 1); |
| 540 | - $morehtmlref.=$form->editfieldkey("RefCustomer", 'ref_client', $fichinter->ref_client, $fichinter, 0, 'string', '', 0, 1); |
|
| 541 | - $morehtmlref.=$form->editfieldval("RefCustomer", 'ref_client', $fichinter->ref_client, $fichinter, 0, 'string', '', null, null, '', 1); |
|
| 540 | + $morehtmlref .= $form->editfieldkey("RefCustomer", 'ref_client', $fichinter->ref_client, $fichinter, 0, 'string', '', 0, 1); |
|
| 541 | + $morehtmlref .= $form->editfieldval("RefCustomer", 'ref_client', $fichinter->ref_client, $fichinter, 0, 'string', '', null, null, '', 1); |
|
| 542 | 542 | // Thirdparty |
| 543 | 543 | $morehtmlref .= '<br>'.$fichinter->thirdparty->getNomUrl(1, 'customer'); |
| 544 | 544 | // Project |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | |
| 101 | 101 | $websitekey = ''; |
| 102 | 102 | |
| 103 | -$permissiontoadd = $permissiontouploadfile; // Used by the include of actions_addupdatedelete.inc.php and actions_linkedfiles |
|
| 103 | +$permissiontoadd = $permissiontouploadfile; // Used by the include of actions_addupdatedelete.inc.php and actions_linkedfiles |
|
| 104 | 104 | |
| 105 | 105 | // Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context |
| 106 | 106 | $hookmanager->initHooks(array('ecmmediascard', 'globalcard')); |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | if ($sortorder) { |
| 118 | 118 | $backtopage .= '&sortorder='.urlencode($sortorder); |
| 119 | 119 | } |
| 120 | -include DOL_DOCUMENT_ROOT.'/core/actions_linkedfiles.inc.php'; // This manage 'sendit', 'confirm_deletefile', 'renamefile' action when submitting new file. |
|
| 120 | +include DOL_DOCUMENT_ROOT.'/core/actions_linkedfiles.inc.php'; // This manage 'sendit', 'confirm_deletefile', 'renamefile' action when submitting new file. |
|
| 121 | 121 | |
| 122 | 122 | $backtopage = $savbacktopage; |
| 123 | 123 | |
@@ -179,9 +179,9 @@ |
||
| 179 | 179 | public $max_total_amount_of_all_payments; |
| 180 | 180 | public $preapproval_key; |
| 181 | 181 | public $total_amount_of_all_payments; |
| 182 | - public $stripe_card_ref; // External system payment mode ID |
|
| 183 | - public $stripe_account; // External system customer ID |
|
| 184 | - public $ext_payment_site; // External system 'StripeLive', 'StripeTest', 'StancerLive', 'StancerTest', ... |
|
| 182 | + public $stripe_card_ref; // External system payment mode ID |
|
| 183 | + public $stripe_account; // External system customer ID |
|
| 184 | + public $ext_payment_site; // External system 'StripeLive', 'StripeTest', 'StancerLive', 'StancerTest', ... |
|
| 185 | 185 | |
| 186 | 186 | /** |
| 187 | 187 | * @var int Status |
@@ -280,7 +280,7 @@ |
||
| 280 | 280 | |
| 281 | 281 | // Type |
| 282 | 282 | $membertypestatic->id = $objp->type_id; |
| 283 | - $membertypestatic->libelle = $objp->type_label; // deprecated |
|
| 283 | + $membertypestatic->libelle = $objp->type_label; // deprecated |
|
| 284 | 284 | $membertypestatic->label = $objp->type_label; |
| 285 | 285 | |
| 286 | 286 | print '<td class="nowrap">'; |
@@ -216,7 +216,7 @@ |
||
| 216 | 216 | if (!$disable_delete) { |
| 217 | 217 | print dolGetButtonAction($langs->trans('Delete'), '', 'delete', $_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delete&token='.newToken(), '', 1); |
| 218 | 218 | } else { |
| 219 | - print dolGetButtonAction($langs->trans("CantRemovePaymentWithOneInvoicePaid"), $langs->trans('Delete'), '', $_SERVER["PHP_SELF"].'?id='.$object->id.'#', '', 1, [ 'attr' => ['classOverride' => 'butActionRefused']]); |
|
| 219 | + print dolGetButtonAction($langs->trans("CantRemovePaymentWithOneInvoicePaid"), $langs->trans('Delete'), '', $_SERVER["PHP_SELF"].'?id='.$object->id.'#', '', 1, ['attr' => ['classOverride' => 'butActionRefused']]); |
|
| 220 | 220 | } |
| 221 | 221 | } |
| 222 | 222 | } |
@@ -137,7 +137,7 @@ discard block |
||
| 137 | 137 | // set filter for each period available |
| 138 | 138 | $filter = array(); |
| 139 | 139 | $doc_date_start = null; |
| 140 | - $doc_date_end= null; |
|
| 140 | + $doc_date_end = null; |
|
| 141 | 141 | $now = dol_now(); |
| 142 | 142 | $now_arr = dol_getdate($now); |
| 143 | 143 | $now_month = $now_arr['mon']; |
@@ -173,9 +173,9 @@ discard block |
||
| 173 | 173 | $prev_month_date_list = array(); |
| 174 | 174 | $prev_month_date_list[] = dol_get_prev_month($now_month, $now_year); // get previous month for index = 0 |
| 175 | 175 | for ($i = 1; $i < $nb_prev_month; $i++) { |
| 176 | - $prev_month_date_list[] = dol_get_prev_month($prev_month_date_list[$i-1]['month'], $prev_month_date_list[$i-1]['year']); // get i+1 previous month for index=i |
|
| 176 | + $prev_month_date_list[] = dol_get_prev_month($prev_month_date_list[$i - 1]['month'], $prev_month_date_list[$i - 1]['year']); // get i+1 previous month for index=i |
|
| 177 | 177 | } |
| 178 | - $doc_date_start = dol_mktime(0, 0, 0, $prev_month_date_list[$nb_prev_month-1]['month'], 1, $prev_month_date_list[$nb_prev_month-1]['year']); // first day of n previous month for index=n-1 |
|
| 178 | + $doc_date_start = dol_mktime(0, 0, 0, $prev_month_date_list[$nb_prev_month - 1]['month'], 1, $prev_month_date_list[$nb_prev_month - 1]['year']); // first day of n previous month for index=n-1 |
|
| 179 | 179 | $doc_date_end = dol_get_last_day($prev_month_date_list[0]['year'], $prev_month_date_list[0]['month']); // last day of previous month for index = 0 |
| 180 | 180 | } elseif ($period == 'currentyear' || $period == 'lastyear') { |
| 181 | 181 | $period_year = $now_year; |
@@ -242,9 +242,9 @@ discard block |
||
| 242 | 242 | foreach ($bookkeeping->lines as $movement) { |
| 243 | 243 | $now = dol_now(); |
| 244 | 244 | |
| 245 | - $sql = " UPDATE " . MAIN_DB_PREFIX . "accounting_bookkeeping"; |
|
| 246 | - $sql .= " SET date_export = '" . $this->db->idate($now) . "'"; |
|
| 247 | - $sql .= " WHERE rowid = " . ((int) $movement->id); |
|
| 245 | + $sql = " UPDATE ".MAIN_DB_PREFIX."accounting_bookkeeping"; |
|
| 246 | + $sql .= " SET date_export = '".$this->db->idate($now)."'"; |
|
| 247 | + $sql .= " WHERE rowid = ".((int) $movement->id); |
|
| 248 | 248 | |
| 249 | 249 | $result = $this->db->query($sql); |
| 250 | 250 | if (!$result) { |
@@ -2387,14 +2387,14 @@ |
||
| 2387 | 2387 | } |
| 2388 | 2388 | |
| 2389 | 2389 | /** |
| 2390 | - * Export format : iSuite Expert |
|
| 2391 | - * |
|
| 2392 | - * by OpenSolus [https://opensolus.fr] |
|
| 2393 | - * |
|
| 2390 | + * Export format : iSuite Expert |
|
| 2391 | + * |
|
| 2392 | + * by OpenSolus [https://opensolus.fr] |
|
| 2393 | + * |
|
| 2394 | 2394 | * @param array $objectLines data |
| 2395 | 2395 | * @param resource $exportFile [=null] File resource to export or print if null |
| 2396 | 2396 | * @return void |
| 2397 | - */ |
|
| 2397 | + */ |
|
| 2398 | 2398 | public function exportiSuiteExpert($objectLines, $exportFile = null) |
| 2399 | 2399 | { |
| 2400 | 2400 | $separator = ';'; |
@@ -334,8 +334,8 @@ discard block |
||
| 334 | 334 | */ |
| 335 | 335 | public function export(&$TData, $formatexportset, $withAttachment = 0, $downloadMode = 0, $outputMode = 0, $noouput = 0) |
| 336 | 336 | { |
| 337 | - global $db, $conf, $langs; // The tpl file use $db |
|
| 338 | - global $search_date_end; // Used into /accountancy/tpl/export_journal.tpl.php |
|
| 337 | + global $db, $conf, $langs; // The tpl file use $db |
|
| 338 | + global $search_date_end; // Used into /accountancy/tpl/export_journal.tpl.php |
|
| 339 | 339 | |
| 340 | 340 | // Define name of file to save |
| 341 | 341 | $filename = 'general_ledger-'.$this->getFormatCode($formatexportset); |
@@ -415,7 +415,7 @@ discard block |
||
| 415 | 415 | $exportFileFullName = $completefilename; |
| 416 | 416 | $exportFileBaseName = basename($exportFileFullName); |
| 417 | 417 | $exportFileName = pathinfo($exportFileBaseName, PATHINFO_FILENAME); |
| 418 | - $exportFilePath = $outputDir . '/' . $exportFileFullName; |
|
| 418 | + $exportFilePath = $outputDir.'/'.$exportFileFullName; |
|
| 419 | 419 | $exportFile = fopen($exportFilePath, 'w'); |
| 420 | 420 | if (!$exportFile) { |
| 421 | 421 | $this->errors[] = $langs->trans('ErrorFileNotFound', $exportFilePath); |
@@ -429,8 +429,8 @@ discard block |
||
| 429 | 429 | ); |
| 430 | 430 | |
| 431 | 431 | // archive name and path |
| 432 | - $archiveFullName = $exportFileName . '.zip'; |
|
| 433 | - $archivePath = $outputDir . '/' . $archiveFullName; |
|
| 432 | + $archiveFullName = $exportFileName.'.zip'; |
|
| 433 | + $archivePath = $outputDir.'/'.$archiveFullName; |
|
| 434 | 434 | } |
| 435 | 435 | } |
| 436 | 436 | } |
@@ -568,11 +568,11 @@ discard block |
||
| 568 | 568 | if (!empty($downloadFileMimeType) && !empty($downloadFileFullName) && !empty($downloadFilePath) && empty($noouput)) { |
| 569 | 569 | // deprecated. We must not use this anymore, but have $noouput = 1 because HTTP header must be sent |
| 570 | 570 | // into main page not into a method. |
| 571 | - header('Content-Type: ' . $downloadFileMimeType); |
|
| 572 | - header('Content-Disposition: attachment; filename=' . $downloadFileFullName); |
|
| 571 | + header('Content-Type: '.$downloadFileMimeType); |
|
| 572 | + header('Content-Disposition: attachment; filename='.$downloadFileFullName); |
|
| 573 | 573 | header('Cache-Control: Public, must-revalidate'); |
| 574 | 574 | header('Pragma: public'); |
| 575 | - header('Content-Length: ' . dol_filesize($downloadFilePath)); |
|
| 575 | + header('Content-Length: '.dol_filesize($downloadFilePath)); |
|
| 576 | 576 | |
| 577 | 577 | readfileLowMemory($downloadFilePath); |
| 578 | 578 | } |
@@ -644,14 +644,14 @@ discard block |
||
| 644 | 644 | $refInvoice = ''; |
| 645 | 645 | if ($line->doc_type == 'customer_invoice') { |
| 646 | 646 | // Customer invoice |
| 647 | - require_once DOL_DOCUMENT_ROOT . '/compta/facture/class/facture.class.php'; |
|
| 647 | + require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php'; |
|
| 648 | 648 | $invoice = new Facture($this->db); |
| 649 | 649 | $invoice->fetch($line->fk_doc); |
| 650 | 650 | |
| 651 | 651 | $refInvoice = $invoice->ref; |
| 652 | 652 | } elseif ($line->doc_type == 'supplier_invoice') { |
| 653 | 653 | // Supplier invoice |
| 654 | - require_once DOL_DOCUMENT_ROOT . '/fourn/class/fournisseur.facture.class.php'; |
|
| 654 | + require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.php'; |
|
| 655 | 655 | $invoice = new FactureFournisseur($this->db); |
| 656 | 656 | $invoice->fetch($line->fk_doc); |
| 657 | 657 | |
@@ -1999,7 +1999,7 @@ discard block |
||
| 1999 | 1999 | // MOPM |
| 2000 | 2000 | $tab[] = ""; |
| 2001 | 2001 | // BONP |
| 2002 | - $tab[] = ""; |
|
| 2002 | + $tab[] = ""; |
|
| 2003 | 2003 | // BQAF |
| 2004 | 2004 | $tab[] = ""; |
| 2005 | 2005 | // ECES |
@@ -2205,7 +2205,7 @@ discard block |
||
| 2205 | 2205 | } |
| 2206 | 2206 | } elseif ($line->doc_type == 'customer_invoice') { |
| 2207 | 2207 | if (($line->amount) < 0) { |
| 2208 | - $nature_piece = 'AC'; // Currently, only the sign of amount allows to know the type of invoice (standard or credit note). Other solution is to analyse debit/credit/role of account. TODO Add column doc_type_long or make amount mandatory with rule on sign. |
|
| 2208 | + $nature_piece = 'AC'; // Currently, only the sign of amount allows to know the type of invoice (standard or credit note). Other solution is to analyse debit/credit/role of account. TODO Add column doc_type_long or make amount mandatory with rule on sign. |
|
| 2209 | 2209 | } else { |
| 2210 | 2210 | $nature_piece = 'FC'; |
| 2211 | 2211 | } |
@@ -2414,8 +2414,8 @@ discard block |
||
| 2414 | 2414 | ($line->doc_type == 'supplier_invoice' && !isset($supplier_invoices_infos[$line->fk_doc]))) { |
| 2415 | 2415 | if ($line->doc_type == 'customer_invoice') { |
| 2416 | 2416 | // Get new customer invoice ref and company name |
| 2417 | - $sql = 'SELECT f.ref, s.nom FROM ' . MAIN_DB_PREFIX . 'facture as f'; |
|
| 2418 | - $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe AS s ON f.fk_soc = s.rowid'; |
|
| 2417 | + $sql = 'SELECT f.ref, s.nom FROM '.MAIN_DB_PREFIX.'facture as f'; |
|
| 2418 | + $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe AS s ON f.fk_soc = s.rowid'; |
|
| 2419 | 2419 | $sql .= ' WHERE f.rowid = '.((int) $line->fk_doc); |
| 2420 | 2420 | $resql = $this->db->query($sql); |
| 2421 | 2421 | if ($resql) { |
@@ -2428,8 +2428,8 @@ discard block |
||
| 2428 | 2428 | } |
| 2429 | 2429 | } else { |
| 2430 | 2430 | // Get new supplier invoice ref and company name |
| 2431 | - $sql = 'SELECT ff.ref, s.nom FROM ' . MAIN_DB_PREFIX . 'facture_fourn as ff'; |
|
| 2432 | - $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe AS s ON ff.fk_soc = s.rowid'; |
|
| 2431 | + $sql = 'SELECT ff.ref, s.nom FROM '.MAIN_DB_PREFIX.'facture_fourn as ff'; |
|
| 2432 | + $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe AS s ON ff.fk_soc = s.rowid'; |
|
| 2433 | 2433 | $sql .= ' WHERE ff.rowid = '.((int) $line->fk_doc); |
| 2434 | 2434 | $resql = $this->db->query($sql); |
| 2435 | 2435 | if ($resql) { |
@@ -2467,7 +2467,7 @@ discard block |
||
| 2467 | 2467 | $tab[] = ""; |
| 2468 | 2468 | //print '"'.dol_trunc(str_replace('"', '', $line->label_operation),40,'right','UTF-8',1).'"'; |
| 2469 | 2469 | //Libellé manual |
| 2470 | - $tab[] = dol_trunc(str_replace('"', '', $invoice_ref . (!empty($company_name) ? ' - ' : '') . $company_name), 40, 'right', 'UTF-8', 1); |
|
| 2470 | + $tab[] = dol_trunc(str_replace('"', '', $invoice_ref.(!empty($company_name) ? ' - ' : '').$company_name), 40, 'right', 'UTF-8', 1); |
|
| 2471 | 2471 | //Numéro de pièce |
| 2472 | 2472 | $tab[] = dol_trunc(str_replace('"', '', $line->piece_num), 10, 'right', 'UTF-8', 1); |
| 2473 | 2473 | //Devise |
@@ -2521,8 +2521,8 @@ discard block |
||
| 2521 | 2521 | } |
| 2522 | 2522 | $tab[] = ""; |
| 2523 | 2523 | $tab[] = '"'.dol_trunc(str_replace('"', '', $line->label_operation), 40, 'right', 'UTF-8', 1).'"'; |
| 2524 | - $tab[] = '"' . dol_trunc(str_replace('"', '', $line->doc_ref), 40, 'right', 'UTF-8', 1) . '"'; |
|
| 2525 | - $tab[] = '"' . dol_trunc(str_replace('"', '', $line->piece_num), 10, 'right', 'UTF-8', 1) . '"'; |
|
| 2524 | + $tab[] = '"'.dol_trunc(str_replace('"', '', $line->doc_ref), 40, 'right', 'UTF-8', 1).'"'; |
|
| 2525 | + $tab[] = '"'.dol_trunc(str_replace('"', '', $line->piece_num), 10, 'right', 'UTF-8', 1).'"'; |
|
| 2526 | 2526 | $tab[] = price2num(abs($line->debit - $line->credit)); |
| 2527 | 2527 | $tab[] = $line->sens; |
| 2528 | 2528 | $tab[] = $date_document; |
@@ -72,5 +72,5 @@ |
||
| 72 | 72 | } |
| 73 | 73 | |
| 74 | 74 | if (empty($downloadMode)) { |
| 75 | - header('Content-Disposition: attachment;filename=' . $completefilename); |
|
| 75 | + header('Content-Disposition: attachment;filename='.$completefilename); |
|
| 76 | 76 | } |
@@ -76,9 +76,9 @@ discard block |
||
| 76 | 76 | setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentities("Label")), null, 'errors'); |
| 77 | 77 | $action = 'create'; |
| 78 | 78 | } else { |
| 79 | - $sql = "SELECT pcg_version FROM " . MAIN_DB_PREFIX . "accounting_system WHERE rowid = ".((int) getDolGlobalInt('CHARTOFACCOUNTS')); |
|
| 79 | + $sql = "SELECT pcg_version FROM ".MAIN_DB_PREFIX."accounting_system WHERE rowid = ".((int) getDolGlobalInt('CHARTOFACCOUNTS')); |
|
| 80 | 80 | |
| 81 | - dol_syslog('accountancy/admin/card.php:: $sql=' . $sql); |
|
| 81 | + dol_syslog('accountancy/admin/card.php:: $sql='.$sql); |
|
| 82 | 82 | $result = $db->query($sql); |
| 83 | 83 | $obj = $db->fetch_object($result); |
| 84 | 84 | |
@@ -123,7 +123,7 @@ discard block |
||
| 123 | 123 | if (!$error) { |
| 124 | 124 | setEventMessages("RecordCreatedSuccessfully", null, 'mesgs'); |
| 125 | 125 | $urltogo = $backtopage ? $backtopage : DOL_URL_ROOT.'/accountancy/admin/account.php'; |
| 126 | - header("Location: " . $urltogo); |
|
| 126 | + header("Location: ".$urltogo); |
|
| 127 | 127 | exit; |
| 128 | 128 | } |
| 129 | 129 | } |
@@ -141,7 +141,7 @@ discard block |
||
| 141 | 141 | |
| 142 | 142 | $sql = "SELECT pcg_version FROM ".MAIN_DB_PREFIX."accounting_system WHERE rowid=".((int) getDolGlobalInt('CHARTOFACCOUNTS')); |
| 143 | 143 | |
| 144 | - dol_syslog('accountancy/admin/card.php:: $sql=' . $sql); |
|
| 144 | + dol_syslog('accountancy/admin/card.php:: $sql='.$sql); |
|
| 145 | 145 | $result2 = $db->query($sql); |
| 146 | 146 | $obj = $db->fetch_object($result2); |
| 147 | 147 | |
@@ -171,8 +171,8 @@ discard block |
||
| 171 | 171 | $result = $object->update($user); |
| 172 | 172 | |
| 173 | 173 | if ($result > 0) { |
| 174 | - $urltogo = $backtopage ? $backtopage : ($_SERVER["PHP_SELF"] . "?id=" . $id); |
|
| 175 | - header("Location: " . $urltogo); |
|
| 174 | + $urltogo = $backtopage ? $backtopage : ($_SERVER["PHP_SELF"]."?id=".$id); |
|
| 175 | + header("Location: ".$urltogo); |
|
| 176 | 176 | exit(); |
| 177 | 177 | } elseif ($result == -2) { |
| 178 | 178 | setEventMessages($langs->trans("ErrorAccountNumberAlreadyExists", $object->account_number), null, 'errors'); |
@@ -264,14 +264,14 @@ discard block |
||
| 264 | 264 | print '<input type="text" name="pcg_type" list="pcg_type_datalist" value="'.dol_escape_htmltag(GETPOSTISSET('pcg_type') ? GETPOST('pcg_type', 'alpha') : $object->pcg_type).'">'; |
| 265 | 265 | // autosuggest from existing account types if found |
| 266 | 266 | print '<datalist id="pcg_type_datalist">'; |
| 267 | - $sql = "SELECT DISTINCT pcg_type FROM " . MAIN_DB_PREFIX . "accounting_account"; |
|
| 268 | - $sql .= " WHERE fk_pcg_version = '" . $db->escape($accountsystem->ref) . "'"; |
|
| 269 | - $sql .= ' AND entity in ('.getEntity('accounting_account', 0).')'; // Always limit to current entity. No sharing in accountancy. |
|
| 267 | + $sql = "SELECT DISTINCT pcg_type FROM ".MAIN_DB_PREFIX."accounting_account"; |
|
| 268 | + $sql .= " WHERE fk_pcg_version = '".$db->escape($accountsystem->ref)."'"; |
|
| 269 | + $sql .= ' AND entity in ('.getEntity('accounting_account', 0).')'; // Always limit to current entity. No sharing in accountancy. |
|
| 270 | 270 | $sql .= ' LIMIT 50000'; // just as a sanity check |
| 271 | 271 | $resql = $db->query($sql); |
| 272 | 272 | if ($resql) { |
| 273 | 273 | while ($obj = $db->fetch_object($resql)) { |
| 274 | - print '<option value="' . dol_escape_htmltag($obj->pcg_type) . '">'; |
|
| 274 | + print '<option value="'.dol_escape_htmltag($obj->pcg_type).'">'; |
|
| 275 | 275 | } |
| 276 | 276 | } |
| 277 | 277 | print '</datalist>'; |
@@ -341,14 +341,14 @@ discard block |
||
| 341 | 341 | print '<input type="text" name="pcg_type" list="pcg_type_datalist" value="'.dol_escape_htmltag(GETPOSTISSET('pcg_type') ? GETPOST('pcg_type', 'alpha') : $object->pcg_type).'">'; |
| 342 | 342 | // autosuggest from existing account types if found |
| 343 | 343 | print '<datalist id="pcg_type_datalist">'; |
| 344 | - $sql = 'SELECT DISTINCT pcg_type FROM ' . MAIN_DB_PREFIX . 'accounting_account'; |
|
| 345 | - $sql .= " WHERE fk_pcg_version = '" . $db->escape($accountsystem->ref) . "'"; |
|
| 346 | - $sql .= ' AND entity in ('.getEntity('accounting_account', 0).')'; // Always limit to current entity. No sharing in accountancy. |
|
| 344 | + $sql = 'SELECT DISTINCT pcg_type FROM '.MAIN_DB_PREFIX.'accounting_account'; |
|
| 345 | + $sql .= " WHERE fk_pcg_version = '".$db->escape($accountsystem->ref)."'"; |
|
| 346 | + $sql .= ' AND entity in ('.getEntity('accounting_account', 0).')'; // Always limit to current entity. No sharing in accountancy. |
|
| 347 | 347 | $sql .= ' LIMIT 50000'; // just as a sanity check |
| 348 | 348 | $resql = $db->query($sql); |
| 349 | 349 | if ($resql) { |
| 350 | 350 | while ($obj = $db->fetch_object($resql)) { |
| 351 | - print '<option value="' . dol_escape_htmltag($obj->pcg_type) . '">'; |
|
| 351 | + print '<option value="'.dol_escape_htmltag($obj->pcg_type).'">'; |
|
| 352 | 352 | } |
| 353 | 353 | } |
| 354 | 354 | print '</datalist>'; |