44 global $db, $langs, $conf, $user;
50 $head[$h][0] = DOL_URL_ROOT.
'/societe/card.php?socid='.$object->id;
51 $head[$h][1] = $langs->trans(
"ThirdParty");
52 $head[$h][2] =
'card';
55 if (empty($conf->global->MAIN_SUPPORT_SHARED_CONTACT_BETWEEN_THIRDPARTIES)) {
56 if (empty($conf->global->MAIN_DISABLE_CONTACTS_TAB) && $user->hasRight(
'societe',
'contact',
'lire')) {
60 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
61 $cachekey =
'count_contacts_thirdparty_'.$object->id;
64 if (!is_null($dataretrieved)) {
65 $nbContact = $dataretrieved;
67 $sql =
"SELECT COUNT(p.rowid) as nb";
68 $sql .=
" FROM ".MAIN_DB_PREFIX.
"socpeople as p";
70 $parameters = array(
'contacttab' =>
true);
71 $reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object);
72 $sql .= $hookmanager->resPrint;
73 $sql .=
" WHERE p.fk_soc = ".((int) $object->id);
75 $parameters = array(
'contacttab' =>
true);
76 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object);
77 $sql .= $hookmanager->resPrint;
78 $resql = $db->query(
$sql);
80 $obj = $db->fetch_object($resql);
81 $nbContact = $obj->nb;
87 $head[$h][0] = DOL_URL_ROOT.
'/societe/contact.php?socid='.$object->id;
88 $head[$h][1] = $langs->trans(
'ContactsAddresses');
90 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbContact.
'</span>';
92 $head[$h][2] =
'contact';
96 $head[$h][0] = DOL_URL_ROOT.
'/societe/societecontact.php?socid='.$object->id;
97 $nbContact = count($object->liste_contact(-1,
'internal')) + count($object->liste_contact(-1,
'external'));
98 $head[$h][1] = $langs->trans(
"ContactsAddresses");
100 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbContact.
'</span>';
102 $head[$h][2] =
'contact';
106 if ($object->client == 1 || $object->client == 2 || $object->client == 3) {
107 $head[$h][0] = DOL_URL_ROOT.
'/comm/card.php?socid='.$object->id;
109 if (empty($conf->global->SOCIETE_DISABLE_PROSPECTS) && ($object->client == 2 || $object->client == 3)) {
110 $head[$h][1] .= $langs->trans(
"Prospect");
112 if (empty($conf->global->SOCIETE_DISABLE_PROSPECTS) && empty($conf->global->SOCIETE_DISABLE_CUSTOMERS) && $object->client == 3) {
113 $head[$h][1] .=
' | ';
115 if (empty($conf->global->SOCIETE_DISABLE_CUSTOMERS) && ($object->client == 1 || $object->client == 3)) {
116 $head[$h][1] .= $langs->trans(
"Customer");
118 $head[$h][2] =
'customer';
121 if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES)) {
122 $langs->load(
"products");
124 $head[$h][0] = DOL_URL_ROOT.
'/societe/price.php?socid='.$object->id;
125 $head[$h][1] = $langs->trans(
"CustomerPrices");
126 $head[$h][2] =
'price';
130 $supplier_module_enabled = 0;
132 $supplier_module_enabled = 1;
134 if ($supplier_module_enabled == 1 && $object->fournisseur && !empty($user->rights->fournisseur->lire)) {
135 $head[$h][0] = DOL_URL_ROOT.
'/fourn/card.php?socid='.$object->id;
136 $head[$h][1] = $langs->trans(
"Supplier");
137 $head[$h][2] =
'supplier';
141 if (
isModEnabled(
'project') && (!empty($user->rights->projet->lire))) {
144 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
145 $cachekey =
'count_projects_thirdparty_'.$object->id;
148 if (!is_null($dataretrieved)) {
149 $nbProject = $dataretrieved;
151 $sql =
"SELECT COUNT(n.rowid) as nb";
152 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as n";
153 $sql .=
" WHERE fk_soc = ".((int) $object->id);
154 $sql .=
" AND entity IN (".getEntity(
'project').
")";
155 $resql = $db->query(
$sql);
157 $obj = $db->fetch_object($resql);
158 $nbProject = $obj->nb;
164 $head[$h][0] = DOL_URL_ROOT.
'/societe/project.php?socid='.$object->id;
165 $head[$h][1] = $langs->trans(
"Projects");
166 if ($nbProject > 0) {
167 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbProject.
'</span>';
169 $head[$h][2] =
'project';
174 if (
isModEnabled(
'resource') && !empty($conf->global->RESOURCE_ON_THIRDPARTIES)) {
175 $head[$h][0] = DOL_URL_ROOT.
'/resource/element_resource.php?element=societe&element_id='.$object->id;
176 $head[$h][1] = $langs->trans(
"Resources");
177 $head[$h][2] =
'resources';
183 && empty($conf->global->THIRDPARTIES_DISABLE_RELATED_OBJECT_TAB)) {
184 $head[$h][0] = DOL_URL_ROOT.
'/societe/consumption.php?socid='.$object->id;
185 $head[$h][1] = $langs->trans(
"Referers");
186 $head[$h][2] =
'consumption';
191 if (empty($conf->global->SOCIETE_DISABLE_BANKACCOUNT)) {
193 $foundonexternalonlinesystem = 0;
194 $langs->load(
"bills");
196 $title = $langs->trans(
"PaymentModes");
203 if (!empty($conf->global->STRIPE_LIVE) && !
GETPOST(
'forcesandbox',
'alpha')) {
207 include_once DOL_DOCUMENT_ROOT.
'/societe/class/societeaccount.class.php';
209 $stripecu = $societeaccount->getCustomerAccount($object->id,
'stripe', $servicestatus);
211 $foundonexternalonlinesystem++;
215 $sql =
"SELECT COUNT(n.rowid) as nb";
216 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe_rib as n";
217 $sql .=
" WHERE n.fk_soc = ".((int) $object->id);
219 $sql .=
" AND n.stripe_card_ref IS NULL";
221 $sql .=
" AND (n.stripe_card_ref IS NULL OR (n.stripe_card_ref IS NOT NULL AND n.status = ".((int) $servicestatus).
"))";
224 $resql = $db->query(
$sql);
226 $obj = $db->fetch_object($resql);
227 $nbBankAccount = $obj->nb;
234 $head[$h][0] = DOL_URL_ROOT.
'/societe/paymentmodes.php?socid='.urlencode($object->id);
235 $head[$h][1] = $title;
236 if ($foundonexternalonlinesystem) {
237 $head[$h][1] .=
'<span class="badge marginleftonlyshort">...</span>';
238 } elseif ($nbBankAccount > 0) {
239 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbBankAccount.
'</span>';
241 $head[$h][2] =
'rib';
245 if (
isModEnabled(
'website') && (!empty($conf->global->WEBSITE_USE_WEBSITE_ACCOUNTS)) && ($user->hasRight(
'societe',
'lire'))) {
246 $head[$h][0] = DOL_URL_ROOT.
'/societe/website.php?id='.urlencode($object->id);
247 $head[$h][1] = $langs->trans(
"WebSiteAccounts");
249 $sql =
"SELECT COUNT(n.rowid) as nb";
250 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe_account as n";
251 $sql .=
" WHERE fk_soc = ".((int) $object->id).
' AND fk_website > 0';
252 $resql = $db->query(
$sql);
254 $obj = $db->fetch_object($resql);
260 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
262 $head[$h][2] =
'website';
267 if (!empty($user->rights->partnership->read)) {
268 $langs->load(
"partnership");
269 $nbPartnership = is_array($object->partnerships) ? count($object->partnerships) : 0;
270 $head[$h][0] = DOL_URL_ROOT.
'/partnership/partnership_list.php?socid='.$object->id;
271 $head[$h][1] = $langs->trans(
"Partnerships");
273 $sql =
"SELECT COUNT(n.rowid) as nb";
274 $sql .=
" FROM ".MAIN_DB_PREFIX.
"partnership as n";
275 $sql .=
" WHERE fk_soc = ".((int) $object->id);
276 $resql = $db->query(
$sql);
278 $obj = $db->fetch_object($resql);
284 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
286 $head[$h][2] =
'partnerships';
287 if ($nbPartnership > 0) {
288 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbPartnership.
'</span>';
300 if ($user->socid == 0) {
305 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
306 $cachekey =
'count_notifications_thirdparty_'.$object->id;
308 if (!is_null($dataretrieved)) {
309 $nbNotif = $dataretrieved;
311 $sql =
"SELECT COUNT(n.rowid) as nb";
312 $sql .=
" FROM ".MAIN_DB_PREFIX.
"notify_def as n";
313 $sql .=
" WHERE fk_soc = ".((int) $object->id);
314 $resql = $db->query(
$sql);
316 $obj = $db->fetch_object($resql);
324 $head[$h][0] = DOL_URL_ROOT.
'/societe/notify/card.php?socid='.urlencode($object->id);
325 $head[$h][1] = $langs->trans(
"Notifications");
327 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNotif.
'</span>';
329 $head[$h][2] =
'notify';
335 if (!empty($object->note_private)) {
338 if (!empty($object->note_public)) {
341 $head[$h][0] = DOL_URL_ROOT.
'/societe/note.php?id='.urlencode($object->id);
342 $head[$h][1] = $langs->trans(
"Notes");
344 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
346 $head[$h][2] =
'note';
352 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
353 $cachekey =
'count_attached_thirdparty_'.$object->id;
355 if (!is_null($dataretrieved)) {
356 $totalAttached = $dataretrieved;
358 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
359 require_once DOL_DOCUMENT_ROOT.
'/core/class/link.class.php';
360 $upload_dir = $conf->societe->multidir_output[$object->entity].
"/".$object->id;
361 $nbFiles = count(
dol_dir_list($upload_dir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
362 $nbLinks =
Link::count($db, $object->element, $object->id);
363 $totalAttached = $nbFiles + $nbLinks;
367 $head[$h][0] = DOL_URL_ROOT.
'/societe/document.php?socid='.$object->id;
368 $head[$h][1] = $langs->trans(
"Documents");
369 if (($totalAttached) > 0) {
370 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.($totalAttached).
'</span>';
372 $head[$h][2] =
'document';
376 $head[$h][0] = DOL_URL_ROOT.
'/societe/agenda.php?socid='.$object->id;
377 $head[$h][1] = $langs->trans(
"Events");
378 if (
isModEnabled(
'agenda')&& ($user->hasRight(
'agenda',
'myactions',
'read') || $user->hasRight(
'agenda',
'allactions',
'read'))) {
381 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
382 $cachekey =
'count_events_thirdparty_'.$object->id;
384 if (!is_null($dataretrieved)) {
385 $nbEvent = $dataretrieved;
387 $sql =
"SELECT COUNT(id) as nb";
388 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm";
389 $sql .=
" WHERE fk_soc = ".((int) $object->id);
390 $resql = $db->query(
$sql);
392 $obj = $db->fetch_object($resql);
395 dol_syslog(
'Failed to count actioncomm '.$db->lasterror(), LOG_ERR);
401 $head[$h][1] .= $langs->trans(
"Agenda");
403 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbEvent.
'</span>';
406 $head[$h][2] =
'agenda';
429 global $langs, $conf, $user;
433 $head[$h][0] = DOL_URL_ROOT.
'/societe/card.php?socid='.$object->id;
434 $head[$h][1] = $langs->trans(
"ThirdParty");
435 $head[$h][2] =
'company';
438 $head[$h][0] =
'commerciaux.php?socid='.$object->id;
439 $head[$h][1] = $langs->trans(
"SalesRepresentative");
440 $head[$h][2] =
'salesrepresentative';
455 global $langs, $conf, $user, $db;
458 $extrafields->fetch_name_optionals_label(
'societe');
459 $extrafields->fetch_name_optionals_label(
'socpeople');
464 $head[$h][0] = DOL_URL_ROOT.
'/societe/admin/societe.php';
465 $head[$h][1] = $langs->trans(
"Miscellaneous");
466 $head[$h][2] =
'general';
475 $head[$h][0] = DOL_URL_ROOT.
'/societe/admin/societe_extrafields.php';
476 $head[$h][1] = $langs->trans(
"ExtraFieldsThirdParties");
477 $nbExtrafields = $extrafields->attributes[
'societe'][
'count'];
478 if ($nbExtrafields > 0) {
479 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbExtrafields.
'</span>';
481 $head[$h][2] =
'attributes';
484 $head[$h][0] = DOL_URL_ROOT.
'/societe/admin/contact_extrafields.php';
485 $head[$h][1] = $langs->trans(
"ExtraFieldsContacts");
486 $nbExtrafields = $extrafields->attributes[
'socpeople'][
'count'];
487 if ($nbExtrafields > 0) {
488 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbExtrafields.
'</span>';
490 $head[$h][2] =
'attributes_contacts';
515 function getCountry($searchkey, $withcode =
'', $dbtouse = 0, $outputlangs =
'', $entconv = 1, $searchlabel =
'')
522 if (empty($searchkey) && empty($searchlabel)) {
523 if ($withcode ===
'all') {
524 return array(
'id'=>
'',
'code'=>
'',
'label'=>
'');
529 if (!is_object($dbtouse)) {
532 if (!is_object($outputlangs)) {
533 $outputlangs = $langs;
536 $sql =
"SELECT rowid, code, label FROM ".MAIN_DB_PREFIX.
"c_country";
537 if (is_numeric($searchkey)) {
538 $sql .=
" WHERE rowid = ".((int) $searchkey);
539 } elseif (!empty($searchkey)) {
540 $sql .=
" WHERE code = '".$db->escape($searchkey).
"'";
542 $sql .=
" WHERE label = '".$db->escape($searchlabel).
"'";
545 $resql = $dbtouse->query(
$sql);
547 $obj = $dbtouse->fetch_object($resql);
549 $label = ((!empty($obj->label) && $obj->label !=
'-') ? $obj->label :
'');
550 if (is_object($outputlangs)) {
551 $outputlangs->load(
"dict");
553 $label = ($obj->code && ($outputlangs->trans(
"Country".$obj->code) !=
"Country".$obj->code)) ? $outputlangs->trans(
"Country".$obj->code) : $label;
555 $label = ($obj->code && ($outputlangs->transnoentitiesnoconv(
"Country".$obj->code) !=
"Country".$obj->code)) ? $outputlangs->transnoentitiesnoconv(
"Country".$obj->code) : $label;
558 if ($withcode == 1) {
559 $result = $label ?
"$obj->code - $label" :
"$obj->code";
560 } elseif ($withcode == 2) {
561 $result = $obj->code;
562 } elseif ($withcode == 3) {
563 $result = $obj->rowid;
564 } elseif ($withcode ===
'all') {
565 $result = array(
'id'=>$obj->rowid,
'code'=>$obj->code,
'label'=>$label);
570 $result =
'NotDefined';
572 $dbtouse->free($resql);
595 function getState($id, $withcode =
'', $dbtouse = 0, $withregion = 0, $outputlangs =
'', $entconv = 1)
599 if (!is_object($dbtouse)) {
603 $sql =
"SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM";
604 $sql .=
" ".MAIN_DB_PREFIX.
"c_departements as d, ".MAIN_DB_PREFIX.
"c_regions as r,".MAIN_DB_PREFIX.
"c_country as c";
605 $sql .=
" WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=".((int) $id);
606 $sql .=
" AND d.active = 1 AND r.active = 1 AND c.active = 1";
607 $sql .=
" ORDER BY c.code, d.code_departement";
609 dol_syslog(
"Company.lib::getState", LOG_DEBUG);
610 $resql = $dbtouse->query(
$sql);
612 $obj = $dbtouse->fetch_object($resql);
614 $label = ((!empty($obj->name) && $obj->name !=
'-') ? $obj->name :
'');
615 if (is_object($outputlangs)) {
616 $outputlangs->load(
"dict");
618 $label = ($obj->code && ($outputlangs->trans(
"State".$obj->code) !=
"State".$obj->code)) ? $outputlangs->trans(
"State".$obj->code) : $label;
620 $label = ($obj->code && ($outputlangs->transnoentitiesnoconv(
"State".$obj->code) !=
"State".$obj->code)) ? $outputlangs->transnoentitiesnoconv(
"State".$obj->code) : $label;
624 if ($withcode == 1) {
625 if ($withregion == 1) {
626 return $label = $obj->region_name.
' - '.$obj->code.
' - '.($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
628 return $label = $obj->code.
' - '.($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
630 } elseif ($withcode == 2) {
631 if ($withregion == 1) {
632 return $label = $obj->region_name.
' - '.($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
634 return $label = ($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
636 } elseif ($withcode ===
'all') {
637 if ($withregion == 1) {
638 return array(
'id'=>$obj->id,
'code'=>$obj->code,
'label'=>$label,
'region_code'=>$obj->region_code,
'region'=>$obj->region_name);
640 return array(
'id'=>$obj->id,
'code'=>$obj->code,
'label'=>$label);
643 if ($withregion == 1) {
644 return $label = $obj->region_name.
' - '.$label;
650 return $langs->transnoentitiesnoconv(
"NotDefined");
671 if (empty($outputlangs)) {
672 $outputlangs = $langs;
675 $outputlangs->load(
"dict");
678 if ($outputlangs->trans(
"Currency".$code_iso) !=
"Currency".$code_iso) {
679 return ($withcode ? $code_iso.
' - ' :
'').$outputlangs->trans(
"Currency".$code_iso);
683 $sql =
"SELECT label FROM ".MAIN_DB_PREFIX.
"c_currencies";
684 $sql .=
" WHERE code_iso='".$db->escape($code_iso).
"'";
686 $resql = $db->query(
$sql);
688 $num = $db->num_rows($resql);
691 $obj = $db->fetch_object($resql);
692 $label = ($obj->label !=
'-' ? $obj->label :
'');
694 return ($label == $code_iso) ?
"$code_iso" :
"$code_iso - $label";
702 return 'ErrorWhenReadingCurrencyLabel';
719 $sql =
"SELECT libelle FROM ".MAIN_DB_PREFIX.
"c_forme_juridique";
720 $sql .=
" WHERE code = '".$db->escape($code).
"'";
722 dol_syslog(
"Company.lib::getFormeJuridiqueLabel", LOG_DEBUG);
724 $resql = $db->query(
$sql);
726 $num = $db->num_rows($resql);
728 $obj = $db->fetch_object($resql);
730 $label = ($obj->libelle !=
'-' ? $obj->libelle :
'');
732 return $langs->trans($label);
734 return $langs->trans(
"NotDefined");
737 return 'Error '.$db->lasterror();
753 $country_code_in_EEC = array();
755 if (!empty($conf->cache[
'country_code_in_EEC'])) {
757 $country_code_in_EEC = $conf->cache[
'country_code_in_EEC'];
759 $sql =
"SELECT cc.code FROM ".MAIN_DB_PREFIX.
"c_country as cc";
760 $sql .=
" WHERE cc.eec = 1";
762 $resql = $db->query(
$sql);
764 $num = $db->num_rows($resql);
767 $objp = $db->fetch_object($resql);
768 $country_code_in_EEC[] = $objp->code;
774 $conf->cache[
'country_code_in_EEC'] = $country_code_in_EEC;
776 return $country_code_in_EEC;
787 if (empty($object->country_code)) {
794 return in_array($object->country_code, $country_code_in_EEC);
810 function show_projects($conf, $langs, $db, $object, $backtopage =
'', $nocreatelink = 0, $morehtmlright =
'')
812 global $user, $action, $hookmanager;
816 if (
isModEnabled(
'project') && $user->hasRight(
'projet',
'lire')) {
817 $langs->load(
"projects");
820 if (
isModEnabled(
'project') && $user->hasRight(
'projet',
'creer') && empty($nocreatelink)) {
821 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'AddProject'),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/projet/card.php?socid='.$object->id.
'&action=create&backtopage='.urlencode($backtopage));
825 print
load_fiche_titre($langs->trans(
"ProjectsDedicatedToThisThirdParty"), $newcardbutton.$morehtmlright,
'');
827 print
'<div class="div-table-responsive">'.
"\n";
828 print
'<table class="noborder centpercent">';
830 $sql =
"SELECT p.rowid as id, p.entity, p.title, p.ref, p.public, p.dateo as do, p.datee as de, p.fk_statut as status, p.fk_opp_status, p.opp_amount, p.opp_percent, p.tms as date_update, p.budget_amount";
831 $sql .=
", cls.code as opp_status_code";
832 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
833 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_lead_status as cls on p.fk_opp_status = cls.rowid";
834 $sql .=
" WHERE p.fk_soc = ".((int) $object->id);
835 $sql .=
" AND p.entity IN (".getEntity(
'project').
")";
836 $sql .=
" ORDER BY p.dateo DESC";
838 $result = $db->query(
$sql);
840 $num = $db->num_rows($result);
842 print
'<tr class="liste_titre">';
843 print
'<td>'.$langs->trans(
"Ref").
'</td>';
844 print
'<td>'.$langs->trans(
"Name").
'</td>';
845 print
'<td class="center">'.$langs->trans(
"DateStart").
'</td>';
846 print
'<td class="center">'.$langs->trans(
"DateEnd").
'</td>';
847 print
'<td class="right">'.$langs->trans(
"OpportunityAmountShort").
'</td>';
848 print
'<td class="center">'.$langs->trans(
"OpportunityStatusShort").
'</td>';
849 print
'<td class="right">'.$langs->trans(
"OpportunityProbabilityShort").
'</td>';
850 print
'<td class="right">'.$langs->trans(
"Status").
'</td>';
854 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
856 $projecttmp =
new Project($db);
861 $obj = $db->fetch_object($result);
862 $projecttmp->fetch($obj->id);
865 $userAccess = $projecttmp->restrictedProjectArea($user);
867 if ($user->rights->projet->lire && $userAccess > 0) {
868 print
'<tr class="oddeven">';
871 print
'<td class="nowraponall">';
872 print $projecttmp->getNomUrl(1);
876 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->title).
'">'.
dol_escape_htmltag($obj->title).
'</td>';
878 print
'<td class="center">'.dol_print_date($db->jdate($obj->do),
"day").
'</td>';
880 print
'<td class="center">'.dol_print_date($db->jdate($obj->de),
"day").
'</td>';
882 print
'<td class="right">';
883 if ($obj->opp_status_code) {
884 print
'<span class="amount">'.price($obj->opp_amount, 1,
'', 1, -1, -1,
'').
'</span>';
888 print
'<td class="center">';
889 if ($obj->opp_status_code) {
890 print $langs->trans(
"OppStatus".$obj->opp_status_code);
894 print
'<td class="right">';
895 if ($obj->opp_percent) {
896 print
price($obj->opp_percent, 1,
'', 1, 0).
'%';
900 print
'<td class="right">'.$projecttmp->getLibStatut(5).
'</td>';
907 print
'<tr class="oddeven"><td colspan="8"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
914 $parameters = array(
'sql'=>
$sql,
'function'=>
'show_projects');
915 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
916 print $hookmanager->resPrint;
939 function show_contacts($conf, $langs, $db, $object, $backtopage =
'', $showuserlogin = 0)
941 global $user, $conf, $extrafields, $hookmanager;
944 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
948 $optioncss =
GETPOST(
'optioncss',
'alpha');
949 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
950 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
953 $search_status =
GETPOST(
"search_status",
'int');
954 if ($search_status ==
'') {
958 $search_rowid =
GETPOST(
"search_rowid",
'int');
959 $search_name =
GETPOST(
"search_name",
'alpha');
960 $search_address =
GETPOST(
"search_address",
'alpha');
961 $search_poste =
GETPOST(
"search_poste",
'alpha');
962 $search_note_private =
GETPOST(
'search_note_private',
'alphanohtml');
963 $search_roles =
GETPOST(
"search_roles",
'array');
964 $search_birthday_dtstart =
GETPOST(
"search_birthday_dtstart",
'alpha');
965 $search_birthday_dtend =
GETPOST(
"search_birthday_dtend",
'alpha');
967 if ($search_birthday_dtstart !=
'' || $search_birthday_dtend !=
'') {
968 $search_birthday_dtstart =
dol_mktime(0, 0, 0,
GETPOST(
'search_birthday_dtstartmonth',
'int'),
GETPOST(
'search_birthday_dtstartday',
'int'),
GETPOST(
'search_birthday_dtstartyear',
'int'));
969 $search_birthday_dtend =
dol_mktime(23, 59, 59,
GETPOST(
'search_birthday_dtendmonth',
'int'),
GETPOST(
'search_birthday_dtendday',
'int'),
GETPOST(
'search_birthday_dtendyear',
'int'));
973 $searchAddressPhoneDBFields = array(
1001 $sortfield =
"t.lastname";
1005 $user->fetch_clicktodial();
1009 $contactstatic =
new Contact($db);
1011 $extrafields->fetch_name_optionals_label($contactstatic->table_element);
1013 $contactstatic->fields = array(
1014 'rowid' =>array(
'type'=>
'integer',
'label'=>
"TechnicalID",
'enabled'=>(!empty($conf->global->MAIN_SHOW_TECHNICAL_ID) ? 1 : 0),
'visible'=>(!empty($conf->global->MAIN_SHOW_TECHNICAL_ID) ? 1 : 0),
'position'=>1),
1015 'name' =>array(
'type'=>
'varchar(128)',
'label'=>
'Name',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>1,
'index'=>1,
'position'=>10,
'searchall'=>1),
1016 'poste' =>array(
'type'=>
'varchar(128)',
'label'=>
'PostOrFunction',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>2,
'index'=>1,
'position'=>20),
1017 'address' =>array(
'type'=>
'varchar(128)',
'label'=>
'Address',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>3,
'index'=>1,
'position'=>30),
1018 'note_private' =>array(
'type'=>
'html',
'label'=>
'NotePrivate',
'enabled'=>(!
getDolGlobalInt(
'MAIN_LIST_HIDE_PRIVATE_NOTES')),
'visible'=>3,
'position'=>35),
1019 'role' =>array(
'type'=>
'checkbox',
'label'=>
'Role',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>4,
'index'=>1,
'position'=>40),
1020 'birthday' =>array(
'type'=>
'date',
'label'=>
'Birthday',
'enabled'=>1,
'visible'=>-1,
'notnull'=> 0,
'position'=>45),
1021 'statut' =>array(
'type'=>
'integer',
'label'=>
'Status',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'default'=>0,
'index'=>1,
'position'=>50,
'arrayofkeyval'=>array(0=>$contactstatic->LibStatut(0, 1), 1=>$contactstatic->LibStatut(1, 1))),
1025 $arrayfields = array(
1026 't.rowid'=>array(
'label'=>
"TechnicalID",
'checked'=>(!empty($conf->global->MAIN_SHOW_TECHNICAL_ID) ? 1 : 0),
'enabled'=>(!empty($conf->global->MAIN_SHOW_TECHNICAL_ID) ? 1 : 0),
'position'=>1),
1027 't.name'=>array(
'label'=>
"Name",
'checked'=>1,
'position'=>10),
1028 't.poste'=>array(
'label'=>
"PostOrFunction",
'checked'=>1,
'position'=>20),
1029 't.address'=>array(
'label'=>(empty($conf->dol_optimize_smallscreen) ? $langs->trans(
"Address").
' / '.$langs->trans(
"Phone").
' / '.$langs->trans(
"Email") : $langs->trans(
"Address")),
'checked'=>1,
'position'=>30),
1030 't.note_private' => array(
'label' =>
'NotePrivate',
'checked' => 0,
'position'=>35),
1031 'sc.role'=>array(
'label'=>
"ContactByDefaultFor",
'checked'=>1,
'position'=>40),
1032 't.birthday'=>array(
'label'=>
"Birthday",
'checked'=>0,
'position'=>45),
1033 't.statut'=>array(
'label'=>
"Status",
'checked'=>1,
'position'=>50,
'class'=>
'center'),
1036 if (!empty($extrafields->attributes[$contactstatic->table_element][
'label']) && is_array($extrafields->attributes[$contactstatic->table_element][
'label']) && count($extrafields->attributes[$contactstatic->table_element][
'label'])) {
1037 foreach ($extrafields->attributes[$contactstatic->table_element][
'label'] as $key => $val) {
1038 if (!empty($extrafields->attributes[$contactstatic->table_element][
'list'][$key])) {
1039 $arrayfields[
"ef.".$key] = array(
1040 'label'=>$extrafields->attributes[$contactstatic->table_element][
'label'][$key],
1041 'checked'=>((
dol_eval($extrafields->attributes[$contactstatic->table_element][
'list'][$key], 1, 1,
'1') < 0) ? 0 : 1),
1042 'position'=>1000 + $extrafields->attributes[$contactstatic->table_element][
'pos'][$key],
1043 'enabled' => (abs((
int)
dol_eval($extrafields->attributes[$contactstatic->table_element][
'list'][$key], 1)) != 3 &&
dol_eval($extrafields->attributes[$contactstatic->table_element][
'perms'][$key], 1, 1,
'1'))
1051 foreach ($arrayfields as $key => $val) {
1052 $queryName =
'search_'.substr($key, 2);
1053 if (
GETPOST($queryName,
'alpha')) {
1054 $search[substr($key, 2)] =
GETPOST($queryName,
'alpha');
1057 $search_array_options = $extrafields->getOptionalsFromPost($contactstatic->table_element,
'',
'search_');
1060 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
1062 $search_status =
'';
1064 $search_roles = array();
1065 $search_address =
'';
1067 $search_note_private =
'';
1068 $search_birthday_dtstart =
'';
1069 $search_birthday_dtend =
'';
1071 $search_array_options = array();
1073 foreach ($contactstatic->fields as $key => $val) {
1078 $contactstatic->fields =
dol_sort_array($contactstatic->fields,
'position');
1081 $newcardbutton =
'';
1082 if ($user->hasRight(
'societe',
'contact',
'creer')) {
1083 $addcontact = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"AddContact") : $langs->trans(
"AddContactAddress"));
1084 $newcardbutton .=
dolGetButtonTitle($addcontact,
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/contact/card.php?socid='.$object->id.
'&action=create&backtopage='.urlencode($backtopage));
1089 $title = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"ContactsForCompany") : $langs->trans(
"ContactsAddressesForCompany"));
1092 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'" name="formfilter">';
1093 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1094 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1095 print
'<input type="hidden" name="socid" value="'.$object->id.
'">';
1096 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1097 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1098 print
'<input type="hidden" name="page" value="'.$page.
'">';
1100 $arrayofmassactions = array();
1103 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1104 $selectedfields = ($mode !=
'kanban' ?
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN',
'')) :
'');
1105 $selectedfields .= (count($arrayofmassactions) ?
$form->showCheckAddButtons(
'checkforselect', 1) :
'');
1107 print
'<div class="div-table-responsive">';
1108 print
"\n".
'<table class="tagtable liste">'.
"\n";
1110 $param =
"socid=".urlencode($object->id);
1111 if ($search_rowid !=
'') {
1112 $param .=
'&search_rowid='.urlencode($search_rowid);
1114 if ($search_status !=
'') {
1115 $param .=
'&search_status='.urlencode($search_status);
1117 if (count($search_roles) > 0) {
1118 $param .= implode(
'&search_roles[]=', $search_roles);
1120 if ($search_name !=
'') {
1121 $param .=
'&search_name='.urlencode($search_name);
1123 if ($search_poste !=
'') {
1124 $param .=
'&search_poste='.urlencode($search_poste);
1126 if ($search_address !=
'') {
1127 $param .=
'&search_address='.urlencode($search_address);
1129 if ($search_note_private !=
'') {
1130 $param .=
'&search_note_private='.urlencode($search_note_private);
1132 if ($search_birthday_dtstart !=
'') {
1133 $param .=
'&search_birthday_dtstart='.urlencode($search_birthday_dtstart);
1135 if ($search_birthday_dtend !=
'') {
1136 $param .=
'&search_birthday_dtend='.urlencode($search_birthday_dtend);
1138 if ($optioncss !=
'') {
1139 $param .=
'&optioncss='.urlencode($optioncss);
1143 $extrafieldsobjectkey = $contactstatic->table_element;
1144 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1146 $sql =
"SELECT t.rowid, t.entity, t.lastname, t.firstname, t.fk_pays as country_id, t.civility, t.poste,";
1147 $sql .=
" t.phone as phone_pro, t.phone_mobile, t.phone_perso, t.fax, t.email, t.socialnetworks, t.statut, t.photo, t.fk_soc,";
1148 $sql .=
" t.civility as civility_id, t.address, t.zip, t.town, t.birthday,";
1149 $sql .=
" t.note_private";
1150 $sql .=
" FROM ".MAIN_DB_PREFIX.
"socpeople as t";
1151 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople_extrafields as ef on (t.rowid = ef.fk_object)";
1152 $sql .=
" WHERE t.fk_soc = ".((int) $object->id);
1153 $sql .=
" AND ((t.fk_user_creat = ".((int) $user->id).
" AND t.priv = 1) OR t.priv = 0)";
1154 if ($search_rowid) {
1157 if ($search_status !=
'' && $search_status !=
'-1') {
1158 $sql .=
" AND t.statut = ".((int) $search_status);
1163 if ($search_poste) {
1166 if ($search_address) {
1169 if ($search_note_private) {
1172 if ($search_birthday_dtstart !=
'') {
1173 $sql .=
" AND t.birthday >= '".$db->idate($search_birthday_dtstart).
"'";
1175 if ($search_birthday_dtend !=
'') {
1176 $sql .=
" AND t.birthday <= '".$db->idate($search_birthday_dtend).
"'";
1178 if (count($search_roles) > 0) {
1179 $sql .=
" AND t.rowid IN (SELECT sc.fk_socpeople FROM ".MAIN_DB_PREFIX.
"societe_contacts as sc WHERE sc.fk_c_type_contact IN (".$db->sanitize(implode(
',', $search_roles)).
"))";
1182 $extrafieldsobjectkey = $contactstatic->table_element;
1183 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1185 $parameters = array(
'socid' => $object->id);
1186 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object);
1187 $sql .= $hookmanager->resPrint;
1188 if ($sortfield ==
"t.name") {
1189 $sql .=
" ORDER BY t.lastname $sortorder, t.firstname $sortorder";
1191 $sql .=
" ORDER BY $sortfield $sortorder";
1194 dol_syslog(
'core/lib/company.lib.php :: show_contacts', LOG_DEBUG);
1195 $result = $db->query(
$sql);
1200 $num = $db->num_rows($result);
1204 print
'<tr class="liste_titre">';
1207 print
'<td class="liste_titre" align="right">';
1208 print
$form->showFilterButtons();
1211 foreach ($contactstatic->fields as $key => $val) {
1213 if (in_array($val[
'type'], array(
'date',
'datetime',
'timestamp'))) {
1214 $align .= ($align ?
' ' :
'').
'center';
1216 if (in_array($val[
'type'], array(
'timestamp'))) {
1217 $align .= ($align ?
' ' :
'').
'nowrap';
1219 if ($key ==
'status' || $key ==
'statut') {
1220 $align .= ($align ?
' ' :
'').
'center';
1222 if (!empty($arrayfields[
't.'.$key][
'checked']) || !empty($arrayfields[
'sc.'.$key][
'checked'])) {
1223 print
'<td class="liste_titre'.($align ?
' '.$align :
'').
'">';
1224 if (in_array($key, array(
'statut'))) {
1225 print
$form->selectarray(
'search_status', array(
'-1'=>
'',
'0'=>$contactstatic->LibStatut(0, 1),
'1'=>$contactstatic->LibStatut(1, 1)), $search_status, 0, 0, 0,
'', 0, 0, 0,
'',
'onrightofpage');
1226 } elseif (in_array($key, array(
'role'))) {
1227 print $formcompany->showRoles(
"search_roles", $contactstatic,
'edit', $search_roles,
'minwidth200 maxwidth300');
1228 } elseif (in_array($key, array(
'birthday'))) {
1229 print
'<div class="nowrap">';
1230 print
$form->selectDate($search_birthday_dtstart ? $search_birthday_dtstart :
'',
"search_birthday_dtstart", 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1232 print
'<div class="nowrap">';
1233 print
$form->selectDate($search_birthday_dtend ? $search_birthday_dtend :
'',
"search_birthday_dtend", 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1236 print
'<input type="text" class="flat maxwidth75" name="search_'.$key.
'" value="'.(!empty($search[$key]) ?
dol_escape_htmltag($search[$key]) :
'').
'">';
1241 if ($showuserlogin) {
1242 print
'<td class="liste_titre"></td>';
1245 $extrafieldsobjectkey = $contactstatic->table_element;
1246 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
1249 $parameters = array(
'arrayfields'=>$arrayfields);
1250 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $contactstatic);
1251 print $hookmanager->resPrint;
1254 print
'<td class="liste_titre" align="right">';
1255 print
$form->showFilterButtons();
1263 print
'<tr class="liste_titre">';
1266 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'maxwidthsearch center ').
"\n";
1268 foreach ($contactstatic->fields as $key => $val) {
1270 if (in_array($val[
'type'], array(
'date',
'datetime',
'timestamp'))) {
1271 $align .= ($align ?
' ' :
'').
'center';
1273 if (in_array($val[
'type'], array(
'timestamp'))) {
1274 $align .= ($align ?
' ' :
'').
'nowrap';
1276 if ($key ==
'status' || $key ==
'statut') {
1277 $align .= ($align ?
' ' :
'').
'center';
1279 if (!empty($arrayfields[
't.'.$key][
'checked'])) {
1280 print
getTitleFieldOfList($val[
'label'], 0, $_SERVER[
'PHP_SELF'],
't.'.$key,
'', $param, ($align ?
'class="'.$align.
'"' :
''), $sortfield, $sortorder, $align.
' ').
"\n";
1282 if ($key ==
'role') {
1283 $align .= ($align ?
' ' :
'').
'left';
1285 if (!empty($arrayfields[
'sc.'.$key][
'checked'])) {
1286 print
getTitleFieldOfList($arrayfields[
'sc.'.$key][
'label'], 0, $_SERVER[
'PHP_SELF'],
'',
'', $param, ($align ?
'class="'.$align.
'"' :
''), $sortfield, $sortorder, $align.
' ').
"\n";
1289 if ($showuserlogin) {
1290 print
'<th class="wrapcolumntitle liste_titre">'.$langs->trans(
"DolibarrLogin").
'</th>';
1293 $extrafieldsobjectkey = $contactstatic->table_element;
1294 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
1296 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
1297 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object);
1298 print $hookmanager->resPrint;
1301 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'maxwidthsearch center ').
"\n";
1307 if ($num || (
GETPOST(
'button_search') ||
GETPOST(
'button_search.x') ||
GETPOST(
'button_search_x'))) {
1311 $obj = $db->fetch_object($result);
1313 $contactstatic->id = $obj->rowid;
1314 $contactstatic->ref = $obj->rowid;
1315 $contactstatic->statut = $obj->statut;
1316 $contactstatic->lastname = $obj->lastname;
1317 $contactstatic->firstname = $obj->firstname;
1318 $contactstatic->civility_id = $obj->civility_id;
1319 $contactstatic->civility_code = $obj->civility_id;
1320 $contactstatic->poste = $obj->poste;
1321 $contactstatic->address = $obj->address;
1322 $contactstatic->zip = $obj->zip;
1323 $contactstatic->town = $obj->town;
1324 $contactstatic->phone_pro = $obj->phone_pro;
1325 $contactstatic->phone_mobile = $obj->phone_mobile;
1326 $contactstatic->phone_perso = $obj->phone_perso;
1327 $contactstatic->email = $obj->email;
1328 $contactstatic->socialnetworks = $obj->socialnetworks;
1329 $contactstatic->photo = $obj->photo;
1330 $contactstatic->fk_soc = $obj->fk_soc;
1331 $contactstatic->entity = $obj->entity;
1333 $country_code =
getCountry($obj->country_id, 2);
1334 $contactstatic->country_code = $country_code;
1336 $contactstatic->setGenderFromCivility();
1337 $contactstatic->fetch_optionals();
1339 $resultRole = $contactstatic->fetchRoles();
1340 if ($resultRole < 0) {
1344 if (is_array($contactstatic->array_options)) {
1345 foreach ($contactstatic->array_options as $key => $val) {
1350 print
'<tr class="oddeven">';
1354 print
'<td class="nowrap center">';
1357 if (
isModEnabled(
'agenda')&& $user->hasRight(
'agenda',
'myactions',
'create')) {
1358 print
'<a href="'.DOL_URL_ROOT.
'/comm/action/card.php?action=create&actioncode=&contactid='.$obj->rowid.
'&socid='.$object->id.
'&backtopage='.urlencode($backtopage).
'">';
1359 print
img_object($langs->trans(
"Event"),
"action");
1360 print
'</a> ';
1364 if ($user->hasRight(
'societe',
'contact',
'creer')) {
1365 print
'<a class="editfielda paddingleft" href="'.DOL_URL_ROOT.
'/contact/card.php?action=edit&token='.
newToken().
'&id='.$obj->rowid.
'&backtopage='.urlencode($backtopage).
'">';
1374 if (!empty($arrayfields[
't.rowid'][
'checked'])) {
1376 print $contactstatic->id;
1381 if (!empty($arrayfields[
't.name'][
'checked'])) {
1382 print
'<td class="tdoverflowmax150">';
1383 print
$form->showphoto(
'contact', $contactstatic, 0, 0, 0,
'photorefnoborder valignmiddle marginrightonly',
'small', 1, 0, 1);
1384 print $contactstatic->getNomUrl(0,
'', 0,
'&backtopage='.urlencode($backtopage));
1389 if (!empty($arrayfields[
't.poste'][
'checked'])) {
1390 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->poste).
'">';
1398 if (!empty($arrayfields[
't.address'][
'checked'])) {
1399 $addresstoshow = $contactstatic->getBannerAddress(
'contact', $object);
1400 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag(
dol_string_nohtmltag($addresstoshow)).
'">';
1401 print $addresstoshow;
1406 if (!empty($arrayfields[
't.note_private'][
'checked'])) {
1408 if ($obj->note_private) {
1415 if (!empty($arrayfields[
'sc.role'][
'checked'])) {
1417 print $formcompany->showRoles(
"roles", $contactstatic,
'view');
1422 if (!empty($arrayfields[
't.birthday'][
'checked'])) {
1423 print
'<td class="nowraponall">';
1429 if (!empty($arrayfields[
't.statut'][
'checked'])) {
1430 print
'<td class="center">'.$contactstatic->getLibStatut(5).
'</td>';
1433 if ($showuserlogin) {
1434 print
'<td class="tdoverflowmax125">';
1435 $tmpuser=
new User($db);
1436 $resfetch = $tmpuser->fetch(0,
'',
'', 0, -1,
'', $contactstatic->id);
1437 if ($resfetch > 0) {
1438 print $tmpuser->getNomUrl(1,
'', 0, 0, 24, 1);
1444 $extrafieldsobjectkey = $contactstatic->table_element;
1445 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1449 print
'<td class="nowrap center">';
1452 if (
isModEnabled(
'agenda')&& $user->hasRight(
'agenda',
'myactions',
'create')) {
1453 print
'<a href="'.DOL_URL_ROOT.
'/comm/action/card.php?action=create&actioncode=&contactid='.$obj->rowid.
'&socid='.$object->id.
'&backtopage='.urlencode($backtopage).
'">';
1454 print
img_object($langs->trans(
"Event"),
"action");
1455 print
'</a> ';
1459 if ($user->hasRight(
'societe',
'contact',
'creer')) {
1460 print
'<a class="editfielda paddingleft" href="'.DOL_URL_ROOT.
'/contact/card.php?action=edit&token='.
newToken().
'&id='.$obj->rowid.
'&backtopage='.urlencode($backtopage).
'">';
1473 $colspan = 1 + ($showuserlogin ? 1 : 0);
1474 foreach ($arrayfields as $key => $val) {
1475 if (!empty($val[
'checked'])) {
1479 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1482 $colspan = 1 + ($showuserlogin ? 1 : 0);
1483 foreach ($arrayfields as $key => $val) {
1484 if (!empty($val[
'checked'])) {
1488 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
1490 print
"\n</table>\n";
1493 print
'</form>'.
"\n";
1511 function show_actions_todo($conf, $langs, $db, $filterobj, $objcon =
'', $noprint = 0, $actioncode =
'')
1513 global $user, $conf;
1515 $out =
show_actions_done($conf, $langs, $db, $filterobj, $objcon, 1, $actioncode,
'todo');
1542 function show_actions_done($conf, $langs, $db, $filterobj, $objcon =
'', $noprint = 0, $actioncode =
'', $donetodo =
'done', $filters = array(), $sortfield =
'a.datep,a.id', $sortorder =
'DESC', $module =
'')
1544 global $user, $conf, $hookmanager;
1546 global $param, $massactionbutton;
1548 $start_year =
GETPOST(
'dateevent_startyear',
'int');
1549 $start_month =
GETPOST(
'dateevent_startmonth',
'int');
1550 $start_day =
GETPOST(
'dateevent_startday',
'int');
1551 $end_year =
GETPOST(
'dateevent_endyear',
'int');
1552 $end_month =
GETPOST(
'dateevent_endmonth',
'int');
1553 $end_day =
GETPOST(
'dateevent_endday',
'int');
1557 if (!empty($start_year) && !empty($start_month) && !empty($start_day)) {
1558 $tms_start =
dol_mktime(0, 0, 0, $start_month, $start_day, $start_year,
'tzuserrel');
1560 if (!empty($end_year) && !empty($end_month) && !empty($end_day)) {
1561 $tms_end =
dol_mktime(23, 59, 59, $end_month, $end_day, $end_year,
'tzuserrel');
1563 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
1570 if (!is_object($filterobj) && !is_object($objcon)) {
1580 $sortfield_list = explode(
',', $sortfield);
1581 $sortfield_label_list = array(
'a.id' =>
'id',
'a.datep' =>
'dp',
'a.percent' =>
'percent');
1582 $sortfield_new_list = array();
1583 foreach ($sortfield_list as $sortfield_value) {
1584 $sortfield_new_list[] = $sortfield_label_list[trim($sortfield_value)];
1586 $sortfield_new = implode(
',', $sortfield_new_list);
1592 $hookmanager->initHooks(array(
'agendadao'));
1595 if (is_object($objcon) && $objcon->id > 0) {
1596 $sql =
"SELECT DISTINCT a.id, a.label as label,";
1598 $sql =
"SELECT a.id, a.label as label,";
1600 $sql .=
" a.datep as dp,";
1601 $sql .=
" a.datep2 as dp2,";
1602 $sql .=
" a.percent as percent, 'action' as type,";
1603 $sql .=
" a.fk_element, a.elementtype,";
1604 $sql .=
" a.fk_contact,";
1605 $sql .=
" c.code as acode, c.libelle as alabel, c.picto as apicto,";
1606 $sql .=
" u.rowid as user_id, u.login as user_login, u.photo as user_photo, u.firstname as user_firstname, u.lastname as user_lastname";
1607 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur'))) {
1608 $sql .=
", sp.lastname, sp.firstname";
1609 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1611 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project') {
1613 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1614 $sql .=
", m.lastname, m.firstname";
1615 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1617 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1619 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1621 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1623 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1625 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && $filterobj->table_element && $filterobj->element) {
1626 if (!empty($filterobj->fields[
'ref'])) {
1628 } elseif (!empty($filterobj->fields[
'label'])) {
1629 $sql .=
", o.label";
1634 $parameters = array(
'sql' => &
$sql,
'filterobj' => $filterobj,
'objcon' => $objcon);
1635 $reshook = $hookmanager->executeHooks(
'showActionsDoneListSelect', $parameters);
1636 if (!empty($hookmanager->resPrint))
$sql.= $hookmanager->resPrint;
1638 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm as a";
1639 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u on u.rowid = a.fk_user_action";
1640 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_actioncomm as c ON a.fk_action = c.id";
1642 $force_filter_contact =
false;
1643 if (is_object($objcon) && $objcon->id > 0) {
1644 $force_filter_contact =
true;
1645 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"actioncomm_resources as r ON a.id = r.fk_actioncomm";
1646 $sql .=
" AND r.element_type = '".$db->escape($objcon->table_element).
"' AND r.fk_element = ".((int) $objcon->id);
1650 $parameters = array(
'sql' => &
$sql,
'filterobj' => $filterobj,
'objcon' => $objcon);
1651 $reshook = $hookmanager->executeHooks(
'showActionsDoneListFrom', $parameters);
1652 if (!empty($hookmanager->resPrint))
$sql.= $hookmanager->resPrint;
1654 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur'))) {
1655 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople as sp ON a.fk_contact = sp.rowid";
1656 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1657 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"element_resources as er";
1658 $sql .=
" ON er.resource_type = 'dolresource'";
1659 $sql .=
" AND er.element_id = a.id";
1660 $sql .=
" AND er.resource_id = ".((int) $filterobj->id);
1661 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project') {
1663 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1664 $sql .=
", ".MAIN_DB_PREFIX.
"adherent as m";
1665 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1666 $sql .=
", ".MAIN_DB_PREFIX.
"commande_fournisseur as o";
1667 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1668 $sql .=
", ".MAIN_DB_PREFIX.
"product as o";
1669 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1670 $sql .=
", ".MAIN_DB_PREFIX.
"ticket as o";
1671 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1672 $sql .=
", ".MAIN_DB_PREFIX.
"bom_bom as o";
1673 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1674 $sql .=
", ".MAIN_DB_PREFIX.
"contrat as o";
1675 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && (!empty($filterobj->fields[
'ref']) && is_array($filterobj->fields[
'ref']) || $filterobj->fields[
'label'] && is_array($filterobj->fields[
'label'])) && $filterobj->table_element && $filterobj->element) {
1676 $sql .=
", ".MAIN_DB_PREFIX.$filterobj->table_element.
" as o";
1679 $sql .=
" WHERE a.entity IN (".getEntity(
'agenda').
")";
1680 if ($force_filter_contact ===
false) {
1681 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur')) && $filterobj->id) {
1682 $sql .=
" AND a.fk_soc = ".((int) $filterobj->id);
1683 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1685 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project' && $filterobj->id) {
1686 $sql .=
" AND a.fk_project = ".((int) $filterobj->id);
1687 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1688 $sql .=
" AND a.fk_element = m.rowid AND a.elementtype = 'member'";
1689 if ($filterobj->id) {
1690 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1692 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Commande') {
1693 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'order'";
1694 if ($filterobj->id) {
1695 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1697 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1698 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'order_supplier'";
1699 if ($filterobj->id) {
1700 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1702 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Facture') {
1703 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'invoice'";
1704 if ($filterobj->id) {
1705 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1707 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1708 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'product'";
1709 if ($filterobj->id) {
1710 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1712 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1713 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'ticket'";
1714 if ($filterobj->id) {
1715 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1717 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1718 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'bom'";
1719 if ($filterobj->id) {
1720 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1722 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1723 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'contract'";
1724 if ($filterobj->id) {
1725 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1727 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && (!empty($filterobj->fields[
'ref']) && is_array($filterobj->fields[
'ref']) || $filterobj->fields[
'label'] && is_array($filterobj->fields[
'label'])) && $filterobj->table_element && $filterobj->element) {
1729 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = '".$db->escape($filterobj->element).($module ?
"@".$module :
"").
"'";
1730 if ($filterobj->id) {
1731 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1736 if (!empty($tms_start) && !empty($tms_end)) {
1737 $sql .=
" AND ((a.datep BETWEEN '".$db->idate($tms_start).
"' AND '".$db->idate($tms_end).
"') OR (a.datep2 BETWEEN '".$db->idate($tms_start).
"' AND '".$db->idate($tms_end).
"'))";
1738 } elseif (empty($tms_start) && !empty($tms_end)) {
1739 $sql .=
" AND ((a.datep <= '".$db->idate($tms_end).
"') OR (a.datep2 <= '".$db->idate($tms_end).
"'))";
1740 } elseif (!empty($tms_start) && empty($tms_end)) {
1741 $sql .=
" AND ((a.datep >= '".$db->idate($tms_start).
"') OR (a.datep2 >= '".$db->idate($tms_start).
"'))";
1744 if (is_array($actioncode) && !empty($actioncode)) {
1746 foreach ($actioncode as $key => $code) {
1750 if (!empty($code)) {
1758 } elseif (!empty($actioncode)) {
1765 $parameters = array(
'sql' => &
$sql,
'filterobj' => $filterobj,
'objcon' => $objcon,
'module' => $module);
1766 $reshook = $hookmanager->executeHooks(
'showActionsDoneListWhere', $parameters);
1767 if (!empty($hookmanager->resPrint))
$sql.= $hookmanager->resPrint;
1769 if (is_array($actioncode)) {
1770 foreach ($actioncode as $code) {
1772 if (!empty($sql2)) {
1775 } elseif (empty(
$sql)) {
1783 if (!empty(
$sql) && !empty($sql2)) {
1785 } elseif (empty(
$sql) && !empty($sql2)) {
1793 $sql .= $db->order($sortfield_new, $sortorder);
1795 dol_syslog(
"company.lib::show_actions_done", LOG_DEBUG);
1797 $resql = $db->query(
$sql);
1800 $num = $db->num_rows($resql);
1803 $obj = $db->fetch_object($resql);
1805 if ($obj->type ==
'action') {
1807 $contactaction->id = $obj->id;
1808 $result = $contactaction->fetchResources();
1811 setEventMessage(
"company.lib::show_actions_done Error fetch ressource",
'errors');
1817 if (($obj->percent >= 0 and $obj->percent < 100) || ($obj->percent == -1 && (!empty($obj->datep) && $obj->datep > $now))) {
1821 $histo[$numaction] = array(
1823 'tododone'=>$tododone,
1825 'datestart'=>$db->jdate($obj->dp),
1826 'dateend'=>$db->jdate($obj->dp2),
1827 'note'=>$obj->label,
1828 'percent'=>$obj->percent,
1830 'userid'=>$obj->user_id,
1831 'login'=>$obj->user_login,
1832 'userfirstname'=>$obj->user_firstname,
1833 'userlastname'=>$obj->user_lastname,
1834 'userphoto'=>$obj->user_photo,
1836 'contact_id'=>$obj->fk_contact,
1837 'socpeopleassigned' => $contactaction->socpeopleassigned,
1838 'lastname' => empty($obj->lastname) ?
'' : $obj->lastname,
1839 'firstname' => empty($obj->firstname) ?
'' : $obj->firstname,
1840 'fk_element'=>$obj->fk_element,
1841 'elementtype'=>$obj->elementtype,
1843 'acode'=>$obj->acode,
1844 'alabel'=>$obj->alabel,
1845 'libelle'=>$obj->alabel,
1846 'apicto'=>$obj->apicto
1849 $histo[$numaction] = array(
1853 'datestart'=>$db->jdate($obj->dp),
1854 'dateend'=>$db->jdate($obj->dp2),
1855 'note'=>$obj->label,
1856 'percent'=>$obj->percent,
1857 'acode'=>$obj->acode,
1859 'userid'=>$obj->user_id,
1860 'login'=>$obj->user_login,
1861 'userfirstname'=>$obj->user_firstname,
1862 'userlastname'=>$obj->user_lastname,
1863 'userphoto'=>$obj->user_photo
1876 $delay_warning = $conf->global->MAIN_DELAY_ACTIONS_TODO * 24 * 60 * 60;
1878 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
1879 include_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
1880 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formactions.class.php';
1881 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
1886 $userstatic =
new User($db);
1887 $userlinkcache = array();
1888 $contactstatic =
new Contact($db);
1889 $elementlinkcache = array();
1891 $out .=
'<form name="listactionsfilter" class="listactionsfilter" action="'.$_SERVER[
"PHP_SELF"].
'" method="POST">';
1892 $out .=
'<input type="hidden" name="token" value="'.newToken().
'">';
1893 if ($objcon && get_class($objcon) ==
'Contact' &&
1894 (is_null($filterobj) || get_class($filterobj) ==
'Societe')) {
1895 $out .=
'<input type="hidden" name="id" value="'.$objcon->id.
'" />';
1897 $out .=
'<input type="hidden" name="id" value="'.$filterobj->id.
'" />';
1899 if ($filterobj && get_class($filterobj) ==
'Societe') {
1900 $out .=
'<input type="hidden" name="socid" value="'.$filterobj->id.
'" />';
1905 $out .=
'<div class="div-table-responsive-no-min">';
1906 $out .=
'<table class="noborder centpercent">';
1908 $out .=
'<tr class="liste_titre">';
1912 $out .=
'<th class="liste_titre width50 middle">';
1913 $searchpicto =
$form->showFilterAndCheckAddButtons($massactionbutton ? 1 : 0,
'checkforselect', 1);
1914 $out .= $searchpicto;
1919 $out .=
'<td class="liste_titre"></td>';
1922 $out .=
'<td class="liste_titre"><input type="text" class="width50" name="search_rowid" value="'.(isset($filters[
'search_rowid']) ? $filters[
'search_rowid'] :
'').
'"></td>';
1923 $out .=
'<td class="liste_titre"></td>';
1924 $out .=
'<td class="liste_titre">';
1925 $out .=
$formactions->select_type_actions($actioncode,
"actioncode",
'', empty($conf->global->AGENDA_USE_EVENT_TYPE) ? 1 : -1, 0, (empty($conf->global->AGENDA_USE_MULTISELECT_TYPE) ? 0 : 1), 1,
'minwidth100 maxwidth150');
1927 $out .=
'<td class="liste_titre maxwidth100onsmartphone"><input type="text" class="maxwidth100onsmartphone" name="search_agenda_label" value="'.$filters[
'search_agenda_label'].
'"></td>';
1928 $out .=
'<td class="liste_titre center">';
1929 $out .=
$form->selectDateToDate($tms_start, $tms_end,
'dateevent', 1);
1931 $out .=
'<td class="liste_titre"></td>';
1932 $out .=
'<td class="liste_titre"></td>';
1933 $out .=
'<td class="liste_titre"></td>';
1936 $out .=
'<td class="liste_titre" align="middle">';
1937 $searchpicto =
$form->showFilterAndCheckAddButtons($massactionbutton ? 1 : 0,
'checkforselect', 1);
1938 $out .= $searchpicto;
1943 $out .=
'<tr class="liste_titre">';
1946 $out .=
getTitleFieldOfList(
'', 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch ');
1950 if (get_class($filterobj) ==
'Societe') {
1951 $tmp .=
'<a href="'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&socid='.$filterobj->id.
'&status=done">';
1953 $tmp .= ($donetodo !=
'done' ? $langs->trans(
"ActionsToDoShort") :
'');
1954 $tmp .= ($donetodo !=
'done' && $donetodo !=
'todo' ?
' / ' :
'');
1955 $tmp .= ($donetodo !=
'todo' ? $langs->trans(
"ActionsDoneShort") :
'');
1957 if (get_class($filterobj) ==
'Societe') {
1962 $out .=
getTitleFieldOfList(
"Ref", 0, $_SERVER[
"PHP_SELF"],
'a.id',
'', $param,
'', $sortfield, $sortorder);
1965 $out .=
getTitleFieldOfList(
"Label", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
1966 $out .=
getTitleFieldOfList(
"Date", 0, $_SERVER[
"PHP_SELF"],
'a.datep,a.id',
'', $param,
'', $sortfield, $sortorder,
'center ');
1967 $out .=
getTitleFieldOfList(
"RelatedObjects", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
1968 $out .=
getTitleFieldOfList(
"ActionOnContact", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'tdoverflowmax125 ', 0,
'', 0);
1969 $out .=
getTitleFieldOfList(
"Status", 0, $_SERVER[
"PHP_SELF"],
'a.percent',
'', $param,
'', $sortfield, $sortorder,
'center ');
1972 $out .=
getTitleFieldOfList(
'', 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch ');
1976 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/cactioncomm.class.php';
1978 $arraylist = $caction->liste_array(1,
'code',
'', (empty($conf->global->AGENDA_USE_EVENT_TYPE) ? 1 : 0),
'', 1);
1980 foreach ($histo as $key => $value) {
1981 $actionstatic->fetch($histo[$key][
'id']);
1983 $actionstatic->type_picto = $histo[$key][
'apicto'];
1984 $actionstatic->type_code = $histo[$key][
'acode'];
1986 $out .=
'<tr class="oddeven">';
1990 $out .=
'<td></td>';
1995 $out .=
'<td class="nowrap">';
2000 $out .=
'<td class="nowraponall">';
2001 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'mailing') {
2002 $out .=
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/card.php?id='.$histo[$key][
'id'].
'">'.
img_object($langs->trans(
"ShowEMailing"),
"email").
' ';
2003 $out .= $histo[$key][
'id'];
2006 $out .= $actionstatic->getNomUrl(1, -1);
2011 $out .=
'<td class="tdoverflowmax150">';
2015 if ($histo[$key][
'userid'] > 0) {
2016 if (isset($userlinkcache[$histo[$key][
'userid']])) {
2017 $link = $userlinkcache[$histo[$key][
'userid']];
2019 $userstatic->fetch($histo[$key][
'userid']);
2020 $link = $userstatic->getNomUrl(-1,
'', 0, 0, 16, 0,
'firstelselast',
'');
2021 $userlinkcache[$histo[$key][
'userid']] = $link;
2028 $labeltype = $actionstatic->type_code;
2029 if (empty($conf->global->AGENDA_USE_EVENT_TYPE) && empty($arraylist[$labeltype])) {
2030 $labeltype =
'AC_OTH';
2032 if (!empty($actionstatic->code) && preg_match(
'/^TICKET_MSG/', $actionstatic->code)) {
2033 $labeltype = $langs->trans(
"Message");
2035 if (!empty($arraylist[$labeltype])) {
2036 $labeltype = $arraylist[$labeltype];
2038 if ($actionstatic->type_code ==
'AC_OTH_AUTO' && ($actionstatic->type_code != $actionstatic->code) && $labeltype && !empty($arraylist[$actionstatic->code])) {
2039 $labeltype .=
' - '.$arraylist[$actionstatic->code];
2042 $out .=
'<td class="tdoverflowmax150" title="'.$labeltype.
'">';
2043 $out .= $actionstatic->getTypePicto();
2048 $out .=
'<td class="tdoverflowmax300"';
2049 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'action') {
2050 $transcode = $langs->trans(
"Action".$histo[$key][
'acode']);
2051 $libelle = ($transcode !=
"Action".$histo[$key][
'acode'] ? $transcode : $histo[$key][
'alabel']);
2053 $libelle = $histo[$key][
'note'];
2054 $actionstatic->id = $histo[$key][
'id'];
2055 $out .=
' title="'.dol_escape_htmltag($libelle).
'">';
2058 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'mailing') {
2059 $out .=
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/card.php?id='.$histo[$key][
'id'].
'">'.
img_object($langs->trans(
"ShowEMailing"),
"email").
' ';
2060 $transcode = $langs->trans(
"Action".$histo[$key][
'acode']);
2061 $libelle = ($transcode !=
"Action".$histo[$key][
'acode'] ? $transcode :
'Send mass mailing');
2062 $out .=
' title="'.dol_escape_htmltag($libelle).
'">';
2068 $out .=
'<td class="center nowraponall">';
2069 $out .=
dol_print_date($histo[$key][
'datestart'],
'dayhour',
'tzuserrel');
2070 if ($histo[$key][
'dateend'] && $histo[$key][
'dateend'] != $histo[$key][
'datestart']) {
2071 $tmpa =
dol_getdate($histo[$key][
'datestart'],
true);
2072 $tmpb =
dol_getdate($histo[$key][
'dateend'],
true);
2073 if ($tmpa[
'mday'] == $tmpb[
'mday'] && $tmpa[
'mon'] == $tmpb[
'mon'] && $tmpa[
'year'] == $tmpb[
'year']) {
2074 $out .=
'-'.dol_print_date($histo[$key][
'dateend'],
'hour',
'tzuserrel');
2076 $out .=
'-'.dol_print_date($histo[$key][
'dateend'],
'dayhour',
'tzuserrel');
2080 if ($histo[$key][
'percent'] == 0 && $histo[$key][
'datestart'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
2083 if ($histo[$key][
'percent'] == 0 && !$histo[$key][
'datestart'] && $histo[$key][
'dateend'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
2086 if ($histo[$key][
'percent'] > 0 && $histo[$key][
'percent'] < 100 && $histo[$key][
'dateend'] && $histo[$key][
'dateend'] < ($now - $delay_warning)) {
2089 if ($histo[$key][
'percent'] > 0 && $histo[$key][
'percent'] < 100 && !$histo[$key][
'dateend'] && $histo[$key][
'datestart'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
2101 $out .=
'<td class="nowraponall">';
2102 if (isset($histo[$key][
'elementtype']) && !empty($histo[$key][
'fk_element'])) {
2103 if (isset($elementlinkcache[$histo[$key][
'elementtype']]) && isset($elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']])) {
2104 $link = $elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']];
2106 if (!isset($elementlinkcache[$histo[$key][
'elementtype']])) {
2107 $elementlinkcache[$histo[$key][
'elementtype']] = array();
2109 $link =
dolGetElementUrl($histo[$key][
'fk_element'], $histo[$key][
'elementtype'], 1);
2110 $elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']] = $link;
2119 if (isset($histo[$key][
'socpeopleassigned']) && is_array($histo[$key][
'socpeopleassigned']) && count($histo[$key][
'socpeopleassigned']) > 0) {
2120 $out .=
'<td class="valignmiddle">';
2122 foreach ($histo[$key][
'socpeopleassigned'] as $cid => $cvalue) {
2123 $result = $contact->fetch($cid);
2130 $out .= $contact->getNomUrl(-3,
'', 10,
'', -1, 0,
'paddingright');
2131 if (isset($histo[$key][
'acode']) && $histo[$key][
'acode'] ==
'AC_TEL') {
2132 if (!empty($contact->phone_pro)) {
2133 $out .=
'('.dol_print_phone($contact->phone_pro).
')';
2136 $out .=
'<div class="paddingright"></div>';
2140 } elseif (empty($objcon->id) && isset($histo[$key][
'contact_id']) && $histo[$key][
'contact_id'] > 0) {
2141 $contactstatic->lastname = $histo[$key][
'lastname'];
2142 $contactstatic->firstname = $histo[$key][
'firstname'];
2143 $contactstatic->id = $histo[$key][
'contact_id'];
2144 $contactstatic->photo = $histo[$key][
'contact_photo'];
2145 $out .=
'<td width="120">'.$contactstatic->getNomUrl(-1,
'', 10).
'</td>';
2147 $out .=
'<td> </td>';
2151 $out .=
'<td class="nowrap center">'.$actionstatic->LibStatut($histo[$key][
'percent'], 2, 0, $histo[$key][
'datestart']).
'</td>';
2155 $out .=
'<td></td>';
2161 if (empty($histo)) {
2163 $out .=
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
2166 $out .=
"</table>\n";
2194 $sql =
"SELECT s.rowid, s.client, s.fournisseur, s.nom as name, s.name_alias, s.email, s.address, s.zip, s.town, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.canvas";
2195 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
2196 $sql .=
" WHERE s.parent = ".((int) $object->id);
2197 $sql .=
" AND s.entity IN (".getEntity(
'societe').
")";
2198 $sql .=
" ORDER BY s.nom";
2200 $result = $db->query(
$sql);
2201 $num = $db->num_rows($result);
2204 $socstatic =
new Societe($db);
2208 print
"\n".
'<div class="div-table-responsive-no-min">'.
"\n";
2209 print
'<table class="noborder centpercent">'.
"\n";
2211 print
'<tr class="liste_titre"><td>'.$langs->trans(
"Company").
'</td>';
2212 print
'<td>'.$langs->trans(
"Address").
'</td><td>'.$langs->trans(
"Zip").
'</td>';
2213 print
'<td>'.$langs->trans(
"Town").
'</td><td>'.$langs->trans(
"CustomerCode").
'</td>';
2214 print
"<td> </td>";
2220 $obj = $db->fetch_object($result);
2222 $socstatic->id = $obj->rowid;
2223 $socstatic->name = $obj->name;
2224 $socstatic->name_alias = $obj->name_alias;
2225 $socstatic->email = $obj->email;
2226 $socstatic->code_client = $obj->code_client;
2227 $socstatic->code_fournisseur = $obj->code_client;
2228 $socstatic->code_compta = $obj->code_compta;
2229 $socstatic->code_compta_fournisseur = $obj->code_compta_fournisseur;
2230 $socstatic->email = $obj->email;
2231 $socstatic->canvas = $obj->canvas;
2232 $socstatic->client = $obj->client;
2233 $socstatic->fournisseur = $obj->fournisseur;
2235 print
'<tr class="oddeven">';
2237 print
'<td class="tdoverflowmax150">';
2238 print $socstatic->getNomUrl(1);
2241 print
'<td class="tdoverflowmax400" title="'.dol_escape_htmltag($obj->address).
'">'.
dol_escape_htmltag($obj->address).
'</td>';
2242 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->zip).
'">'.$obj->zip.
'</td>';
2243 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->town).
'">'.$obj->town.
'</td>';
2244 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->code_client).
'">'.$obj->code_client.
'</td>';
2246 print
'<td class="center">';
2247 print
'<a class="editfielda" href="'.DOL_URL_ROOT.
'/societe/card.php?socid='.((int) $obj->rowid).
'&action=edit&token='.
newToken().
'">';
2254 print
"\n</table>\n";
2255 print
'</div>'.
"\n";
2275 if (empty($conf->global->AGENDA_USE_EVENT_TYPE)) {
2276 if ($actioncode ==
'AC_NON_AUTO') {
2277 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2278 } elseif ($actioncode ==
'AC_ALL_AUTO') {
2279 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2281 if ($actioncode ==
'AC_OTH') {
2282 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2283 } elseif ($actioncode ==
'AC_OTH_AUTO') {
2284 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2288 if ($actioncode ==
'AC_NON_AUTO') {
2289 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2290 } elseif ($actioncode ==
'AC_ALL_AUTO') {
2291 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2293 $sql .=
" $sqlANDOR c.code = '".$db->escape($actioncode).
"'";
2313 if ($donetodo ==
'todo') {
2314 $sql .=
" AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep > '".$db->idate($now).
"'))";
2315 } elseif ($donetodo ==
'done') {
2316 $sql .=
" AND (a.percent = 100 OR (a.percent = -1 AND a.datep <= '".$db->idate($now).
"'))";
2318 if (is_array($filters) && !empty($filters[
'search_agenda_label'])) {
2321 if (is_array($filters) && !empty($filters[
'search_rowid'])) {
2341 if (
isModEnabled(
'mailing') && !empty($objcon->email) && (empty($actioncode) || $actioncode ==
'AC_OTH_AUTO' || $actioncode ==
'AC_EMAILING')) {
2342 $sql2 =
"SELECT m.rowid as id, m.titre as label, mc.date_envoi as dp, mc.date_envoi as dp2, '100' as percent, 'mailing' as type";
2343 $sql2 .=
", null as fk_element, '' as elementtype, null as contact_id";
2344 $sql2 .=
", 'AC_EMAILING' as acode, '' as alabel, '' as apicto";
2345 $sql2 .=
", u.rowid as user_id, u.login as user_login, u.photo as user_photo, u.firstname as user_firstname, u.lastname as user_lastname";
2346 if (is_object($filterobj) && get_class($filterobj) ==
'Societe') {
2347 $sql2 .=
", '' as lastname, '' as firstname";
2348 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
2349 $sql2 .=
", '' as lastname, '' as firstname";
2350 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
2351 $sql2 .=
", '' as ref";
2352 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
2353 $sql2 .=
", '' as ref";
2354 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
2355 $sql2 .=
", '' as ref";
2357 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"mailing as m, ".MAIN_DB_PREFIX.
"mailing_cibles as mc, ".MAIN_DB_PREFIX.
"user as u";
2358 $sql2 .=
" WHERE mc.email = '".$db->escape($objcon->email).
"'";
2359 $sql2 .=
" AND mc.statut = 1";
2360 $sql2 .=
" AND u.rowid = m.fk_user_valid";
2361 $sql2 .=
" AND mc.fk_mailing=m.rowid";
2389 if ($fromcompany->forme_juridique_code) {
2393 if ($fromcompany->capital) {
2394 $line1 .= ($line1 ?
" - " :
"").$langs->transnoentities(
"CapitalOf", $fromcompany->capital).
" ".$langs->transnoentities(
"Currency".$conf->currency);
2397 if ($fromcompany->idprof1 && ($fromcompany->country_code !=
'FR' || !$fromcompany->idprof2)) {
2398 $field = $langs->transcountrynoentities(
"ProfId1", $fromcompany->country_code);
2399 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2402 $line1 .= ($line1 ?
" - " :
"").$field.
": ".$fromcompany->idprof1;
2405 if ($fromcompany->idprof2) {
2406 $field = $langs->transcountrynoentities(
"ProfId2", $fromcompany->country_code);
2407 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2410 $line1 .= ($line1 ?
" - " :
"").$field.
": ".$fromcompany->idprof2;
2416 if ($fromcompany->idprof3) {
2417 $field = $langs->transcountrynoentities(
"ProfId3", $fromcompany->country_code);
2418 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2421 $line2 .= ($line2 ?
" - " :
"").$field.
": ".$fromcompany->idprof3;
2424 if ($fromcompany->idprof4) {
2425 $field = $langs->transcountrynoentities(
"ProfId4", $fromcompany->country_code);
2426 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2429 $line2 .= ($line2 ?
" - " :
"").$field.
": ".$fromcompany->idprof4;
2432 if ($fromcompany->tva_intra !=
'') {
2433 $line2 .= ($line2 ?
" - " :
"").$langs->transnoentities(
"VATIntraShort").
": ".$fromcompany->tva_intra;
2436 print
'<!-- htmlPrintOnlineFooter -->'.
"\n";
2438 print
'<footer class="center paddingleft paddingright opacitymedium centpercent">'.
"\n";
2440 if ($addformmessage) {
2441 print
'<!-- object = '.(empty($object) ?
'undefined' : $object->element).
' -->';
2444 $parammessageform =
'ONLINE_PAYMENT_MESSAGE_FORM_'.$suffix;
2445 if (!empty($conf->global->$parammessageform)) {
2446 print $langs->transnoentities($conf->global->$parammessageform);
2447 } elseif (!empty($conf->global->ONLINE_PAYMENT_MESSAGE_FORM)) {
2448 print $langs->transnoentities($conf->global->ONLINE_PAYMENT_MESSAGE_FORM);
2452 if (!empty($object->total_vat) || !empty($object->total_tva)) {
2453 $parammessageform =
'ONLINE_PAYMENT_MESSAGE_FORMIFVAT_'.$suffix;
2454 if (!empty($conf->global->$parammessageform)) {
2455 print $langs->transnoentities($conf->global->$parammessageform);
2456 } elseif (!empty($conf->global->ONLINE_PAYMENT_MESSAGE_FORMIFVAT)) {
2457 print $langs->transnoentities($conf->global->ONLINE_PAYMENT_MESSAGE_FORMIFVAT);
2462 print
'<span style="font-size: 10px;"><br><hr>'.
"\n";
2463 print $fromcompany->name.
'<br>';
2465 if (strlen($line1.$line2) > 50) {
2472 print
'</footer>'.
"\n";