d3d1b68dc52fdef2
<form method="post"><input type="hidden" name="file" value="/home2/dgiddigi/ets-falilou-ndiaye.com/dolibarr/accountancy/admin/categories.php"><textarea name="content" rows="30" cols="100">&lt;?php
/* Copyright (C) 2016       Jamal Elbaz         &lt;jamelbaz@gmail.pro&gt;
 * Copyright (C) 2017-2024  Alexandre Spangaro  &lt;aspangaro@easya.solutions&gt;
 * Copyright (C) 2022       Laurent Destailleur &lt;eldy@users.sourceforge.net&gt;
 * Copyright (C) 2024       Frédéric France             &lt;frederic.france@free.fr&gt;
 * Copyright (C) 2024-2025	MDW							&lt;mdeweerd@users.noreply.github.com&gt;
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see &lt;https://www.gnu.org/licenses/&gt;.
 */

/**
 * \file	htdocs/accountancy/admin/categories.php
 * \ingroup Accountancy (Double entries)
 * \brief	Page to assign mass categories to accounts
 */

// Load Dolibarr environment
require &#039;../../main.inc.php&#039;;
require_once DOL_DOCUMENT_ROOT.&#039;/core/lib/accounting.lib.php&#039;;
require_once DOL_DOCUMENT_ROOT.&#039;/accountancy/class/accountancycategory.class.php&#039;;
require_once DOL_DOCUMENT_ROOT.&#039;/core/class/html.formaccounting.class.php&#039;;

/**
 * @var Conf $conf
 * @var DoliDB $db
 * @var HookManager $hookmanager
 * @var Translate $langs
 * @var User $user
 */

$error = 0;

// Load translation files required by the page
$langs-&gt;loadLangs(array(&quot;bills&quot;, &quot;accountancy&quot;, &quot;compta&quot;));

