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;
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;
131 if ((
isModEnabled(
'fournisseur') && empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD)) || !empty($conf->supplier_proposal->enabled) || !empty($conf->supplier_order->enabled) || !empty($conf->supplier_invoice->enabled)) {
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 (!empty($conf->project->enabled) && (!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)) && (!empty($user->rights->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.
'/societe/partnership.php?socid='.$object->id;
271 $head[$h][1] = $langs->trans(
"Partnership");
272 $head[$h][2] =
'partnership';
273 if ($nbPartnership > 0) {
274 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbPartnership.
'</span>';
286 if ($user->socid == 0) {
291 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
292 $cachekey =
'count_notifications_thirdparty_'.$object->id;
294 if (!is_null($dataretrieved)) {
295 $nbNotif = $dataretrieved;
297 $sql =
"SELECT COUNT(n.rowid) as nb";
298 $sql .=
" FROM ".MAIN_DB_PREFIX.
"notify_def as n";
299 $sql .=
" WHERE fk_soc = ".((int) $object->id);
300 $resql = $db->query($sql);
302 $obj = $db->fetch_object(
$resql);
310 $head[$h][0] = DOL_URL_ROOT.
'/societe/notify/card.php?socid='.urlencode($object->id);
311 $head[$h][1] = $langs->trans(
"Notifications");
313 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNotif.
'</span>';
315 $head[$h][2] =
'notify';
321 if (!empty($object->note_private)) {
324 if (!empty($object->note_public)) {
327 $head[$h][0] = DOL_URL_ROOT.
'/societe/note.php?id='.urlencode($object->id);
328 $head[$h][1] = $langs->trans(
"Notes");
330 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
332 $head[$h][2] =
'note';
338 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
339 $cachekey =
'count_attached_thirdparty_'.$object->id;
341 if (!is_null($dataretrieved)) {
342 $totalAttached = $dataretrieved;
344 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
345 require_once DOL_DOCUMENT_ROOT.
'/core/class/link.class.php';
346 $upload_dir = $conf->societe->multidir_output[$object->entity].
"/".$object->id;
347 $nbFiles = count(
dol_dir_list($upload_dir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
348 $nbLinks =
Link::count($db, $object->element, $object->id);
349 $totalAttached = $nbFiles + $nbLinks;
353 $head[$h][0] = DOL_URL_ROOT.
'/societe/document.php?socid='.$object->id;
354 $head[$h][1] = $langs->trans(
"Documents");
355 if (($totalAttached) > 0) {
356 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.($totalAttached).
'</span>';
358 $head[$h][2] =
'document';
362 $head[$h][0] = DOL_URL_ROOT.
'/societe/agenda.php?socid='.$object->id;
363 $head[$h][1] = $langs->trans(
"Events");
364 if (
isModEnabled(
'agenda')&& (!empty($user->rights->agenda->myactions->read) || !empty($user->rights->agenda->allactions->read))) {
367 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
368 $cachekey =
'count_events_thirdparty_'.$object->id;
370 if (!is_null($dataretrieved)) {
371 $nbEvent = $dataretrieved;
373 $sql =
"SELECT COUNT(id) as nb";
374 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm";
375 $sql .=
" WHERE fk_soc = ".((int) $object->id);
376 $resql = $db->query($sql);
378 $obj = $db->fetch_object(
$resql);
381 dol_syslog(
'Failed to count actioncomm '.$db->lasterror(), LOG_ERR);
387 $head[$h][1] .= $langs->trans(
"Agenda");
389 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbEvent.
'</span>';
392 $head[$h][2] =
'agenda';
415 global $langs, $conf, $user;
419 $head[$h][0] = DOL_URL_ROOT.
'/societe/card.php?socid='.$object->id;
420 $head[$h][1] = $langs->trans(
"ThirdParty");
421 $head[$h][2] =
'company';
424 $head[$h][0] =
'commerciaux.php?socid='.$object->id;
425 $head[$h][1] = $langs->trans(
"SalesRepresentative");
426 $head[$h][2] =
'salesrepresentative';
441 global $langs, $conf, $user;
446 $head[$h][0] = DOL_URL_ROOT.
'/societe/admin/societe.php';
447 $head[$h][1] = $langs->trans(
"Miscellaneous");
448 $head[$h][2] =
'general';
457 $head[$h][0] = DOL_URL_ROOT.
'/societe/admin/societe_extrafields.php';
458 $head[$h][1] = $langs->trans(
"ExtraFieldsThirdParties");
459 $head[$h][2] =
'attributes';
462 $head[$h][0] = DOL_URL_ROOT.
'/societe/admin/contact_extrafields.php';
463 $head[$h][1] = $langs->trans(
"ExtraFieldsContacts");
464 $head[$h][2] =
'attributes_contacts';
489 function getCountry($searchkey, $withcode =
'', $dbtouse = 0, $outputlangs =
'', $entconv = 1, $searchlabel =
'')
496 if (empty($searchkey) && empty($searchlabel)) {
497 if ($withcode ===
'all') {
498 return array(
'id'=>
'',
'code'=>
'',
'label'=>
'');
503 if (!is_object($dbtouse)) {
506 if (!is_object($outputlangs)) {
507 $outputlangs = $langs;
510 $sql =
"SELECT rowid, code, label FROM ".MAIN_DB_PREFIX.
"c_country";
511 if (is_numeric($searchkey)) {
512 $sql .=
" WHERE rowid = ".((int) $searchkey);
513 } elseif (!empty($searchkey)) {
514 $sql .=
" WHERE code = '".$db->escape($searchkey).
"'";
516 $sql .=
" WHERE label = '".$db->escape($searchlabel).
"'";
519 $resql = $dbtouse->query($sql);
521 $obj = $dbtouse->fetch_object(
$resql);
523 $label = ((!empty($obj->label) && $obj->label !=
'-') ? $obj->label :
'');
524 if (is_object($outputlangs)) {
525 $outputlangs->load(
"dict");
527 $label = ($obj->code && ($outputlangs->trans(
"Country".$obj->code) !=
"Country".$obj->code)) ? $outputlangs->trans(
"Country".$obj->code) : $label;
529 $label = ($obj->code && ($outputlangs->transnoentitiesnoconv(
"Country".$obj->code) !=
"Country".$obj->code)) ? $outputlangs->transnoentitiesnoconv(
"Country".$obj->code) : $label;
532 if ($withcode == 1) {
533 $result = $label ?
"$obj->code - $label" :
"$obj->code";
534 } elseif ($withcode == 2) {
535 $result = $obj->code;
536 } elseif ($withcode == 3) {
537 $result = $obj->rowid;
538 } elseif ($withcode ===
'all') {
539 $result = array(
'id'=>$obj->rowid,
'code'=>$obj->code,
'label'=>$label);
544 $result =
'NotDefined';
569 function getState($id, $withcode =
'', $dbtouse = 0, $withregion = 0, $outputlangs =
'', $entconv = 1)
573 if (!is_object($dbtouse)) {
577 $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";
578 $sql .=
" ".MAIN_DB_PREFIX.
"c_departements as d, ".MAIN_DB_PREFIX.
"c_regions as r,".MAIN_DB_PREFIX.
"c_country as c";
579 $sql .=
" WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=".((int) $id);
580 $sql .=
" AND d.active = 1 AND r.active = 1 AND c.active = 1";
581 $sql .=
" ORDER BY c.code, d.code_departement";
583 dol_syslog(
"Company.lib::getState", LOG_DEBUG);
584 $resql = $dbtouse->query($sql);
586 $obj = $dbtouse->fetch_object(
$resql);
588 $label = ((!empty($obj->name) && $obj->name !=
'-') ? $obj->name :
'');
589 if (is_object($outputlangs)) {
590 $outputlangs->load(
"dict");
592 $label = ($obj->code && ($outputlangs->trans(
"State".$obj->code) !=
"State".$obj->code)) ? $outputlangs->trans(
"State".$obj->code) : $label;
594 $label = ($obj->code && ($outputlangs->transnoentitiesnoconv(
"State".$obj->code) !=
"State".$obj->code)) ? $outputlangs->transnoentitiesnoconv(
"State".$obj->code) : $label;
598 if ($withcode == 1) {
599 if ($withregion == 1) {
600 return $label = $obj->region_name.
' - '.$obj->code.
' - '.($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
602 return $label = $obj->code.
' - '.($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
604 } elseif ($withcode == 2) {
605 if ($withregion == 1) {
606 return $label = $obj->region_name.
' - '.($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
608 return $label = ($langs->trans($obj->code) != $obj->code ? $langs->trans($obj->code) : ($obj->name !=
'-' ? $obj->name :
''));
610 } elseif ($withcode ===
'all') {
611 if ($withregion == 1) {
612 return array(
'id'=>$obj->id,
'code'=>$obj->code,
'label'=>$label,
'region_code'=>$obj->region_code,
'region'=>$obj->region_name);
614 return array(
'id'=>$obj->id,
'code'=>$obj->code,
'label'=>$label);
617 if ($withregion == 1) {
618 return $label = $obj->region_name.
' - '.$label;
624 return $langs->transnoentitiesnoconv(
"NotDefined");
643 if (empty($outputlangs)) {
644 $outputlangs = $langs;
647 $outputlangs->load(
"dict");
650 if ($outputlangs->trans(
"Currency".$code_iso) !=
"Currency".$code_iso) {
651 return ($withcode ? $code_iso.
' - ' :
'').$outputlangs->trans(
"Currency".$code_iso);
655 $sql =
"SELECT label FROM ".MAIN_DB_PREFIX.
"c_currencies";
656 $sql .=
" WHERE code_iso='".$db->escape($code_iso).
"'";
658 $resql = $db->query($sql);
660 $num = $db->num_rows(
$resql);
663 $obj = $db->fetch_object(
$resql);
664 $label = ($obj->label !=
'-' ? $obj->label :
'');
666 return ($label == $code_iso) ?
"$code_iso" :
"$code_iso - $label";
674 return 'ErrorWhenReadingCurrencyLabel';
691 $sql =
"SELECT libelle FROM ".MAIN_DB_PREFIX.
"c_forme_juridique";
692 $sql .=
" WHERE code='".$db->escape($code).
"'";
694 dol_syslog(
"Company.lib::getFormeJuridiqueLabel", LOG_DEBUG);
695 $resql = $db->query($sql);
697 $num = $db->num_rows(
$resql);
700 $obj = $db->fetch_object(
$resql);
701 $label = ($obj->libelle !=
'-' ? $obj->libelle :
'');
704 return $langs->trans(
"NotDefined");
721 $country_code_in_EEC = array();
723 if (!empty($conf->cache[
'country_code_in_EEC'])) {
725 $country_code_in_EEC = $conf->cache[
'country_code_in_EEC'];
727 $sql =
"SELECT cc.code FROM ".MAIN_DB_PREFIX.
"c_country as cc";
728 $sql .=
" WHERE cc.eec = 1";
730 $resql = $db->query($sql);
732 $num = $db->num_rows(
$resql);
735 $objp = $db->fetch_object(
$resql);
736 $country_code_in_EEC[] = $objp->code;
742 $conf->cache[
'country_code_in_EEC'] = $country_code_in_EEC;
744 return $country_code_in_EEC;
755 if (empty($object->country_code)) {
762 return in_array($object->country_code, $country_code_in_EEC);
778 function show_projects($conf, $langs, $db, $object, $backtopage =
'', $nocreatelink = 0, $morehtmlright =
'')
780 global $user, $action, $hookmanager;
784 if (!empty($conf->project->enabled) && $user->rights->projet->lire) {
785 $langs->load(
"projects");
788 if (!empty($conf->project->enabled) && $user->rights->projet->creer && empty($nocreatelink)) {
789 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'AddProject'),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/projet/card.php?socid='.$object->id.
'&action=create&backtopage='.urlencode($backtopage));
793 print
load_fiche_titre($langs->trans(
"ProjectsDedicatedToThisThirdParty"), $newcardbutton.$morehtmlright,
'');
795 print
'<div class="div-table-responsive">'.
"\n";
796 print
'<table class="noborder centpercent">';
798 $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";
799 $sql .=
", cls.code as opp_status_code";
800 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
801 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_lead_status as cls on p.fk_opp_status = cls.rowid";
802 $sql .=
" WHERE p.fk_soc = ".((int) $object->id);
803 $sql .=
" AND p.entity IN (".getEntity(
'project').
")";
804 $sql .=
" ORDER BY p.dateo DESC";
806 $result = $db->query($sql);
808 $num = $db->num_rows($result);
810 print
'<tr class="liste_titre">';
811 print
'<td>'.$langs->trans(
"Ref").
'</td>';
812 print
'<td>'.$langs->trans(
"Name").
'</td>';
813 print
'<td class="center">'.$langs->trans(
"DateStart").
'</td>';
814 print
'<td class="center">'.$langs->trans(
"DateEnd").
'</td>';
815 print
'<td class="right">'.$langs->trans(
"OpportunityAmountShort").
'</td>';
816 print
'<td class="center">'.$langs->trans(
"OpportunityStatusShort").
'</td>';
817 print
'<td class="right">'.$langs->trans(
"OpportunityProbabilityShort").
'</td>';
818 print
'<td class="right">'.$langs->trans(
"Status").
'</td>';
822 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
824 $projecttmp =
new Project($db);
829 $obj = $db->fetch_object($result);
830 $projecttmp->fetch($obj->id);
833 $userAccess = $projecttmp->restrictedProjectArea($user);
835 if ($user->rights->projet->lire && $userAccess > 0) {
836 print
'<tr class="oddeven">';
839 print
'<td class="nowraponall">';
840 print $projecttmp->getNomUrl(1);
844 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->title).
'">'.
dol_escape_htmltag($obj->title).
'</td>';
846 print
'<td class="center">'.dol_print_date($db->jdate($obj->do),
"day").
'</td>';
848 print
'<td class="center">'.dol_print_date($db->jdate($obj->de),
"day").
'</td>';
850 print
'<td class="right">';
851 if ($obj->opp_status_code) {
852 print
price($obj->opp_amount, 1,
'', 1, -1, -1,
'');
856 print
'<td class="center">';
857 if ($obj->opp_status_code) {
858 print $langs->trans(
"OppStatus".$obj->opp_status_code);
862 print
'<td class="right">';
863 if ($obj->opp_percent) {
864 print
price($obj->opp_percent, 1,
'', 1, 0).
'%';
868 print
'<td class="right">'.$projecttmp->getLibStatut(5).
'</td>';
875 print
'<tr class="oddeven"><td colspan="8"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
882 $parameters = array(
'sql'=>$sql,
'function'=>
'show_projects');
883 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
884 print $hookmanager->resPrint;
907 function show_contacts($conf, $langs, $db, $object, $backtopage =
'', $showuserlogin = 0)
909 global $user, $conf, $extrafields, $hookmanager;
912 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
916 $optioncss =
GETPOST(
'optioncss',
'alpha');
917 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
918 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
921 $search_status =
GETPOST(
"search_status",
'int');
922 if ($search_status ==
'') {
926 $search_name =
GETPOST(
"search_name",
'alpha');
927 $search_address =
GETPOST(
"search_address",
'alpha');
928 $search_poste =
GETPOST(
"search_poste",
'alpha');
929 $search_roles =
GETPOST(
"search_roles",
'array');
933 $searchAddressPhoneDBFields = array(
961 $sortfield =
"t.lastname";
964 if (!empty($conf->clicktodial->enabled)) {
965 $user->fetch_clicktodial();
969 $contactstatic =
new Contact($db);
971 $extrafields->fetch_name_optionals_label($contactstatic->table_element);
973 $contactstatic->fields = array(
974 'name' =>array(
'type'=>
'varchar(128)',
'label'=>
'Name',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>1,
'index'=>1,
'position'=>10,
'searchall'=>1),
975 'poste' =>array(
'type'=>
'varchar(128)',
'label'=>
'PostOrFunction',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>2,
'index'=>1,
'position'=>20),
976 'address' =>array(
'type'=>
'varchar(128)',
'label'=>
'Address',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>3,
'index'=>1,
'position'=>30),
977 'role' =>array(
'type'=>
'checkbox',
'label'=>
'Role',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'showoncombobox'=>4,
'index'=>1,
'position'=>40),
978 '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))),
982 $arrayfields = array(
983 '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),
984 't.name'=>array(
'label'=>
"Name",
'checked'=>1,
'position'=>10),
985 't.poste'=>array(
'label'=>
"PostOrFunction",
'checked'=>1,
'position'=>20),
986 '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),
987 'sc.role'=>array(
'label'=>
"ContactByDefaultFor",
'checked'=>1,
'position'=>40),
988 't.statut'=>array(
'label'=>
"Status",
'checked'=>1,
'position'=>50,
'class'=>
'center'),
991 if (!empty($extrafields->attributes[$contactstatic->table_element][
'label']) && is_array($extrafields->attributes[$contactstatic->table_element][
'label']) && count($extrafields->attributes[$contactstatic->table_element][
'label'])) {
992 foreach ($extrafields->attributes[$contactstatic->table_element][
'label'] as $key => $val) {
993 if (!empty($extrafields->attributes[$contactstatic->table_element][
'list'][$key])) {
994 $arrayfields[
"ef.".$key] = array(
995 'label'=>$extrafields->attributes[$contactstatic->table_element][
'label'][$key],
996 'checked'=>(($extrafields->attributes[$contactstatic->table_element][
'list'][$key] < 0) ? 0 : 1),
997 'position'=>1000 + $extrafields->attributes[$contactstatic->table_element][
'pos'][$key],
998 'enabled'=>(abs($extrafields->attributes[$contactstatic->table_element][
'list'][$key]) != 3 && $extrafields->attributes[$contactstatic->table_element][
'perms'][$key]));
1005 foreach ($arrayfields as $key => $val) {
1006 $queryName =
'search_'.substr($key, 2);
1007 if (
GETPOST($queryName,
'alpha')) {
1008 $search[substr($key, 2)] =
GETPOST($queryName,
'alpha');
1011 $search_array_options = $extrafields->getOptionalsFromPost($contactstatic->table_element,
'',
'search_');
1014 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
1015 $search_status =
'';
1017 $search_roles = array();
1018 $search_address =
'';
1021 $search_array_options = array();
1023 foreach ($contactstatic->fields as $key => $val) {
1028 $contactstatic->fields =
dol_sort_array($contactstatic->fields,
'position');
1031 $newcardbutton =
'';
1032 if ($user->rights->societe->contact->creer) {
1033 $addcontact = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"AddContact") : $langs->trans(
"AddContactAddress"));
1034 $newcardbutton .=
dolGetButtonTitle($addcontact,
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/contact/card.php?socid='.$object->id.
'&action=create&backtopage='.urlencode($backtopage));
1039 $title = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"ContactsForCompany") : $langs->trans(
"ContactsAddressesForCompany"));
1042 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'" name="formfilter">';
1043 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1044 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1045 print
'<input type="hidden" name="socid" value="'.$object->id.
'">';
1046 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1047 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1048 print
'<input type="hidden" name="page" value="'.$page.
'">';
1050 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1051 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
1054 print
'<div class="div-table-responsive">';
1055 print
"\n".
'<table class="tagtable liste">'.
"\n";
1057 $param =
"socid=".urlencode($object->id);
1058 if ($search_status !=
'') {
1059 $param .=
'&search_status='.urlencode($search_status);
1061 if (count($search_roles) > 0) {
1062 $param .= implode(
'&search_roles[]=', $search_roles);
1064 if ($search_name !=
'') {
1065 $param .=
'&search_name='.urlencode($search_name);
1067 if ($search_poste !=
'') {
1068 $param .=
'&search_poste='.urlencode($search_poste);
1070 if ($search_address !=
'') {
1071 $param .=
'&search_address='.urlencode($search_address);
1073 if ($optioncss !=
'') {
1074 $param .=
'&optioncss='.urlencode($optioncss);
1078 $extrafieldsobjectkey = $contactstatic->table_element;
1079 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1081 $sql =
"SELECT t.rowid, t.entity, t.lastname, t.firstname, t.fk_pays as country_id, t.civility, t.poste, t.phone as phone_pro, t.phone_mobile, t.phone_perso, t.fax, t.email, t.socialnetworks, t.statut, t.photo,";
1082 $sql .=
" t.civility as civility_id, t.address, t.zip, t.town";
1083 $sql .=
" FROM ".MAIN_DB_PREFIX.
"socpeople as t";
1084 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople_extrafields as ef on (t.rowid = ef.fk_object)";
1085 $sql .=
" WHERE t.fk_soc = ".((int) $object->id);
1086 if ($search_status !=
'' && $search_status !=
'-1') {
1087 $sql .=
" AND t.statut = ".((int) $search_status);
1090 $sql .=
natural_search(array(
't.lastname',
't.firstname'), $search_name);
1092 if ($search_poste) {
1095 if ($search_address) {
1096 $sql .=
natural_search($searchAddressPhoneDBFields, $search_address);
1098 if (count($search_roles) > 0) {
1099 $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)).
"))";
1102 $extrafieldsobjectkey = $contactstatic->table_element;
1103 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1105 $parameters = array(
'socid' => $object->id);
1106 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object);
1107 $sql .= $hookmanager->resPrint;
1108 if ($sortfield ==
"t.name") {
1109 $sql .=
" ORDER BY t.lastname $sortorder, t.firstname $sortorder";
1111 $sql .=
" ORDER BY $sortfield $sortorder";
1114 dol_syslog(
'core/lib/company.lib.php :: show_contacts', LOG_DEBUG);
1115 $result = $db->query($sql);
1120 $num = $db->num_rows($result);
1124 print
'<tr class="liste_titre">';
1125 foreach ($contactstatic->fields as $key => $val) {
1127 if (in_array($val[
'type'], array(
'date',
'datetime',
'timestamp'))) {
1128 $align .= ($align ?
' ' :
'').
'center';
1130 if (in_array($val[
'type'], array(
'timestamp'))) {
1131 $align .= ($align ?
' ' :
'').
'nowrap';
1133 if ($key ==
'status' || $key ==
'statut') {
1134 $align .= ($align ?
' ' :
'').
'center';
1136 if (!empty($arrayfields[
't.'.$key][
'checked']) || !empty($arrayfields[
'sc.'.$key][
'checked'])) {
1137 print
'<td class="liste_titre'.($align ?
' '.$align :
'').
'">';
1138 if (in_array($key, array(
'statut'))) {
1139 print
$form->selectarray(
'search_status', array(
'-1'=>
'',
'0'=>$contactstatic->LibStatut(0, 1),
'1'=>$contactstatic->LibStatut(1, 1)), $search_status);
1140 } elseif (in_array($key, array(
'role'))) {
1141 print $formcompany->showRoles(
"search_roles", $contactstatic,
'edit', $search_roles,
'minwidth200 maxwidth300');
1143 print
'<input type="text" class="flat maxwidth75" name="search_'.$key.
'" value="'.(!empty($search[$key]) ?
dol_escape_htmltag($search[$key]) :
'').
'">';
1148 if ($showuserlogin) {
1152 $extrafieldsobjectkey = $contactstatic->table_element;
1153 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
1156 $parameters = array(
'arrayfields'=>$arrayfields);
1157 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $contactstatic);
1158 print $hookmanager->resPrint;
1160 print
'<td class="liste_titre" align="right">';
1161 print
$form->showFilterButtons();
1168 print
'<tr class="liste_titre">';
1169 foreach ($contactstatic->fields as $key => $val) {
1171 if (in_array($val[
'type'], array(
'date',
'datetime',
'timestamp'))) {
1172 $align .= ($align ?
' ' :
'').
'center';
1174 if (in_array($val[
'type'], array(
'timestamp'))) {
1175 $align .= ($align ?
' ' :
'').
'nowrap';
1177 if ($key ==
'status' || $key ==
'statut') {
1178 $align .= ($align ?
' ' :
'').
'center';
1180 if (!empty($arrayfields[
't.'.$key][
'checked'])) {
1181 print
getTitleFieldOfList($val[
'label'], 0, $_SERVER[
'PHP_SELF'],
't.'.$key,
'', $param, ($align ?
'class="'.$align.
'"' :
''), $sortfield, $sortorder, $align.
' ').
"\n";
1183 if ($key ==
'role') {
1184 $align .= ($align ?
' ' :
'').
'left';
1186 if (!empty($arrayfields[
'sc.'.$key][
'checked'])) {
1187 print
getTitleFieldOfList($arrayfields[
'sc.'.$key][
'label'], 0, $_SERVER[
'PHP_SELF'],
'',
'', $param, ($align ?
'class="'.$align.
'"' :
''), $sortfield, $sortorder, $align.
' ').
"\n";
1190 if ($showuserlogin) {
1191 print
'<td>'.$langs->trans(
"DolibarrLogin").
'</td>';
1194 $extrafieldsobjectkey = $contactstatic->table_element;
1195 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
1197 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
1198 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object);
1199 print $hookmanager->resPrint;
1200 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ').
"\n";
1205 if ($num || (
GETPOST(
'button_search') ||
GETPOST(
'button_search.x') ||
GETPOST(
'button_search_x'))) {
1209 $obj = $db->fetch_object($result);
1211 $contactstatic->id = $obj->rowid;
1212 $contactstatic->ref = $obj->rowid;
1213 $contactstatic->statut = $obj->statut;
1214 $contactstatic->lastname = $obj->lastname;
1215 $contactstatic->firstname = $obj->firstname;
1216 $contactstatic->civility_id = $obj->civility_id;
1217 $contactstatic->civility_code = $obj->civility_id;
1218 $contactstatic->poste = $obj->poste;
1219 $contactstatic->address = $obj->address;
1220 $contactstatic->zip = $obj->zip;
1221 $contactstatic->town = $obj->town;
1222 $contactstatic->phone_pro = $obj->phone_pro;
1223 $contactstatic->phone_mobile = $obj->phone_mobile;
1224 $contactstatic->phone_perso = $obj->phone_perso;
1225 $contactstatic->email = $obj->email;
1226 $contactstatic->socialnetworks = $obj->socialnetworks;
1227 $contactstatic->photo = $obj->photo;
1228 $contactstatic->entity = $obj->entity;
1230 $country_code =
getCountry($obj->country_id, 2);
1231 $contactstatic->country_code = $country_code;
1233 $contactstatic->setGenderFromCivility();
1234 $contactstatic->fetch_optionals();
1236 $resultRole = $contactstatic->fetchRoles();
1237 if ($resultRole < 0) {
1241 if (is_array($contactstatic->array_options)) {
1242 foreach ($contactstatic->array_options as $key => $val) {
1247 print
'<tr class="oddeven">';
1250 if (!empty($arrayfields[
't.rowid'][
'checked'])) {
1252 print $contactstatic->id;
1257 if (!empty($arrayfields[
't.name'][
'checked'])) {
1259 print
$form->showphoto(
'contact', $contactstatic, 0, 0, 0,
'photorefnoborder valignmiddle marginrightonly',
'small', 1, 0, 1);
1260 print $contactstatic->getNomUrl(0,
'', 0,
'&backtopage='.urlencode($backtopage));
1265 if (!empty($arrayfields[
't.poste'][
'checked'])) {
1274 if (!empty($arrayfields[
't.address'][
'checked'])) {
1276 print $contactstatic->getBannerAddress(
'contact', $object);
1281 if (!empty($arrayfields[
'sc.role'][
'checked'])) {
1283 print $formcompany->showRoles(
"roles", $contactstatic,
'view');
1288 if (!empty($arrayfields[
't.statut'][
'checked'])) {
1289 print
'<td class="center">'.$contactstatic->getLibStatut(5).
'</td>';
1292 if ($showuserlogin) {
1294 $tmpuser=
new User($db);
1295 $resfetch = $tmpuser->fetch(0,
'',
'', 0, -1,
'', $contactstatic->id);
1296 if ($resfetch > 0) {
1297 print $tmpuser->getNomUrl(1,
'', 0, 0, 24, 1);
1303 $extrafieldsobjectkey = $contactstatic->table_element;
1304 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1307 print
'<td align="right">';
1310 if (
isModEnabled(
'agenda')&& $user->rights->agenda->myactions->create) {
1311 print
'<a href="'.DOL_URL_ROOT.
'/comm/action/card.php?action=create&actioncode=&contactid='.$obj->rowid.
'&socid='.$object->id.
'&backtopage='.urlencode($backtopage).
'">';
1312 print
img_object($langs->trans(
"Event"),
"action");
1313 print
'</a> ';
1317 if ($user->rights->societe->contact->creer) {
1318 print
'<a class="editfielda paddingleft" href="'.DOL_URL_ROOT.
'/contact/card.php?action=edit&token='.
newToken().
'&id='.$obj->rowid.
'&backtopage='.urlencode($backtopage).
'">';
1330 foreach ($arrayfields as $key => $val) {
1331 if (!empty($val[
'checked'])) {
1335 print
'<tr><td colspan="'.$colspan.
'" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';
1337 print
"\n</table>\n";
1340 print
'</form>'.
"\n";
1358 function show_actions_todo($conf, $langs, $db, $filterobj, $objcon =
'', $noprint = 0, $actioncode =
'')
1360 global $user, $conf;
1362 $out =
show_actions_done($conf, $langs, $db, $filterobj, $objcon, 1, $actioncode,
'todo');
1389 function show_actions_done($conf, $langs, $db, $filterobj, $objcon =
'', $noprint = 0, $actioncode =
'', $donetodo =
'done', $filters = array(), $sortfield =
'a.datep,a.id', $sortorder =
'DESC', $module =
'')
1391 global $user, $conf;
1393 global $param, $massactionbutton;
1395 $start_year =
GETPOST(
'dateevent_startyear',
'int');
1396 $start_month =
GETPOST(
'dateevent_startmonth',
'int');
1397 $start_day =
GETPOST(
'dateevent_startday',
'int');
1398 $end_year =
GETPOST(
'dateevent_endyear',
'int');
1399 $end_month =
GETPOST(
'dateevent_endmonth',
'int');
1400 $end_day =
GETPOST(
'dateevent_endday',
'int');
1404 if (!empty($start_year) && !empty($start_month) && !empty($start_day)) {
1405 $tms_start =
dol_mktime(0, 0, 0, $start_month, $start_day, $start_year,
'tzuserrel');
1407 if (!empty($end_year) && !empty($end_month) && !empty($end_day)) {
1408 $tms_end =
dol_mktime(23, 59, 59, $end_month, $end_day, $end_year,
'tzuserrel');
1410 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
1417 if (!is_object($filterobj) && !is_object($objcon)) {
1427 $sortfield_list = explode(
',', $sortfield);
1428 $sortfield_label_list = array(
'a.id' =>
'id',
'a.datep' =>
'dp',
'a.percent' =>
'percent');
1429 $sortfield_new_list = array();
1430 foreach ($sortfield_list as $sortfield_value) {
1431 $sortfield_new_list[] = $sortfield_label_list[trim($sortfield_value)];
1433 $sortfield_new = implode(
',', $sortfield_new_list);
1439 if (is_object($objcon) && $objcon->id > 0) {
1440 $sql =
"SELECT DISTINCT a.id, a.label as label,";
1442 $sql =
"SELECT a.id, a.label as label,";
1444 $sql .=
" a.datep as dp,";
1445 $sql .=
" a.datep2 as dp2,";
1446 $sql .=
" a.percent as percent, 'action' as type,";
1447 $sql .=
" a.fk_element, a.elementtype,";
1448 $sql .=
" a.fk_contact,";
1449 $sql .=
" c.code as acode, c.libelle as alabel, c.picto as apicto,";
1450 $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";
1451 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur'))) {
1452 $sql .=
", sp.lastname, sp.firstname";
1453 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1455 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project') {
1457 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1458 $sql .=
", m.lastname, m.firstname";
1459 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1461 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1463 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1465 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1467 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1469 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && $filterobj->table_element && $filterobj->element) {
1470 if (!empty($filterobj->fields[
'ref'])) {
1472 } elseif (!empty($filterobj->fields[
'label'])) {
1473 $sql .=
", o.label";
1477 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm as a";
1478 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u on u.rowid = a.fk_user_action";
1479 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_actioncomm as c ON a.fk_action = c.id";
1481 $force_filter_contact =
false;
1482 if (is_object($objcon) && $objcon->id > 0) {
1483 $force_filter_contact =
true;
1484 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"actioncomm_resources as r ON a.id = r.fk_actioncomm";
1485 $sql .=
" AND r.element_type = '".$db->escape($objcon->table_element).
"' AND r.fk_element = ".((int) $objcon->id);
1488 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur'))) {
1489 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople as sp ON a.fk_contact = sp.rowid";
1490 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1491 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"element_resources as er";
1492 $sql .=
" ON er.resource_type = 'dolresource'";
1493 $sql .=
" AND er.element_id = a.id";
1494 $sql .=
" AND er.resource_id = ".((int) $filterobj->id);
1495 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project') {
1497 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1498 $sql .=
", ".MAIN_DB_PREFIX.
"adherent as m";
1499 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1500 $sql .=
", ".MAIN_DB_PREFIX.
"commande_fournisseur as o";
1501 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1502 $sql .=
", ".MAIN_DB_PREFIX.
"product as o";
1503 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1504 $sql .=
", ".MAIN_DB_PREFIX.
"ticket as o";
1505 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1506 $sql .=
", ".MAIN_DB_PREFIX.
"bom_bom as o";
1507 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1508 $sql .=
", ".MAIN_DB_PREFIX.
"contrat as o";
1509 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && (is_array($filterobj->fields[
'ref']) || is_array($filterobj->fields[
'label'])) && $filterobj->table_element && $filterobj->element) {
1510 $sql .=
", ".MAIN_DB_PREFIX.$filterobj->table_element.
" as o";
1513 $sql .=
" WHERE a.entity IN (".getEntity(
'agenda').
")";
1514 if ($force_filter_contact ===
false) {
1515 if (is_object($filterobj) && in_array(get_class($filterobj), array(
'Societe',
'Client',
'Fournisseur')) && $filterobj->id) {
1516 $sql .=
" AND a.fk_soc = ".((int) $filterobj->id);
1517 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Dolresource') {
1519 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Project' && $filterobj->id) {
1520 $sql .=
" AND a.fk_project = ".((int) $filterobj->id);
1521 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
1522 $sql .=
" AND a.fk_element = m.rowid AND a.elementtype = 'member'";
1523 if ($filterobj->id) {
1524 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1526 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
1527 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'order_supplier'";
1528 if ($filterobj->id) {
1529 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1531 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
1532 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'product'";
1533 if ($filterobj->id) {
1534 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1536 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
1537 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'ticket'";
1538 if ($filterobj->id) {
1539 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1541 } elseif (is_object($filterobj) && get_class($filterobj) ==
'BOM') {
1542 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'bom'";
1543 if ($filterobj->id) {
1544 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1546 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Contrat') {
1547 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = 'contract'";
1548 if ($filterobj->id) {
1549 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1551 } elseif (is_object($filterobj) && is_array($filterobj->fields) && is_array($filterobj->fields[
'rowid']) && (is_array($filterobj->fields[
'ref']) || is_array($filterobj->fields[
'label'])) && $filterobj->table_element && $filterobj->element) {
1553 $sql .=
" AND a.fk_element = o.rowid AND a.elementtype = '".$db->escape($filterobj->element).($module ?
"@".$module :
"").
"'";
1554 if ($filterobj->id) {
1555 $sql .=
" AND a.fk_element = ".((int) $filterobj->id);
1560 if (!empty($tms_start) && !empty($tms_end)) {
1561 $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).
"'))";
1562 } elseif (empty($tms_start) && !empty($tms_end)) {
1563 $sql .=
" AND ((a.datep <= '".$db->idate($tms_end).
"') OR (a.datep2 <= '".$db->idate($tms_end).
"'))";
1564 } elseif (!empty($tms_start) && empty($tms_end)) {
1565 $sql .=
" AND ((a.datep >= '".$db->idate($tms_start).
"') OR (a.datep2 >= '".$db->idate($tms_start).
"'))";
1568 if (is_array($actioncode) && !empty($actioncode)) {
1570 foreach ($actioncode as $key => $code) {
1574 if (!empty($code)) {
1582 } elseif (!empty($actioncode)) {
1588 if (is_array($actioncode)) {
1589 foreach ($actioncode as $code) {
1591 if (!empty($sql2)) {
1593 $sql = $sql.
" UNION ".$sql2;
1594 } elseif (empty($sql)) {
1602 if (!empty($sql) && !empty($sql2)) {
1603 $sql = $sql.
" UNION ".$sql2;
1604 } elseif (empty($sql) && !empty($sql2)) {
1612 $sql .= $db->order($sortfield_new, $sortorder);
1613 dol_syslog(
"company.lib::show_actions_done", LOG_DEBUG);
1614 $resql = $db->query($sql);
1617 $num = $db->num_rows(
$resql);
1620 $obj = $db->fetch_object(
$resql);
1622 if ($obj->type ==
'action') {
1624 $contactaction->id = $obj->id;
1625 $result = $contactaction->fetchResources();
1628 setEventMessage(
"company.lib::show_actions_done Error fetch ressource",
'errors');
1634 if (($obj->percent >= 0 and $obj->percent < 100) || ($obj->percent == -1 && (!empty($obj->datep) && $obj->datep > $now))) {
1638 $histo[$numaction] = array(
1640 'tododone'=>$tododone,
1642 'datestart'=>$db->jdate($obj->dp),
1643 'dateend'=>$db->jdate($obj->dp2),
1644 'note'=>$obj->label,
1645 'percent'=>$obj->percent,
1647 'userid'=>$obj->user_id,
1648 'login'=>$obj->user_login,
1649 'userfirstname'=>$obj->user_firstname,
1650 'userlastname'=>$obj->user_lastname,
1651 'userphoto'=>$obj->user_photo,
1653 'contact_id'=>$obj->fk_contact,
1654 'socpeopleassigned' => $contactaction->socpeopleassigned,
1655 'lastname' => empty($obj->lastname) ?
'' : $obj->lastname,
1656 'firstname' => empty($obj->firstname) ?
'' : $obj->firstname,
1657 'fk_element'=>$obj->fk_element,
1658 'elementtype'=>$obj->elementtype,
1660 'acode'=>$obj->acode,
1661 'alabel'=>$obj->alabel,
1662 'libelle'=>$obj->alabel,
1663 'apicto'=>$obj->apicto
1666 $histo[$numaction] = array(
1670 'datestart'=>$db->jdate($obj->dp),
1671 'dateend'=>$db->jdate($obj->dp2),
1672 'note'=>$obj->label,
1673 'percent'=>$obj->percent,
1674 'acode'=>$obj->acode,
1676 'userid'=>$obj->user_id,
1677 'login'=>$obj->user_login,
1678 'userfirstname'=>$obj->user_firstname,
1679 'userlastname'=>$obj->user_lastname,
1680 'userphoto'=>$obj->user_photo
1693 $delay_warning = $conf->global->MAIN_DELAY_ACTIONS_TODO * 24 * 60 * 60;
1695 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
1696 include_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
1697 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formactions.class.php';
1698 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
1703 $userstatic =
new User($db);
1704 $userlinkcache = array();
1705 $contactstatic =
new Contact($db);
1706 $elementlinkcache = array();
1708 $out .=
'<form name="listactionsfilter" class="listactionsfilter" action="'.$_SERVER[
"PHP_SELF"].
'" method="POST">';
1709 $out .=
'<input type="hidden" name="token" value="'.newToken().
'">';
1710 if ($objcon && get_class($objcon) ==
'Contact' &&
1711 (is_null($filterobj) || get_class($filterobj) ==
'Societe')) {
1712 $out .=
'<input type="hidden" name="id" value="'.$objcon->id.
'" />';
1714 $out .=
'<input type="hidden" name="id" value="'.$filterobj->id.
'" />';
1716 if ($filterobj && get_class($filterobj) ==
'Societe') {
1717 $out .=
'<input type="hidden" name="socid" value="'.$filterobj->id.
'" />';
1722 $out .=
'<div class="div-table-responsive-no-min">';
1723 $out .=
'<table class="noborder centpercent">';
1725 $out .=
'<tr class="liste_titre">';
1727 $out .=
'<td class="liste_titre"></td>';
1729 $out .=
'<td class="liste_titre"></td>';
1730 $out .=
'<td class="liste_titre"></td>';
1731 $out .=
'<td class="liste_titre">';
1732 $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,
'minwidth200');
1734 $out .=
'<td class="liste_titre maxwidth100onsmartphone"><input type="text" class="maxwidth100onsmartphone" name="search_agenda_label" value="'.$filters[
'search_agenda_label'].
'"></td>';
1735 $out .=
'<td class="liste_titre center">';
1736 $out .=
$form->selectDateToDate($tms_start, $tms_end,
'dateevent', 1);
1738 $out .=
'<td class="liste_titre"></td>';
1739 $out .=
'<td class="liste_titre"></td>';
1740 $out .=
'<td class="liste_titre"></td>';
1742 $out .=
'<td class="liste_titre" align="middle">';
1743 $searchpicto =
$form->showFilterAndCheckAddButtons($massactionbutton ? 1 : 0,
'checkforselect', 1);
1744 $out .= $searchpicto;
1748 $out .=
'<tr class="liste_titre">';
1751 if (get_class($filterobj) ==
'Societe') {
1752 $tmp .=
'<a href="'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&socid='.$filterobj->id.
'&status=done">';
1754 $tmp .= ($donetodo !=
'done' ? $langs->trans(
"ActionsToDoShort") :
'');
1755 $tmp .= ($donetodo !=
'done' && $donetodo !=
'todo' ?
' / ' :
'');
1756 $tmp .= ($donetodo !=
'todo' ? $langs->trans(
"ActionsDoneShort") :
'');
1758 if (get_class($filterobj) ==
'Societe') {
1763 $out .=
getTitleFieldOfList(
"Ref", 0, $_SERVER[
"PHP_SELF"],
'a.id',
'', $param,
'', $sortfield, $sortorder);
1766 $out .=
getTitleFieldOfList(
"Label", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
1767 $out .=
getTitleFieldOfList(
"Date", 0, $_SERVER[
"PHP_SELF"],
'a.datep,a.id',
'', $param,
'', $sortfield, $sortorder,
'center ');
1768 $out .=
getTitleFieldOfList(
"RelatedObjects", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
1769 $out .=
getTitleFieldOfList(
"ActionOnContact", 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'tdoverflowmax125 ', 0,
'', 0);
1770 $out .=
getTitleFieldOfList(
"Status", 0, $_SERVER[
"PHP_SELF"],
'a.percent',
'', $param,
'', $sortfield, $sortorder,
'center ');
1771 $out .=
getTitleFieldOfList(
'', 0, $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch ');
1774 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/cactioncomm.class.php';
1776 $arraylist = $caction->liste_array(1,
'code',
'', (empty($conf->global->AGENDA_USE_EVENT_TYPE) ? 1 : 0),
'', 1);
1778 foreach ($histo as $key => $value) {
1779 $actionstatic->fetch($histo[$key][
'id']);
1781 $actionstatic->type_picto = $histo[$key][
'apicto'];
1782 $actionstatic->type_code = $histo[$key][
'acode'];
1784 $out .=
'<tr class="oddeven">';
1788 $out .=
'<td class="nowrap">';
1793 $out .=
'<td class="nowraponall">';
1794 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'mailing') {
1795 $out .=
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/card.php?id='.$histo[$key][
'id'].
'">'.
img_object($langs->trans(
"ShowEMailing"),
"email").
' ';
1796 $out .= $histo[$key][
'id'];
1799 $out .= $actionstatic->getNomUrl(1, -1);
1804 $out .=
'<td class="tdoverflowmax150">';
1808 if ($histo[$key][
'userid'] > 0) {
1809 if (isset($userlinkcache[$histo[$key][
'userid']])) {
1810 $link = $userlinkcache[$histo[$key][
'userid']];
1812 $userstatic->fetch($histo[$key][
'userid']);
1813 $link = $userstatic->getNomUrl(-1,
'', 0, 0, 16, 0,
'firstelselast',
'');
1814 $userlinkcache[$histo[$key][
'userid']] = $link;
1821 $labeltype = $actionstatic->type_code;
1822 if (empty($conf->global->AGENDA_USE_EVENT_TYPE) && empty($arraylist[$labeltype])) {
1823 $labeltype =
'AC_OTH';
1825 if ($actionstatic->type_code ==
'AC_OTH' && $actionstatic->code ==
'TICKET_MSG') {
1826 $labeltype = $langs->trans(
"Message");
1828 if (!empty($arraylist[$labeltype])) {
1829 $labeltype = $arraylist[$labeltype];
1831 if ($actionstatic->type_code ==
'AC_OTH_AUTO' && ($actionstatic->type_code != $actionstatic->code) && $labeltype && !empty($arraylist[$actionstatic->code])) {
1832 $labeltype .=
' - '.$arraylist[$actionstatic->code];
1835 $out .=
'<td class="tdoverflowmax150" title="'.$labeltype.
'">';
1836 $out .= $actionstatic->getTypePicto();
1841 $out .=
'<td class="tdoverflowmax300"';
1842 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'action') {
1843 $transcode = $langs->trans(
"Action".$histo[$key][
'acode']);
1844 $libelle = ($transcode !=
"Action".$histo[$key][
'acode'] ? $transcode : $histo[$key][
'alabel']);
1846 $libelle = $histo[$key][
'note'];
1847 $actionstatic->id = $histo[$key][
'id'];
1848 $out .=
' title="'.dol_escape_htmltag($libelle).
'">';
1851 if (isset($histo[$key][
'type']) && $histo[$key][
'type'] ==
'mailing') {
1852 $out .=
'<a href="'.DOL_URL_ROOT.
'/comm/mailing/card.php?id='.$histo[$key][
'id'].
'">'.
img_object($langs->trans(
"ShowEMailing"),
"email").
' ';
1853 $transcode = $langs->trans(
"Action".$histo[$key][
'acode']);
1854 $libelle = ($transcode !=
"Action".$histo[$key][
'acode'] ? $transcode :
'Send mass mailing');
1855 $out .=
' title="'.dol_escape_htmltag($libelle).
'">';
1861 $out .=
'<td class="center nowrap">';
1862 $out .=
dol_print_date($histo[$key][
'datestart'],
'dayhour',
'tzuserrel');
1863 if ($histo[$key][
'dateend'] && $histo[$key][
'dateend'] != $histo[$key][
'datestart']) {
1864 $tmpa =
dol_getdate($histo[$key][
'datestart'],
true);
1865 $tmpb =
dol_getdate($histo[$key][
'dateend'],
true);
1866 if ($tmpa[
'mday'] == $tmpb[
'mday'] && $tmpa[
'mon'] == $tmpb[
'mon'] && $tmpa[
'year'] == $tmpb[
'year']) {
1867 $out .=
'-'.dol_print_date($histo[$key][
'dateend'],
'hour',
'tzuserrel');
1869 $out .=
'-'.dol_print_date($histo[$key][
'dateend'],
'dayhour',
'tzuserrel');
1873 if ($histo[$key][
'percent'] == 0 && $histo[$key][
'datestart'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
1876 if ($histo[$key][
'percent'] == 0 && !$histo[$key][
'datestart'] && $histo[$key][
'dateend'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
1879 if ($histo[$key][
'percent'] > 0 && $histo[$key][
'percent'] < 100 && $histo[$key][
'dateend'] && $histo[$key][
'dateend'] < ($now - $delay_warning)) {
1882 if ($histo[$key][
'percent'] > 0 && $histo[$key][
'percent'] < 100 && !$histo[$key][
'dateend'] && $histo[$key][
'datestart'] && $histo[$key][
'datestart'] < ($now - $delay_warning)) {
1894 $out .=
'<td class="nowraponall">';
1895 if (isset($histo[$key][
'elementtype']) && !empty($histo[$key][
'fk_element'])) {
1896 if (isset($elementlinkcache[$histo[$key][
'elementtype']]) && isset($elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']])) {
1897 $link = $elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']];
1899 if (!isset($elementlinkcache[$histo[$key][
'elementtype']])) {
1900 $elementlinkcache[$histo[$key][
'elementtype']] = array();
1902 $link =
dolGetElementUrl($histo[$key][
'fk_element'], $histo[$key][
'elementtype'], 1);
1903 $elementlinkcache[$histo[$key][
'elementtype']][$histo[$key][
'fk_element']] = $link;
1912 if (isset($histo[$key][
'socpeopleassigned']) && is_array($histo[$key][
'socpeopleassigned']) && count($histo[$key][
'socpeopleassigned']) > 0) {
1913 $out .=
'<td class="valignmiddle">';
1915 foreach ($histo[$key][
'socpeopleassigned'] as $cid => $value) {
1916 $result = $contact->fetch($cid);
1923 $out .= $contact->getNomUrl(-3,
'', 10,
'', -1, 0,
'paddingright');
1924 if (isset($histo[$key][
'acode']) && $histo[$key][
'acode'] ==
'AC_TEL') {
1925 if (!empty($contact->phone_pro)) {
1926 $out .=
'('.dol_print_phone($contact->phone_pro).
')';
1929 $out .=
'<div class="paddingright"></div>';
1933 } elseif (empty($objcon->id) && isset($histo[$key][
'contact_id']) && $histo[$key][
'contact_id'] > 0) {
1934 $contactstatic->lastname = $histo[$key][
'lastname'];
1935 $contactstatic->firstname = $histo[$key][
'firstname'];
1936 $contactstatic->id = $histo[$key][
'contact_id'];
1937 $contactstatic->photo = $histo[$key][
'contact_photo'];
1938 $out .=
'<td width="120">'.$contactstatic->getNomUrl(-1,
'', 10).
'</td>';
1940 $out .=
'<td> </td>';
1944 $out .=
'<td class="nowrap center">'.$actionstatic->LibStatut($histo[$key][
'percent'], 2, 0, $histo[$key][
'datestart']).
'</td>';
1947 $out .=
'<td></td>';
1952 $out .=
"</table>\n";
1980 $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";
1981 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
1982 $sql .=
" WHERE s.parent = ".((int) $object->id);
1983 $sql .=
" AND s.entity IN (".getEntity(
'societe').
")";
1984 $sql .=
" ORDER BY s.nom";
1986 $result = $db->query($sql);
1987 $num = $db->num_rows($result);
1990 $socstatic =
new Societe($db);
1994 print
"\n".
'<div class="div-table-responsive-no-min">'.
"\n";
1995 print
'<table class="noborder centpercent">'.
"\n";
1997 print
'<tr class="liste_titre"><td>'.$langs->trans(
"Company").
'</td>';
1998 print
'<td>'.$langs->trans(
"Address").
'</td><td>'.$langs->trans(
"Zip").
'</td>';
1999 print
'<td>'.$langs->trans(
"Town").
'</td><td>'.$langs->trans(
"CustomerCode").
'</td>';
2000 print
"<td> </td>";
2006 $obj = $db->fetch_object($result);
2008 $socstatic->id = $obj->rowid;
2009 $socstatic->name = $obj->name;
2010 $socstatic->name_alias = $obj->name_alias;
2011 $socstatic->email = $obj->email;
2012 $socstatic->code_client = $obj->code_client;
2013 $socstatic->code_fournisseur = $obj->code_client;
2014 $socstatic->code_compta = $obj->code_compta;
2015 $socstatic->code_compta_fournisseur = $obj->code_compta_fournisseur;
2016 $socstatic->email = $obj->email;
2017 $socstatic->canvas = $obj->canvas;
2018 $socstatic->client = $obj->client;
2019 $socstatic->fournisseur = $obj->fournisseur;
2021 print
'<tr class="oddeven">';
2023 print
'<td class="tdoverflowmax150">';
2024 print $socstatic->getNomUrl(1);
2027 print
'<td class="tdoverflowmax400" title="'.dol_escape_htmltag($obj->address).
'">'.
dol_escape_htmltag($obj->address).
'</td>';
2028 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->zip).
'">'.$obj->zip.
'</td>';
2029 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->town).
'">'.$obj->town.
'</td>';
2030 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->code_client).
'">'.$obj->code_client.
'</td>';
2032 print
'<td class="center">';
2033 print
'<a class="editfielda" href="'.DOL_URL_ROOT.
'/societe/card.php?socid='.((int) $obj->rowid).
'&action=edit&token='.
newToken().
'">';
2040 print
"\n</table>\n";
2041 print
'</div>'.
"\n";
2061 if (empty($conf->global->AGENDA_USE_EVENT_TYPE)) {
2062 if ($actioncode ==
'AC_NON_AUTO') {
2063 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2064 } elseif ($actioncode ==
'AC_ALL_AUTO') {
2065 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2067 if ($actioncode ==
'AC_OTH') {
2068 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2069 } elseif ($actioncode ==
'AC_OTH_AUTO') {
2070 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2074 if ($actioncode ==
'AC_NON_AUTO') {
2075 $sql .=
" $sqlANDOR c.type != 'systemauto'";
2076 } elseif ($actioncode ==
'AC_ALL_AUTO') {
2077 $sql .=
" $sqlANDOR c.type = 'systemauto'";
2079 $sql .=
" $sqlANDOR c.code = '".$db->escape($actioncode).
"'";
2100 if ($donetodo ==
'todo') {
2101 $sql .=
" AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep > '".$db->idate($now).
"'))";
2102 } elseif ($donetodo ==
'done') {
2103 $sql .=
" AND (a.percent = 100 OR (a.percent = -1 AND a.datep <= '".$db->idate($now).
"'))";
2105 if (is_array($filters) && $filters[
'search_agenda_label']) {
2106 $sql .=
natural_search(
'a.label', $filters[
'search_agenda_label']);
2122 global $conf, $langs, $db;
2125 && (empty($actioncode) || $actioncode ==
'AC_OTH_AUTO' || $actioncode ==
'AC_EMAILING')) {
2126 $langs->load(
"mails");
2128 $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";
2129 $sql2 .=
", null as fk_element, '' as elementtype, null as contact_id";
2130 $sql2 .=
", 'AC_EMAILING' as acode, '' as alabel, '' as apicto";
2131 $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";
2132 if (is_object($filterobj) && get_class($filterobj) ==
'Societe') {
2133 $sql2 .=
", '' as lastname, '' as firstname";
2134 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Adherent') {
2135 $sql2 .=
", '' as lastname, '' as firstname";
2136 } elseif (is_object($filterobj) && get_class($filterobj) ==
'CommandeFournisseur') {
2137 $sql2 .=
", '' as ref";
2138 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Product') {
2139 $sql2 .=
", '' as ref";
2140 } elseif (is_object($filterobj) && get_class($filterobj) ==
'Ticket') {
2141 $sql2 .=
", '' as ref";
2143 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"mailing as m, ".MAIN_DB_PREFIX.
"mailing_cibles as mc, ".MAIN_DB_PREFIX.
"user as u";
2144 $sql2 .=
" WHERE mc.email = '".$db->escape($objcon->email).
"'";
2145 $sql2 .=
" AND mc.statut = 1";
2146 $sql2 .=
" AND u.rowid = m.fk_user_valid";
2147 $sql2 .=
" AND mc.fk_mailing=m.rowid";