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->rights->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')&& (!empty($user->rights->agenda->myactions->read) || !empty($user->rights->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
price($obj->opp_amount, 1,
'', 1, -1, -1,
'');
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'=>(($extrafields->attributes[$contactstatic->table_element][
'list'][$key] < 0) ? 0 : 1),
1042 'position'=>1000 + $extrafields->attributes[$contactstatic->table_element][
'pos'][$key],
1043 'enabled'=>(abs($extrafields->attributes[$contactstatic->table_element][
'list'][$key]) != 3 && $extrafields->attributes[$contactstatic->table_element][
'perms'][$key]));
1050 foreach ($arrayfields as $key => $val) {
1051 $queryName =
'search_'.substr($key, 2);
1052 if (
GETPOST($queryName,
'alpha')) {
1053 $search[substr($key, 2)] =
GETPOST($queryName,
'alpha');
1056 $search_array_options = $extrafields->getOptionalsFromPost($contactstatic->table_element,
'',
'search_');
1059 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
1061 $search_status =
'';
1063 $search_roles = array();
1064 $search_address =
'';
1066 $search_note_private =
'';
1067 $search_birthday_dtstart =
'';
1068 $search_birthday_dtend =
'';
1070 $search_array_options = array();
1072 foreach ($contactstatic->fields as $key => $val) {
1077 $contactstatic->fields =
dol_sort_array($contactstatic->fields,
'position');
1080 $newcardbutton =
'';
1081 if ($user->hasRight(
'societe',
'contact',
'creer')) {
1082 $addcontact = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"AddContact") : $langs->trans(
"AddContactAddress"));
1083 $newcardbutton .=
dolGetButtonTitle($addcontact,
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/contact/card.php?socid='.$object->id.
'&action=create&backtopage='.urlencode($backtopage));
1088 $title = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"ContactsForCompany") : $langs->trans(
"ContactsAddressesForCompany"));
1091 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'" name="formfilter">';
1092 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1093 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1094 print
'<input type="hidden" name="socid" value="'.$object->id.
'">';
1095 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1096 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1097 print
'<input type="hidden" name="page" value="'.$page.
'">';
1099 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1100 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
1103 print
'<div class="div-table-responsive">';
1104 print
"\n".
'<table class="tagtable liste">'.
"\n";
1106 $param =
"socid=".urlencode($object->id);
1107 if ($search_rowid !=
'') {
1108 $param .=
'&search_rowid='.urlencode($search_rowid);
1110 if ($search_status !=
'') {
1111 $param .=
'&search_status='.urlencode($search_status);
1113 if (count($search_roles) > 0) {
1114 $param .= implode(
'&search_roles[]=', $search_roles);
1116 if ($search_name !=
'') {
1117 $param .=
'&search_name='.urlencode($search_name);
1119 if ($search_poste !=
'') {
1120 $param .=
'&search_poste='.urlencode($search_poste);
1122 if ($search_address !=
'') {
1123 $param .=
'&search_address='.urlencode($search_address);
1125 if ($search_note_private !=
'') {
1126 $param .=
'&search_note_private='.urlencode($search_note_private);
1128 if ($search_birthday_dtstart !=
'') {
1129 $param .=
'&search_birthday_dtstart='.urlencode($search_birthday_dtstart);
1131 if ($search_birthday_dtend !=
'') {
1132 $param .=
'&search_birthday_dtend='.urlencode($search_birthday_dtend);
1134 if ($optioncss !=
'') {
1135 $param .=
'&optioncss='.urlencode($optioncss);
1139 $extrafieldsobjectkey = $contactstatic->table_element;
1140 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1142 $sql =
"SELECT t.rowid, t.entity, t.lastname, t.firstname, t.fk_pays as country_id, t.civility, t.poste,";
1143 $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,";
1144 $sql .=
" t.civility as civility_id, t.address, t.zip, t.town, t.birthday,";
1145 $sql .=
" t.note_private";
1146 $sql .=
" FROM ".MAIN_DB_PREFIX.
"socpeople as t";
1147 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople_extrafields as ef on (t.rowid = ef.fk_object)";
1148 $sql .=
" WHERE t.fk_soc = ".((int) $object->id);
1149 $sql .=
" AND ((t.fk_user_creat = ".((int) $user->id).
" AND t.priv = 1) OR t.priv = 0)";
1150 if ($search_rowid) {
1153 if ($search_status !=
'' && $search_status !=
'-1') {
1154 $sql .=
" AND t.statut = ".((int) $search_status);
1159 if ($search_poste) {
1162 if ($search_address) {
1165 if ($search_note_private) {
1168 if ($search_birthday_dtstart !=
'') {
1169 $sql .=
" AND t.birthday >= '".$db->idate($search_birthday_dtstart).
"'";
1171 if ($search_birthday_dtend !=
'') {
1172 $sql .=
" AND t.birthday <= '".$db->idate($search_birthday_dtend).
"'";
1174 if (count($search_roles) > 0) {
1175 $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)).
"))";
1178 $extrafieldsobjectkey = $contactstatic->table_element;
1179 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1181 $parameters = array(
'socid' => $object->id);
1182 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object);
1183 $sql .= $hookmanager->resPrint;
1184 if ($sortfield ==
"t.name") {
1185 $sql .=
" ORDER BY t.lastname $sortorder, t.firstname $sortorder";
1187 $sql .=
" ORDER BY $sortfield $sortorder";
1190 dol_syslog(
'core/lib/company.lib.php :: show_contacts', LOG_DEBUG);
1191 $result = $db->query(
$sql);
1196 $num = $db->num_rows($result);
1200 print
'<tr class="liste_titre">';
1201 foreach ($contactstatic->fields as $key => $val) {
1203 if (in_array($val[
'type'], array(
'date',
'datetime',
'timestamp'))) {
1204 $align .= ($align ?
' ' :
'').
'center';
1206 if (in_array($val[
'type'], array(
'timestamp'))) {
1207 $align .= ($align ?
' ' :
'').
'nowrap';
1209 if ($key ==
'status' || $key ==
'statut') {
1210 $align .= ($align ?
' ' :
'').
'center';
1212 if (!empty($arrayfields[
't.'.$key][
'checked']) || !empty($arrayfields[
'sc.'.$key][
'checked'])) {
1213 print
'<td class="liste_titre'.($align ?
' '.$align :
'').
'">';
1214 if (in_array($key, array(
'statut'))) {
1215 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');
1216 } elseif (in_array($key, array(
'role'))) {
1217 print $formcompany->showRoles(
"search_roles", $contactstatic,
'edit', $search_roles,
'minwidth200 maxwidth300');
1218 } elseif (in_array($key, array(
'birthday'))) {
1219 print
'<div class="nowrap">';
1220 print
$form->selectDate($search_birthday_dtstart ? $search_birthday_dtstart :
'',
"search_birthday_dtstart", 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1222 print
'<div class="nowrap">';
1223 print
$form->selectDate($search_birthday_dtend ? $search_birthday_dtend :
'',
"search_birthday_dtend", 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1226 print
'<input type="text" class="flat maxwidth75" name="search_'.$key.
'" value="'.(!empty($search[$key]) ?
dol_escape_htmltag($search[$key]) :
'').
'">';
1231 if ($showuserlogin) {
1232 print
'<td class="liste_titre"></td>';
1235 $extrafieldsobjectkey = $contactstatic->table_element;
1236 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
1239 $parameters = array(
'arrayfields'=>$arrayfields);
1240 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $contactstatic);
1241 print $hookmanager->resPrint;
1243 print
'<td class="liste_titre" align="right">';
1244 print
$form->showFilterButtons();
1251 print
'<tr class="liste_titre">';
1252 foreach ($contactstatic->fields as $key => $val) {
1254 if (in_array($val[
'type'], array(
'date',
'datetime',
'timestamp'))) {
1255 $align .= ($align ?
' ' :
'').
'center';
1257 if (in_array($val[
'type'], array(
'timestamp'))) {
1258 $align .= ($align ?
' ' :
'').
'nowrap';
1260 if ($key ==
'status' || $key ==
'statut') {
1261 $align .= ($align ?
' ' :
'').
'center';
1263 if (!empty($arrayfields[
't.'.$key][
'checked'])) {
1264 print
getTitleFieldOfList($val[
'label'], 0, $_SERVER[
'PHP_SELF'],
't.'.$key,
'', $param, ($align ?
'class="'.$align.
'"' :
''), $sortfield, $sortorder, $align.
' ').
"\n";
1266 if ($key ==
'role') {
1267 $align .= ($align ?
' ' :
'').
'left';
1269 if (!empty($arrayfields[
'sc.'.$key][
'checked'])) {
1270 print
getTitleFieldOfList($arrayfields[
'sc.'.$key][
'label'], 0, $_SERVER[
'PHP_SELF'],
'',
'', $param, ($align ?
'class="'.$align.
'"' :
''), $sortfield, $sortorder, $align.
' ').
"\n";
1273 if ($showuserlogin) {
1274 print
'<th class="wrapcolumntitle liste_titre">'.$langs->trans(
"DolibarrLogin").
'</th>';
1277 $extrafieldsobjectkey = $contactstatic->table_element;
1278 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
1280 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
1281 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object);
1282 print $hookmanager->resPrint;
1283 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ').
"\n";
1288 if ($num || (
GETPOST(
'button_search') ||
GETPOST(
'button_search.x') ||
GETPOST(
'button_search_x'))) {
1292 $obj = $db->fetch_object($result);
1294 $contactstatic->id = $obj->rowid;
1295 $contactstatic->ref = $obj->rowid;
1296 $contactstatic->statut = $obj->statut;
1297 $contactstatic->lastname = $obj->lastname;
1298 $contactstatic->firstname = $obj->firstname;
1299 $contactstatic->civility_id = $obj->civility_id;
1300 $contactstatic->civility_code = $obj->civility_id;
1301 $contactstatic->poste = $obj->poste;
1302 $contactstatic->address = $obj->address;
1303 $contactstatic->zip = $obj->zip;
1304 $contactstatic->town = $obj->town;
1305 $contactstatic->phone_pro = $obj->phone_pro;
1306 $contactstatic->phone_mobile = $obj->phone_mobile;
1307 $contactstatic->phone_perso = $obj->phone_perso;
1308 $contactstatic->email = $obj->email;
1309 $contactstatic->socialnetworks = $obj->socialnetworks;
1310 $contactstatic->photo = $obj->photo;
1311 $contactstatic->fk_soc = $obj->fk_soc;
1312 $contactstatic->entity = $obj->entity;
1314 $country_code =
getCountry($obj->country_id, 2);
1315 $contactstatic->country_code = $country_code;
1317 $contactstatic->setGenderFromCivility();
1318 $contactstatic->fetch_optionals();
1320 $resultRole = $contactstatic->fetchRoles();
1321 if ($resultRole < 0) {
1325 if (is_array($contactstatic->array_options)) {
1326 foreach ($contactstatic->array_options as $key => $val) {
1331 print
'<tr class="oddeven">';
1334 if (!empty($arrayfields[
't.rowid'][
'checked'])) {
1336 print $contactstatic->id;
1341 if (!empty($arrayfields[
't.name'][
'checked'])) {
1343 print
$form->showphoto(
'contact', $contactstatic, 0, 0, 0,
'photorefnoborder valignmiddle marginrightonly',
'small', 1, 0, 1);
1344 print $contactstatic->getNomUrl(0,
'', 0,
'&backtopage='.urlencode($backtopage));
1349 if (!empty($arrayfields[
't.poste'][
'checked'])) {
1358 if (!empty($arrayfields[
't.address'][
'checked'])) {
1360 print $contactstatic->getBannerAddress(
'contact', $object);
1365 if (!empty($arrayfields[
't.note_private'][
'checked'])) {
1367 if ($obj->note_private) {
1374 if (!empty($arrayfields[
'sc.role'][
'checked'])) {
1376 print $formcompany->showRoles(
"roles", $contactstatic,
'view');
1381 if (!empty($arrayfields[
't.birthday'][
'checked'])) {
1388 if (!empty($arrayfields[
't.statut'][
'checked'])) {
1389 print
'<td class="center">'.$contactstatic->getLibStatut(5).
'</td>';
1392 if ($showuserlogin) {
1394 $tmpuser=
new User($db);
1395 $resfetch = $tmpuser->fetch(0,
'',
'', 0, -1,
'', $contactstatic->id);
1396 if ($resfetch > 0) {
1397 print $tmpuser->getNomUrl(1,
'', 0, 0, 24, 1);
1403 $extrafieldsobjectkey = $contactstatic->table_element;
1404 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1407 print
'<td align="right">';
1410 if (
isModEnabled(
'agenda')&& $user->hasRight(
'agenda',
'myactions',
'create')) {
1411 print
'<a href="'.DOL_URL_ROOT.
'/comm/action/card.php?action=create&actioncode=&contactid='.$obj->rowid.
'&socid='.$object->id.
'&backtopage='.urlencode($backtopage).
'">';
1412 print
img_object($langs->trans(
"Event"),
"action");
1413 print
'</a> ';
1417 if ($user->hasRight(
'societe',
'contact',
'creer')) {
1418 print
'<a class="editfielda paddingleft" href="'.DOL_URL_ROOT.
'/contact/card.php?action=edit&token='.
newToken().
'&id='.$obj->rowid.
'&backtopage='.urlencode($backtopage).
'">';
1430 $colspan = 1 + ($showuserlogin ? 1 : 0);
1431 foreach ($arrayfields as $key => $val) {
1432 if (!empty($val[
'checked'])) {
1436 print
'<tr><td colspan="'.$colspan.
'" class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</td></tr>';
1439 $colspan = 1 + ($showuserlogin ? 1 : 0);
1440 foreach ($arrayfields as $key => $val) {
1441 if (!empty($val[
'checked'])) {
1445 print
'<tr><td colspan="'.$colspan.
'" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';
1447 print
"\n</table>\n";
1450 print
'</form>'.
"\n";
1468 function show_actions_todo($conf, $langs, $db, $filterobj, $objcon =
'', $noprint = 0, $actioncode =
'')
1470 global $user, $conf;
1472 $out =
show_actions_done($conf, $langs, $db, $filterobj, $objcon, 1, $actioncode,
'todo');
1499 function show_actions_done($conf, $langs, $db, $filterobj, $objcon =
'', $noprint = 0, $actioncode =
'', $donetodo =
'done', $filters = array(), $sortfield =
'a.datep,a.id', $sortorder =
'DESC', $module =
'')
1501 global $user, $conf, $hookmanager;
1503 global $param, $massactionbutton;
1505 $start_year =
GETPOST(
'dateevent_startyear',
'int');
1506 $start_month =
GETPOST(
'dateevent_startmonth',
'int');
1507 $start_day =
GETPOST(
'dateevent_startday',
'int');
1508 $end_year =
GETPOST(
'dateevent_endyear',
'int');
1509 $end_month =
GETPOST(
'dateevent_endmonth',
'int');
1510 $end_day =
GETPOST(
'dateevent_endday',
'int');
1514 if (!empty($start_year) && !empty($start_month) && !empty($start_day)) {
1515 $tms_start =
dol_mktime(0, 0, 0, $start_month, $start_day, $start_year,
'tzuserrel');
1517 if (!empty($end_year) && !empty($end_month) && !empty($end_day)) {
1518 $tms_end =
dol_mktime(23, 59, 59, $end_month, $end_day, $end_year,
'tzuserrel');
1520 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
1527 if (!is_object($filterobj) && !is_object($objcon)) {
1537 $sortfield_list = explode(
',', $sortfield);
1538 $sortfield_label_list = array(
'a.id' =>
'id',
'a.datep' =>
'dp',
'a.percent' =>
'percent');
1539 $sortfield_new_list = array();
1540 foreach ($sortfield_list as $sortfield_value) {
1541 $sortfield_new_list[] = $sortfield_label_list[trim($sortfield_value)];
1543 $sortfield_new = implode(
',', $sortfield_new_list);
1549 $hookmanager->initHooks(array(
'agendadao'));
1552 if (is_object($objcon) && $objcon->id > 0) {
1553 $sql =
"SELECT DISTINCT a.id, a.label as label,";
1555 $sql =
"SELECT a.id, a.label as label,";
1557 $sql .=
" a.datep as dp,";
1558 $sql .=
" a.datep2 as dp2,";
1559 $sql .=
" a.percent as percent, 'action' as type,";
1560 $sql .=
" a.fk_element, a.elementtype,";
1561 $sql .=
" a.fk_contact,";
1562 $sql .=
" c.code as acode, c.libelle as alabel, c.picto as apicto,";
1563 $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";
1564 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur'))) {
1565 $sql .=
", sp.lastname, sp.firstname";
1566 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1568 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project') {
1570 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1571 $sql .=
", m.lastname, m.firstname";
1572 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1574 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1576 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1578 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1580 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1582 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && $filterobj->table_element && $filterobj->element) {
1583 if (!empty($filterobj->fields[
'ref'])) {
1585 } elseif (!empty($filterobj->fields[
'label'])) {
1586 $sql .=
", o.label";
1591 $parameters = array(
'sql' => &
$sql,
'filterobj' => $filterobj,
'objcon' => $objcon);
1592 $reshook = $hookmanager->executeHooks(
'showActionsDoneListSelect', $parameters);
1593 if (!empty($hookmanager->resPrint))
$sql.= $hookmanager->resPrint;
1595 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm as a";
1596 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u on u.rowid = a.fk_user_action";
1597 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_actioncomm as c ON a.fk_action = c.id";
1599 $force_filter_contact =
false;
1600 if (is_object($objcon) && $objcon->id > 0) {
1601 $force_filter_contact =
true;
1602 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"actioncomm_resources as r ON a.id = r.fk_actioncomm";
1603 $sql .=
" AND r.element_type = '".$db->escape($objcon->table_element).
"' AND r.fk_element = ".((int) $objcon->id);
1607 $parameters = array(
'sql' => &
$sql,
'filterobj' => $filterobj,
'objcon' => $objcon);
1608 $reshook = $hookmanager->executeHooks(
'showActionsDoneListFrom', $parameters);
1609 if (!empty($hookmanager->resPrint))
$sql.= $hookmanager->resPrint;
1611 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur'))) {
1612 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople as sp ON a.fk_contact = sp.rowid";
1613 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1614 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"element_resources as er";
1615 $sql .=
" ON er.resource_type = 'dolresource'";
1616 $sql .=
" AND er.element_id = a.id";
1617 $sql .=
" AND er.resource_id = ".((int) $filterobj->id);
1618 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project') {
1620 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1621 $sql .=
", ".MAIN_DB_PREFIX.
"adherent as m";
1622 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1623 $sql .=
", ".MAIN_DB_PREFIX.
"commande_fournisseur as o";
1624 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1625 $sql .=
", ".MAIN_DB_PREFIX.
"product as o";
1626 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1627 $sql .=
", ".MAIN_DB_PREFIX.
"ticket as o";
1628 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1629 $sql .=
", ".MAIN_DB_PREFIX.
"bom_bom as o";
1630 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1631 $sql .=
", ".MAIN_DB_PREFIX.
"contrat as o";
1632 } 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) {
1633 $sql .=
", ".MAIN_DB_PREFIX.$filterobj->table_element.
" as o";
1636 $sql .=
" WHERE a.entity IN (".getEntity(
'agenda').
")";
1637 if ($force_filter_contact ===
false) {
1638 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur')) && $filterobj->id) {
1639 $sql .=
" AND a.fk_soc = ".((int) $filterobj->id);
1640 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1642 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project' && $filterobj->id) {
1643 $sql .=
" AND a.fk_project = ".((int) $filterobj->id);
1644 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1645 $sql .=
" AND a.fk_element = m.rowid AND a.elementtype = 'member'";
1646 if ($filterobj->id) {
1647 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1649 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Commande') {
1650 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'order'";
1651 if ($filterobj->id) {
1652 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1654 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1655 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'order_supplier'";
1656 if ($filterobj->id) {
1657 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1659 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Facture') {
1660 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'invoice'";
1661 if ($filterobj->id) {
1662 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1664 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1665 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'product'";
1666 if ($filterobj->id) {
1667 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1669 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1670 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'ticket'";
1671 if ($filterobj->id) {
1672 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1674 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1675 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'bom'";
1676 if ($filterobj->id) {
1677 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1679 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1680 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'contract'";
1681 if ($filterobj->id) {
1682 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1684 } 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) {
1686 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = '".$db->escape($filterobj->element).($module ?
"@".$module :
"").
"'";
1687 if ($filterobj->id) {
1688 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1693 if (!empty($tms_start) && !empty($tms_end)) {
1694 $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).
"'))";
1695 } elseif (empty($tms_start) && !empty($tms_end)) {
1696 $sql .=
" AND ((a.datep <= '".$db->idate($tms_end).
"') OR (a.datep2 <= '".$db->idate($tms_end).
"'))";
1697 } elseif (!empty($tms_start) && empty($tms_end)) {
1698 $sql .=
" AND ((a.datep >= '".$db->idate($tms_start).
"') OR (a.datep2 >= '".$db->idate($tms_start).
"'))";
1701 if (is_array($actioncode) && !empty($actioncode)) {
1703 foreach ($actioncode as $key => $code) {
1707 if (!empty($code)) {
1715 } elseif (!empty($actioncode)) {
1722 $parameters = array(
'sql' => &
$sql,
'filterobj' => $filterobj,
'objcon' => $objcon,
'module' => $module);
1723 $reshook = $hookmanager->executeHooks(
'showActionsDoneListWhere', $parameters);
1724 if (!empty($hookmanager->resPrint))
$sql.= $hookmanager->resPrint;
1726 if (is_array($actioncode)) {
1727 foreach ($actioncode as $code) {
1729 if (!empty($sql2)) {
1732 } elseif (empty(
$sql)) {
1740 if (!empty(
$sql) && !empty($sql2)) {
1742 } elseif (empty(
$sql) && !empty($sql2)) {
1750 $sql .= $db->order($sortfield_new, $sortorder);
1752 dol_syslog(
"company.lib::show_actions_done", LOG_DEBUG);
1754 $resql = $db->query(
$sql);
1757 $num = $db->num_rows($resql);
1760 $obj = $db->fetch_object($resql);
1762 if ($obj->type ==
'action') {
1764 $contactaction->id = $obj->id;
1765 $result = $contactaction->fetchResources();
1768 setEventMessage(
"company.lib::show_actions_done Error fetch ressource",
'errors');
1774 if (($obj->percent >= 0 and $obj->percent < 100) || ($obj->percent == -1 && (!empty($obj->datep) && $obj->datep > $now))) {
1778 $histo[$numaction] = array(
1780 'tododone'=>$tododone,
1782 'datestart'=>$db->jdate($obj->dp),
1783 'dateend'=>$db->jdate($obj->dp2),
1784 'note'=>$obj->label,
1785 'percent'=>$obj->percent,
1787 'userid'=>$obj->user_id,
1788 'login'=>$obj->user_login,
1789 'userfirstname'=>$obj->user_firstname,
1790 'userlastname'=>$obj->user_lastname,
1791 'userphoto'=>$obj->user_photo,
1793 'contact_id'=>$obj->fk_contact,
1794 'socpeopleassigned' => $contactaction->socpeopleassigned,
1795 'lastname' => empty($obj->lastname) ?
'' : $obj->lastname,
1796 'firstname' => empty($obj->firstname) ?
'' : $obj->firstname,
1797 'fk_element'=>$obj->fk_element,
1798 'elementtype'=>$obj->elementtype,
1800 'acode'=>$obj->acode,
1801 'alabel'=>$obj->alabel,
1802 'libelle'=>$obj->alabel,
1803 'apicto'=>$obj->apicto
1806 $histo[$numaction] = array(
1810 'datestart'=>$db->jdate($obj->dp),
1811 'dateend'=>$db->jdate($obj->dp2),
1812 'note'=>$obj->label,
1813 'percent'=>$obj->percent,
1814 'acode'=>$obj->acode,
1816 'userid'=>$obj->user_id,
1817 'login'=>$obj->user_login,
1818 'userfirstname'=>$obj->user_firstname,
1819 'userlastname'=>$obj->user_lastname,
1820 'userphoto'=>$obj->user_photo
1833 $delay_warning = $conf->global->MAIN_DELAY_ACTIONS_TODO * 24 * 60 * 60;
1835 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
1836 include_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
1837 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formactions.class.php';
1838 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
1843 $userstatic =
new User($db);
1844 $userlinkcache = array();
1845 $contactstatic =
new Contact($db);
1846 $elementlinkcache = array();
1848 $out .=
'<form name="listactionsfilter" class="listactionsfilter" action="'.$_SERVER[
"PHP_SELF"].
'" method="POST">';
1849 $out .=
'<input type="hidden" name="token" value="'.newToken().
'">';
1850 if ($objcon && get_class($objcon) ==
'Contact' &&
1851 (is_null($filterobj) || get_class($filterobj) ==
'Societe')) {
1852 $out .=
'<input type="hidden" name="id" value="'.$objcon->id.
'" />';
1854 $out .=
'<input type="hidden" name="id" value="'.$filterobj->id.
'" />';
1856 if ($filterobj && get_class($filterobj) ==
'Societe') {
1857 $out .=
'<input type="hidden" name="socid" value="'.$filterobj->id.
'" />';
1862 $out .=
'<div class="div-table-responsive-no-min">';
1863 $out .=
'<table class="noborder centpercent">';
1865 $out .=
'<tr class="liste_titre">';
1867 $out .=
'<td class="liste_titre"></td>';
1870 $out .=
'<td class="liste_titre"><input type="text" class="width50" name="search_rowid" value="'.(isset($filters[
'search_rowid']) ? $filters[
'search_rowid'] :
'').
'"></td>';
1871 $out .=
'<td class="liste_titre"></td>';
1872 $out .=
'<td class="liste_titre">';
1873 $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');
1875 $out .=
'<td class="liste_titre maxwidth100onsmartphone"><input type="text" class="maxwidth100onsmartphone" name="search_agenda_label" value="'.$filters[
'search_agenda_label'].
'"></td>';
1876 $out .=
'<td class="liste_titre center">';
1877 $out .=
$form->selectDateToDate($tms_start, $tms_end,
'dateevent', 1);
1879 $out .=
'<td class="liste_titre"></td>';
1880 $out .=
'<td class="liste_titre"></td>';
1881 $out .=
'<td class="liste_titre"></td>';
1883 $out .=
'<td class="liste_titre" align="middle">';
1884 $searchpicto =
$form->showFilterAndCheckAddButtons($massactionbutton ? 1 : 0,
'checkforselect', 1);
1885 $out .= $searchpicto;
1889 $out .=
'<tr class="liste_titre">';
1892 if (get_class($filterobj) ==
'Societe') {
1893 $tmp .=
'<a href="'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&socid='.$filterobj->id.
'&status=done">';
1895 $tmp .= ($donetodo !=
'done' ? $langs->trans(
"ActionsToDoShort") :
'');
1896 $tmp .= ($donetodo !=
'done' && $donetodo !=
'todo' ?
' / ' :
'');
1897 $tmp .= ($donetodo !=
'todo' ? $langs->trans(
"ActionsDoneShort") :
'');
1899 if (get_class($filterobj) ==
'Societe') {
1904 $out .=
getTitleFieldOfList(
"Ref", 0, $_SERVER[
"PHP_SELF"],
'a.id',
'', $param,
'', $sortfield, $sortorder);
1907 $out .=
getTitleFieldOfList(
"Label", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
1908 $out .=
getTitleFieldOfList(
"Date", 0, $_SERVER[
"PHP_SELF"],
'a.datep,a.id',
'', $param,
'', $sortfield, $sortorder,
'center ');
1909 $out .=
getTitleFieldOfList(
"RelatedObjects", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
1910 $out .=
getTitleFieldOfList(
"ActionOnContact", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'tdoverflowmax125 ', 0,
'', 0);
1911 $out .=
getTitleFieldOfList(
"Status", 0, $_SERVER[
"PHP_SELF"],
'a.percent',
'', $param,
'', $sortfield, $sortorder,
'center ');
1912 $out .=
getTitleFieldOfList(
'', 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch ');
1915 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/cactioncomm.class.php';
1917 $arraylist = $caction->liste_array(1,
'code',
'', (empty($conf->global->AGENDA_USE_EVENT_TYPE) ? 1 : 0),
'', 1);
1919 foreach ($histo as $key => $value) {
1920 $actionstatic->fetch($histo[$key][
'id']);
1922 $actionstatic->type_picto = $histo[$key][
'apicto'];
1923 $actionstatic->type_code = $histo[$key][
'acode'];
1925 $out .=
'<tr class="oddeven">';
1929 $out .=
'<td class="nowrap">';
1934 $out .=
'<td class="nowraponall">';
1935 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'mailing') {
1936 $out .=
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/card.php?id='.$histo[$key][
'id'].
'">'.
img_object($langs->trans(
"ShowEMailing"),
"email").
' ';
1937 $out .= $histo[$key][
'id'];
1940 $out .= $actionstatic->getNomUrl(1, -1);
1945 $out .=
'<td class="tdoverflowmax150">';
1949 if ($histo[$key][
'userid'] > 0) {
1950 if (isset($userlinkcache[$histo[$key][
'userid']])) {
1951 $link = $userlinkcache[$histo[$key][
'userid']];
1953 $userstatic->fetch($histo[$key][
'userid']);
1954 $link = $userstatic->getNomUrl(-1,
'', 0, 0, 16, 0,
'firstelselast',
'');
1955 $userlinkcache[$histo[$key][
'userid']] = $link;
1962 $labeltype = $actionstatic->type_code;
1963 if (empty($conf->global->AGENDA_USE_EVENT_TYPE) && empty($arraylist[$labeltype])) {
1964 $labeltype =
'AC_OTH';
1966 if (preg_match(
'/^TICKET_MSG/', $actionstatic->code)) {
1967 $labeltype = $langs->trans(
"Message");
1969 if (!empty($arraylist[$labeltype])) {
1970 $labeltype = $arraylist[$labeltype];
1972 if ($actionstatic->type_code ==
'AC_OTH_AUTO' && ($actionstatic->type_code != $actionstatic->code) && $labeltype && !empty($arraylist[$actionstatic->code])) {
1973 $labeltype .=
' - '.$arraylist[$actionstatic->code];
1976 $out .=
'<td class="tdoverflowmax150" title="'.$labeltype.
'">';
1977 $out .= $actionstatic->getTypePicto();
1982 $out .=
'<td class="tdoverflowmax300"';
1983 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'action') {
1984 $transcode = $langs->trans(
"Action".$histo[$key][
'acode']);
1985 $libelle = ($transcode !=
"Action".$histo[$key][
'acode'] ? $transcode : $histo[$key][
'alabel']);
1987 $libelle = $histo[$key][
'note'];
1988 $actionstatic->id = $histo[$key][
'id'];
1989 $out .=
' title="'.dol_escape_htmltag($libelle).
'">';
1992 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'mailing') {
1993 $out .=
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/card.php?id='.$histo[$key][
'id'].
'">'.
img_object($langs->trans(
"ShowEMailing"),
"email").
' ';
1994 $transcode = $langs->trans(
"Action".$histo[$key][
'acode']);
1995 $libelle = ($transcode !=
"Action".$histo[$key][
'acode'] ? $transcode :
'Send mass mailing');
1996 $out .=
' title="'.dol_escape_htmltag($libelle).
'">';
2002 $out .=
'<td class="center nowraponall">';
2003 $out .=
dol_print_date($histo[$key][
'datestart'],
'dayhour',
'tzuserrel');
2004 if ($histo[$key][
'dateend'] && $histo[$key][
'dateend'] != $histo[$key][
'datestart']) {
2005 $tmpa =
dol_getdate($histo[$key][
'datestart'],
true);
2006 $tmpb =
dol_getdate($histo[$key][
'dateend'],
true);
2007 if ($tmpa[
'mday'] == $tmpb[
'mday'] && $tmpa[
'mon'] == $tmpb[
'mon'] && $tmpa[
'year'] == $tmpb[
'year']) {
2008 $out .=
'-'.dol_print_date($histo[$key][
'dateend'],
'hour',
'tzuserrel');
2010 $out .=
'-'.dol_print_date($histo[$key][
'dateend'],
'dayhour',
'tzuserrel');
2014 if ($histo[$key][
'percent'] == 0 && $histo[$key][
'datestart'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
2017 if ($histo[$key][
'percent'] == 0 && !$histo[$key][
'datestart'] && $histo[$key][
'dateend'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
2020 if ($histo[$key][
'percent'] > 0 && $histo[$key][
'percent'] < 100 && $histo[$key][
'dateend'] && $histo[$key][
'dateend'] < ($now - $delay_warning)) {
2023 if ($histo[$key][
'percent'] > 0 && $histo[$key][
'percent'] < 100 && !$histo[$key][
'dateend'] && $histo[$key][
'datestart'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
2035 $out .=
'<td class="nowraponall">';
2036 if (isset($histo[$key][
'elementtype']) && !empty($histo[$key][
'fk_element'])) {
2037 if (isset($elementlinkcache[$histo[$key][
'elementtype']]) && isset($elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']])) {
2038 $link = $elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']];
2040 if (!isset($elementlinkcache[$histo[$key][
'elementtype']])) {
2041 $elementlinkcache[$histo[$key][
'elementtype']] = array();
2043 $link =
dolGetElementUrl($histo[$key][
'fk_element'], $histo[$key][
'elementtype'], 1);
2044 $elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']] = $link;
2053 if (isset($histo[$key][
'socpeopleassigned']) && is_array($histo[$key][
'socpeopleassigned']) && count($histo[$key][
'socpeopleassigned']) > 0) {
2054 $out .=
'<td class="valignmiddle">';
2056 foreach ($histo[$key][
'socpeopleassigned'] as $cid => $cvalue) {
2057 $result = $contact->fetch($cid);
2064 $out .= $contact->getNomUrl(-3,
'', 10,
'', -1, 0,
'paddingright');
2065 if (isset($histo[$key][
'acode']) && $histo[$key][
'acode'] ==
'AC_TEL') {
2066 if (!empty($contact->phone_pro)) {
2067 $out .=
'('.dol_print_phone($contact->phone_pro).
')';
2070 $out .=
'<div class="paddingright"></div>';
2074 } elseif (empty($objcon->id) && isset($histo[$key][
'contact_id']) && $histo[$key][
'contact_id'] > 0) {
2075 $contactstatic->lastname = $histo[$key][
'lastname'];
2076 $contactstatic->firstname = $histo[$key][
'firstname'];
2077 $contactstatic->id = $histo[$key][
'contact_id'];
2078 $contactstatic->photo = $histo[$key][
'contact_photo'];
2079 $out .=
'<td width="120">'.$contactstatic->getNomUrl(-1,
'', 10).
'</td>';
2081 $out .=
'<td> </td>';
2085 $out .=
'<td class="nowrap center">'.$actionstatic->LibStatut($histo[$key][
'percent'], 2, 0, $histo[$key][
'datestart']).
'</td>';
2088 $out .=
'<td></td>';
2093 if (empty($histo)) {
2095 $out .=
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
2098 $out .=
"</table>\n";
2126 $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";
2127 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
2128 $sql .=
" WHERE s.parent = ".((int) $object->id);
2129 $sql .=
" AND s.entity IN (".getEntity(
'societe').
")";
2130 $sql .=
" ORDER BY s.nom";
2132 $result = $db->query(
$sql);
2133 $num = $db->num_rows($result);
2136 $socstatic =
new Societe($db);
2140 print
"\n".
'<div class="div-table-responsive-no-min">'.
"\n";
2141 print
'<table class="noborder centpercent">'.
"\n";
2143 print
'<tr class="liste_titre"><td>'.$langs->trans(
"Company").
'</td>';
2144 print
'<td>'.$langs->trans(
"Address").
'</td><td>'.$langs->trans(
"Zip").
'</td>';
2145 print
'<td>'.$langs->trans(
"Town").
'</td><td>'.$langs->trans(
"CustomerCode").
'</td>';
2146 print
"<td> </td>";
2152 $obj = $db->fetch_object($result);
2154 $socstatic->id = $obj->rowid;
2155 $socstatic->name = $obj->name;
2156 $socstatic->name_alias = $obj->name_alias;
2157 $socstatic->email = $obj->email;
2158 $socstatic->code_client = $obj->code_client;
2159 $socstatic->code_fournisseur = $obj->code_client;
2160 $socstatic->code_compta = $obj->code_compta;
2161 $socstatic->code_compta_fournisseur = $obj->code_compta_fournisseur;
2162 $socstatic->email = $obj->email;
2163 $socstatic->canvas = $obj->canvas;
2164 $socstatic->client = $obj->client;
2165 $socstatic->fournisseur = $obj->fournisseur;
2167 print
'<tr class="oddeven">';
2169 print
'<td class="tdoverflowmax150">';
2170 print $socstatic->getNomUrl(1);
2173 print
'<td class="tdoverflowmax400" title="'.dol_escape_htmltag($obj->address).
'">'.
dol_escape_htmltag($obj->address).
'</td>';
2174 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->zip).
'">'.$obj->zip.
'</td>';
2175 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->town).
'">'.$obj->town.
'</td>';
2176 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->code_client).
'">'.$obj->code_client.
'</td>';
2178 print
'<td class="center">';
2179 print
'<a class="editfielda" href="'.DOL_URL_ROOT.
'/societe/card.php?socid='.((int) $obj->rowid).
'&action=edit&token='.
newToken().
'">';
2186 print
"\n</table>\n";
2187 print
'</div>'.
"\n";
2207 if (empty($conf->global->AGENDA_USE_EVENT_TYPE)) {
2208 if ($actioncode ==
'AC_NON_AUTO') {
2209 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2210 } elseif ($actioncode ==
'AC_ALL_AUTO') {
2211 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2213 if ($actioncode ==
'AC_OTH') {
2214 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2215 } elseif ($actioncode ==
'AC_OTH_AUTO') {
2216 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2220 if ($actioncode ==
'AC_NON_AUTO') {
2221 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2222 } elseif ($actioncode ==
'AC_ALL_AUTO') {
2223 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2225 $sql .=
" $sqlANDOR c.code = '".$db->escape($actioncode).
"'";
2245 if ($donetodo ==
'todo') {
2246 $sql .=
" AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep > '".$db->idate($now).
"'))";
2247 } elseif ($donetodo ==
'done') {
2248 $sql .=
" AND (a.percent = 100 OR (a.percent = -1 AND a.datep <= '".$db->idate($now).
"'))";
2250 if (is_array($filters) && !empty($filters[
'search_agenda_label'])) {
2253 if (is_array($filters) && !empty($filters[
'search_rowid'])) {
2273 if (
isModEnabled(
'mailing') && !empty($objcon->email) && (empty($actioncode) || $actioncode ==
'AC_OTH_AUTO' || $actioncode ==
'AC_EMAILING')) {
2274 $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";
2275 $sql2 .=
", null as fk_element, '' as elementtype, null as contact_id";
2276 $sql2 .=
", 'AC_EMAILING' as acode, '' as alabel, '' as apicto";
2277 $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";
2278 if (is_object($filterobj) && get_class($filterobj) ==
'Societe') {
2279 $sql2 .=
", '' as lastname, '' as firstname";
2280 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
2281 $sql2 .=
", '' as lastname, '' as firstname";
2282 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
2283 $sql2 .=
", '' as ref";
2284 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
2285 $sql2 .=
", '' as ref";
2286 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
2287 $sql2 .=
", '' as ref";
2289 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"mailing as m, ".MAIN_DB_PREFIX.
"mailing_cibles as mc, ".MAIN_DB_PREFIX.
"user as u";
2290 $sql2 .=
" WHERE mc.email = '".$db->escape($objcon->email).
"'";
2291 $sql2 .=
" AND mc.statut = 1";
2292 $sql2 .=
" AND u.rowid = m.fk_user_valid";
2293 $sql2 .=
" AND mc.fk_mailing=m.rowid";
2321 if ($fromcompany->forme_juridique_code) {
2325 if ($fromcompany->capital) {
2326 $line1 .= ($line1 ?
" - " :
"").$langs->transnoentities(
"CapitalOf", $fromcompany->capital).
" ".$langs->transnoentities(
"Currency".$conf->currency);
2329 if ($fromcompany->idprof1 && ($fromcompany->country_code !=
'FR' || !$fromcompany->idprof2)) {
2330 $field = $langs->transcountrynoentities(
"ProfId1", $fromcompany->country_code);
2331 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2334 $line1 .= ($line1 ?
" - " :
"").$field.
": ".$fromcompany->idprof1;
2337 if ($fromcompany->idprof2) {
2338 $field = $langs->transcountrynoentities(
"ProfId2", $fromcompany->country_code);
2339 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2342 $line1 .= ($line1 ?
" - " :
"").$field.
": ".$fromcompany->idprof2;
2348 if ($fromcompany->idprof3) {
2349 $field = $langs->transcountrynoentities(
"ProfId3", $fromcompany->country_code);
2350 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2353 $line2 .= ($line2 ?
" - " :
"").$field.
": ".$fromcompany->idprof3;
2356 if ($fromcompany->idprof4) {
2357 $field = $langs->transcountrynoentities(
"ProfId4", $fromcompany->country_code);
2358 if (preg_match(
'/\((.*)\)/i', $field, $reg)) {
2361 $line2 .= ($line2 ?
" - " :
"").$field.
": ".$fromcompany->idprof4;
2364 if ($fromcompany->tva_intra !=
'') {
2365 $line2 .= ($line2 ?
" - " :
"").$langs->transnoentities(
"VATIntraShort").
": ".$fromcompany->tva_intra;
2368 print
'<!-- htmlPrintOnlinePaymentFooter -->'.
"\n";
2370 print
'<footer class="center paddingleft paddingright opacitymedium">'.
"\n";
2372 if ($addformmessage) {
2373 print
'<!-- object = '.(empty($object) ?
'undefined' : $object->element).
' -->';
2376 $parammessageform =
'ONLINE_PAYMENT_MESSAGE_FORM_'.$suffix;
2377 if (!empty($conf->global->$parammessageform)) {
2378 print $langs->transnoentities($conf->global->$parammessageform);
2379 } elseif (!empty($conf->global->ONLINE_PAYMENT_MESSAGE_FORM)) {
2380 print $langs->transnoentities($conf->global->ONLINE_PAYMENT_MESSAGE_FORM);
2384 if (!empty($object->total_vat) || !empty($object->total_tva)) {
2385 $parammessageform =
'ONLINE_PAYMENT_MESSAGE_FORMIFVAT_'.$suffix;
2386 if (!empty($conf->global->$parammessageform)) {
2387 print $langs->transnoentities($conf->global->$parammessageform);
2388 } elseif (!empty($conf->global->ONLINE_PAYMENT_MESSAGE_FORMIFVAT)) {
2389 print $langs->transnoentities($conf->global->ONLINE_PAYMENT_MESSAGE_FORMIFVAT);
2394 print
'<span style="font-size: 10px;"><br><hr>'.
"\n";
2395 print $fromcompany->name.
'<br>';
2397 if (strlen($line1.$line2) > 50) {
2404 print
'</footer>'.
"\n";