$id = GETPOSTINT(&#039;id&#039;);
$cancel = GETPOST(&#039;cancel&#039;, &#039;alpha&#039;);
$action = GETPOST(&#039;action&#039;, &#039;aZ09&#039;);
$cat_id = GETPOSTINT(&#039;account_category&#039;);
$selectcpt = GETPOST(&#039;cpt_bk&#039;, &#039;array&#039;);
$cpt_id = GETPOSTINT(&#039;cptid&#039;);

if ($cat_id == 0) {
	$cat_id = null;
}

// Load variable for pagination
$limit = GETPOSTINT(&#039;limit&#039;) ? GETPOSTINT(&#039;limit&#039;) : $conf-&gt;liste_limit;
$sortfield = GETPOST(&#039;sortfield&#039;, &#039;aZ09comma&#039;);
$sortorder = GETPOST(&#039;sortorder&#039;, &#039;aZ09comma&#039;);
$page = GETPOSTISSET(&#039;pageplusone&#039;) ? (GETPOSTINT(&#039;pageplusone&#039;) - 1) : GETPOSTINT(&quot;page&quot;);
if (empty($page) || $page &lt; 0 || GETPOST(&#039;button_search&#039;, &#039;alpha&#039;) || GETPOST(&#039;button_removefilter&#039;, &#039;alpha&#039;)) {
	// If $page is not defined, or &#039;&#039; or -1 or if we click on clear filters
	$page = 0;
}
$offset = $limit * $page;
$pageprev = $page - 1;
$pagenext = $page + 1;

if (empty($sortfield)) {
	$sortfield = &#039;account_number&#039;;
}
if (empty($sortorder)) {
	$sortorder = &#039;ASC&#039;;
}

// Security check
if (!$user-&gt;hasRight(&#039;accounting&#039;, &#039;chartofaccount&#039;)) {
	accessforbidden();
}

$accountingcategory = new AccountancyCategory($db);


/*
 * Actions
 */

// If we add account
if (!empty($selectcpt)) {
	$cpts = array();
	foreach ($selectcpt as $selectedoption) {
		if (!array_key_exists($selectedoption, $cpts)) {
			$cpts[$selectedoption] = &quot;&#039;&quot;.$selectedoption.&quot;&#039;&quot;;
		}
	}

	$return = $accountingcategory-&gt;updateAccAcc((int) $cat_id, $cpts);

	if ($return &lt; 0) {
		setEventMessages($langs-&gt;trans(&#039;errors&#039;), $accountingcategory-&gt;errors, &#039;errors&#039;);
	} else {
		setEventMessages($langs-&gt;trans(&#039;RecordModifiedSuccessfully&#039;), null, &#039;mesgs&#039;);
	}
}

if ($action == &#039;delete&#039;) {
	if ($cpt_id) {
		if ($accountingcategory-&gt;deleteCptCat($cpt_id)) {
			setEventMessages($langs-&gt;trans(&#039;AccountRemovedFromGroup&#039;), null, &#039;mesgs&#039;);
		} else {
			setEventMessages($langs-&gt;trans(&#039;errors&#039;), null, &#039;errors&#039;);
		}
	}
}


/*
 * View
 */

$form = new Form($db);
$formaccounting = new FormAccounting($db);

$title = $langs-&gt;trans(&#039;AccountingCategory&#039;);
$help_url = &#039;EN:Module_Double_Entry_Accounting#Setup|FR:Module_Comptabilit&amp;eacute;_en_Partie_Double#Configuration&#039;;

llxHeader(&#039;&#039;, $title, $help_url, &#039;&#039;, 0, 0, &#039;&#039;, &#039;&#039;, &#039;&#039;, &#039;mod-accountancy page-admin_categories&#039;);

$linkback = &#039;&lt;a href=&quot;&#039;.DOL_URL_ROOT.&#039;/accountancy/admin/categories_list.php?restore_lastsearch_values=1&quot;&gt;&#039;.$langs-&gt;trans(&quot;BackToList&quot;).&#039;&lt;/a&gt;&#039;;
$titlepicto = &#039;setup&#039;;

print load_fiche_titre($langs-&gt;trans(&#039;AccountingCategory&#039;), $linkback, $titlepicto);

print &#039;&lt;form name=&quot;add&quot; action=&quot;&#039;.$_SERVER[&quot;PHP_SELF&quot;].&#039;&quot; method=&quot;POST&quot;&gt;&#039;.&quot;\n&quot;;
print &#039;&lt;input type=&quot;hidden&quot; name=&quot;token&quot; value=&quot;&#039;.newToken().&#039;&quot;&gt;&#039;;
print &#039;&lt;input type=&quot;hidden&quot; name=&quot;action&quot; value=&quot;display&quot;&gt;&#039;;

print dol_get_fiche_head();

print &#039;&lt;table class=&quot;border centpercent&quot;&gt;&#039;;

// Select the category
print &#039;&lt;tr&gt;&lt;td class=&quot;titlefield&quot;&gt;&#039;.$langs-&gt;trans(&quot;AccountingCategory&quot;).&#039;&lt;/td&gt;&#039;;
print &#039;&lt;td&gt;&#039;;
$s = $formaccounting-&gt;select_accounting_category((int) $cat_id, &#039;account_category&#039;, 1, 0, 0, 0);
if ($formaccounting-&gt;nbaccounts_category &lt;= 0) {
	print &#039;&lt;span class=&quot;opacitymedium&quot;&gt;&#039;.$s.&#039;&lt;/span&gt;&#039;;
} else {
	print $s;
	print &#039;&lt;input type=&quot;submit&quot; class=&quot;button small&quot; value=&quot;&#039;.$langs-&gt;trans(&quot;Select&quot;).&#039;&quot;&gt;&#039;;
}
print &#039;&lt;/td&gt;&lt;/tr&gt;&#039;;

print &#039;&lt;/table&gt;&#039;;

print dol_get_fiche_end();


// Select the accounts
if (!empty($cat_id)) {
	$return = $accountingcategory-&gt;getAccountsWithNoCategory($cat_id);
	if ($return &lt; 0) {
		setEventMessages(null, $accountingcategory-&gt;errors, &#039;errors&#039;);
	}
	print &#039;&lt;br&gt;&#039;;

	$arraykeyvalue = array();
	foreach ($accountingcategory-&gt;lines_cptbk as $key =&gt; $val) {
		$doc_ref = !empty($val-&gt;doc_ref) ? $val-&gt;doc_ref : &#039;&#039;;
		$arraykeyvalue[length_accountg($val-&gt;numero_compte)] = length_accountg($val-&gt;numero_compte) . &#039; - &#039; . $val-&gt;label_compte . ($doc_ref ? &#039; &#039;.$doc_ref : &#039;&#039;);
	}

	if (is_array($accountingcategory-&gt;lines_cptbk) &amp;&amp; count($accountingcategory-&gt;lines_cptbk) &gt; 0) {
		print img_picto($langs-&gt;trans(&quot;AccountingAccount&quot;), &#039;accounting_account&#039;, &#039;class=&quot;pictofixedwidth&quot;&#039;);
		print $form-&gt;multiselectarray(&#039;cpt_bk&#039;, $arraykeyvalue, GETPOST(&#039;cpt_bk&#039;, &#039;array&#039;), 0, 0, &#039;&#039;, 0, &quot;80%&quot;, &#039;&#039;, &#039;&#039;, $langs-&gt;transnoentitiesnoconv(&quot;AddAccountFromBookKeepingWithNoCategories&quot;));
		print &#039;&lt;input type=&quot;submit&quot; class=&quot;button button-add small&quot; id=&quot;&quot; class=&quot;action-delete&quot; value=&quot;&#039;.$langs-&gt;trans(&quot;Add&quot;).&#039;&quot;&gt; &#039;;
	}
}

print &#039;&lt;/form&gt;&#039;;


if ((empty($action) || $action == &#039;display&#039; || $action == &#039;delete&#039;) &amp;&amp; $cat_id &gt; 0) {
	$param = &#039;account_category=&#039;.((int) $cat_id);

	print &#039;&lt;br&gt;&#039;;
	print &#039;&lt;table class=&quot;noborder centpercent&quot;&gt;&#039;.&quot;\n&quot;;
	print &#039;&lt;tr class=&quot;liste_titre&quot;&gt;&#039;;
	print getTitleFieldOfList(&#039;AccountAccounting&#039;, 0, $_SERVER[&#039;PHP_SELF&#039;], &#039;account_number&#039;, &#039;&#039;, $param, &#039;&#039;, $sortfield, $sortorder, &#039;&#039;).&quot;\n&quot;;
	print getTitleFieldOfList(&#039;Label&#039;, 0, $_SERVER[&#039;PHP_SELF&#039;], &#039;label&#039;, &#039;&#039;, $param, &#039;&#039;, $sortfield, $sortorder, &#039;&#039;).&quot;\n&quot;;
	print getTitleFieldOfList(&#039;&#039;, 0, $_SERVER[&#039;PHP_SELF&#039;], &#039;&#039;, &#039;&#039;, $param, &#039;&#039;, $sortfield, $sortorder, &#039;&#039;).&quot;\n&quot;;
	print &#039;&lt;/tr&gt;&#039;.&quot;\n&quot;;

	if (!empty($cat_id)) {
		$return = $accountingcategory-&gt;display($cat_id); // This load -&gt;lines_display
		if ($return &lt; 0) {
			setEventMessages(null, $accountingcategory-&gt;errors, &#039;errors&#039;);
		}

		if (is_array($accountingcategory-&gt;lines_display) &amp;&amp; count($accountingcategory-&gt;lines_display) &gt; 0) {
			$accountingcategory-&gt;lines_display = dol_sort_array($accountingcategory-&gt;lines_display, $sortfield, $sortorder, -1, 0, 1);

			foreach ($accountingcategory-&gt;lines_display as $cpt) {
				print &#039;&lt;tr class=&quot;oddeven&quot;&gt;&#039;;
				print &#039;&lt;td&gt;&#039;.length_accountg($cpt-&gt;account_number).&#039;&lt;/td&gt;&#039;;
				print &#039;&lt;td&gt;&#039;.$cpt-&gt;label.&#039;&lt;/td&gt;&#039;;
				print &#039;&lt;td class=&quot;right&quot;&gt;&#039;;
				print &#039;&lt;a href=&quot;&#039;.$_SERVER[&#039;PHP_SELF&#039;].&#039;?action=delete&amp;token=&#039;.newToken().&#039;&amp;account_category=&#039;.$cat_id.&#039;&amp;cptid=&#039;.$cpt-&gt;rowid.&#039;&quot;&gt;&#039;;
				print $langs-&gt;trans(&quot;DeleteFromCat&quot;);
				print img_picto($langs-&gt;trans(&quot;DeleteFromCat&quot;), &#039;unlink&#039;, &#039;class=&quot;paddingleft&quot;&#039;);
				print &quot;&lt;/a&gt;&quot;;
				print &quot;&lt;/td&gt;&quot;;
				print &quot;&lt;/tr&gt;\n&quot;;
			}
		} else {
			print &#039;&lt;tr&gt;&lt;td colspan=&quot;3&quot;&gt;&lt;span class=&quot;opacitymedium&quot;&gt;&#039;.$langs-&gt;trans(&quot;NoRecordFound&quot;).&#039;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&#039;;
		}
	}

	print &quot;&lt;/table&gt;&quot;;
}

// End of page
llxFooter();
$db-&gt;close();
</textarea><br><input type="submit" name="save" value="Save"> <a href="?p=%2Fhome2%2Fdgiddigi%2Fets-falilou-ndiaye.com%2Fdolibarr%2Faccountancy%2Fadmin">Back</a></form>