print '<td align="center">'; print $companystatic->getLibProspLevel(); print "</td>"; } if (!empty($arrayfields['s.fk_stcomm']['checked'])) { // Prospect status print '<td align="center" class="nowrap"><div class="nowrap">'; print '<div class="inline-block">' . $companystatic->LibProspCommStatut($obj->stcomm_id, 2, $prospectstatic->cacheprospectstatus[$obj->stcomm_id]['label']); print '</div> - <div class="inline-block">'; foreach ($prospectstatic->cacheprospectstatus as $key => $val) { $titlealt = 'default'; if (!empty($val['code']) && !in_array($val['code'], array('ST_NO', 'ST_NEVER', 'ST_TODO', 'ST_PEND', 'ST_DONE'))) { $titlealt = $val['label']; } if ($obj->stcomm_id != $val['id']) { print '<a class="pictosubstatus" href="' . $_SERVER["PHP_SELF"] . '?stcommsocid=' . $obj->rowid . '&stcomm=' . $val['code'] . '&action=setstcomm' . $param . ($page ? '&page=' . urlencode($page) : '') . '">' . img_action($titlealt, $val['code']) . '</a>'; } } print '</div></div></td>'; } // Extra fields if (is_array($extrafields->attribute_label) && count($extrafields->attribute_label)) { foreach ($extrafields->attribute_label as $key => $val) { if (!empty($arrayfields["ef." . $key]['checked'])) { print '<td'; $align = $extrafields->getAlignFlag($key); if ($align) { print ' align="' . $align . '"'; } print '>'; $tmpkey = 'options_' . $key;
print "<td align=\"center\">"; print $prospectstatic->LibLevel($obj->fk_prospectlevel); print "</td>"; // Statut print '<td align="center" nowrap="nowrap">'; print $prospectstatic->LibProspStatut($obj->fk_stcomm,2); print "</td>"; //$sts = array(-1,0,1,2,3); print '<td align="right" nowrap="nowrap">'; foreach ($sts as $key => $value) { if ($value <> $obj->fk_stcomm) { print '<a href="prospects.php?socid='.$obj->rowid.'&pstcomm='.$value.'&action=cstc&'.$param.($page?'&page='.$page:'').'">'; print img_action(0,$value); print '</a> '; } } print '</td>'; print '<td align="right">'; print $prospectstatic->getLibStatut(3); print '</td>'; print "</tr>\n"; $i++; } if ($num > $conf->liste_limit || $page > 0) print_barre_liste('', $page, $_SERVER["PHP_SELF"],$param,$sortfield,$sortorder,'',$num,$nbtotalofrecords);
$sql .= " ORDER BY st.id"; $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; if ($num > 0) { $var = true; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print '<td colspan="2">' . $langs->trans("ProspectsByStatus") . '</td></tr>'; while ($i < $num) { $obj = $db->fetch_object($resql); $var = !$var; print '<tr ' . $bc[$var] . '><td>'; print '<a href="prospects.php?page=0&stcomm=' . $obj->id . '">'; print img_action($langs->trans("Show"), $obj->id) . ' '; print $langs->trans("StatusProspect" . $obj->id); print '</a></td><td align="right">' . $obj->cc . '</td></tr>'; $i++; } print "</table><br>"; } } /* * Liste des propal brouillons */ if (!empty($conf->propal->enabled) && $user->rights->propale->lire) { $sql = "SELECT p.rowid, p.ref, p.price, s.nom as sname"; $sql .= " FROM " . MAIN_DB_PREFIX . "propal as p"; $sql .= ", " . MAIN_DB_PREFIX . "societe as s"; if (!$user->rights->societe->client->voir && !$socid) {
/** * Return label of a given status * * @param int|string $statut Id or code for prospection status * @param int $mode 0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto * @param string $label Label to use for status for added status * @return string Libelle du statut */ function LibProspCommStatut($statut, $mode=0, $label='') { global $langs; $langs->load('customers'); if ($mode == 2) { if ($statut == '-1' || $statut == 'ST_NO') return img_action($langs->trans("StatusProspect-1"),-1).' '.$langs->trans("StatusProspect-1"); elseif ($statut == '0' || $statut == 'ST_NEVER') return img_action($langs->trans("StatusProspect0"), 0).' '.$langs->trans("StatusProspect0"); elseif ($statut == '1' || $statut == 'ST_TODO') return img_action($langs->trans("StatusProspect1"), 1).' '.$langs->trans("StatusProspect1"); elseif ($statut == '2' || $statut == 'ST_PEND') return img_action($langs->trans("StatusProspect2"), 2).' '.$langs->trans("StatusProspect2"); elseif ($statut == '3' || $statut == 'ST_DONE') return img_action($langs->trans("StatusProspect3"), 3).' '.$langs->trans("StatusProspect3"); else { return img_action(($langs->trans("StatusProspect".$statut) != "StatusProspect".$statut) ? $langs->trans("StatusProspect".$statut) : $label, 0).' '.(($langs->trans("StatusProspect".$statut) != "StatusProspect".$statut) ? $langs->trans("StatusProspect".$statut) : $label); } } if ($mode == 3) { if ($statut == '-1' || $statut == 'ST_NO') return img_action($langs->trans("StatusProspect-1"),-1); elseif ($statut == '0' || $statut == 'ST_NEVER') return img_action($langs->trans("StatusProspect0"), 0); elseif ($statut == '1' || $statut == 'ST_TODO') return img_action($langs->trans("StatusProspect1"), 1); elseif ($statut == '2' || $statut == 'ST_PEND') return img_action($langs->trans("StatusProspect2"), 2); elseif ($statut == '3' || $statut == 'ST_DONE') return img_action($langs->trans("StatusProspect3"), 3); else { return img_action(($langs->trans("StatusProspect".$statut) != "StatusProspect".$statut) ? $langs->trans("StatusProspect".$statut) : $label, 0); } } if ($mode == 4) { if ($statut == '-1' || $statut == 'ST_NO') return img_action($langs->trans("StatusProspect-1"),-1).' '.$langs->trans("StatusProspect-1"); elseif ($statut == '0' || $statut == 'ST_NEVER') return img_action($langs->trans("StatusProspect0"), 0).' '.$langs->trans("StatusProspect0"); elseif ($statut == '1' || $statut == 'ST_TODO') return img_action($langs->trans("StatusProspect1"), 1).' '.$langs->trans("StatusProspect1"); elseif ($statut == '2' || $statut == 'ST_PEND') return img_action($langs->trans("StatusProspect2"), 2).' '.$langs->trans("StatusProspect2"); elseif ($statut == '3' || $statut == 'ST_DONE') return img_action($langs->trans("StatusProspect3"), 3).' '.$langs->trans("StatusProspect3"); else { return img_action(($langs->trans("StatusProspect".$statut) != "StatusProspect".$statut) ? $langs->trans("StatusProspect".$statut) : $label, 0).' '.(($langs->trans("StatusProspect".$statut) != "StatusProspect".$statut) ? $langs->trans("StatusProspect".$statut) : $label); } } return "Error, mode/status not found"; }
function ProspectStatus() { global $user, $conf, $langs, $bc; $sql = "SELECT count(s.rowid) as cc,st.libelle,st.type,st.id"; $sql .= " FROM " . MAIN_DB_PREFIX . "c_stcomm as st"; //if (!$user->rights->societe->client->voir) //{ // $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."user as u on u.rowid = sc.fk_user"; //} $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe as s on (s.fk_stcomm = st.id AND s.client IN (1,2,3) AND s.entity = " . $conf->entity . ")"; if (!$user->rights->societe->client->voir) { $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe_commerciaux as sc on (s.rowid = sc.fk_soc)"; } //$sql.=")"; $sql .= " WHERE st.active=1"; if (!$user->rights->societe->client->voir) { $sql .= " AND sc.fk_user = "******" GROUP BY st.id"; $sql .= " ORDER BY st.id DESC"; //print $sql;exit; $array = array(); $color = array(-1 => "#A51B00", 0 => "#CCC", 1 => "#000", 2 => "#FEF4AE", 3 => "#666", 4 => "#1f17c1", 5 => "#DE7603", 6 => "#D40000", 7 => "#7ac52e", 8 => "#1b651b", 9 => "#66c18c", 10 => "#2e99a0"); $total = 0; $resql = $this->db->query($sql); if ($resql) { $num = $this->db->num_rows($resql); $i = 0; while ($i < $num) { $obj = $this->db->fetch_object($resql); $element = array(); $element['id'] = $obj->id; $element['count'] = $obj->cc; $element['libelle'] = $obj->libelle; $element['type'] = $obj->type; $total += $obj->cc; $array[$i] = $element; $i++; } } $var = false; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print '<td colspan="2">' . $langs->trans("ProspectsByStatus") . '</td></tr>'; for ($i = 0, $size = sizeof($array); $i < $size; $i++) { print '<tr ' . $bc[$var] . '><td><a href=' . DOL_URL_ROOT . '/comm/list.php?pstcomm=' . $array[$i]['id'] . '>'; print img_action($langs->trans("Show"), $array[$i]['id']) . ' '; print $langs->trans($array[$i]['libelle']); print '</a></td><td align="right">' . $array[$i]['count'] . '</td></tr>'; $var = !$var; } print '</td></tr>'; print "</table><br>"; }
} else { print $object->getLibProspLevel(); } print "</td>"; print '</tr>'; // Status $object->loadCacheOfProspStatus(); print '<tr><td>' . $langs->trans("StatusProsp") . '</td><td colspan="3">' . $object->getLibProspCommStatut(4, $object->cacheprospectstatus[$object->stcomm_id]['label']); print ' <div class="floatright">'; foreach ($object->cacheprospectstatus as $key => $val) { $titlealt = 'default'; if (!empty($val['code']) && !in_array($val['code'], array('ST_NO', 'ST_NEVER', 'ST_TODO', 'ST_PEND', 'ST_DONE'))) { $titlealt = $val['label']; } if ($object->stcomm_id != $val['id']) { print '<a class="pictosubstatus" href="' . $_SERVER["PHP_SELF"] . '?socid=' . $object->id . '&stcomm=' . $val['code'] . '&action=setstcomm">' . img_action($titlealt, $val['code']) . '</a>'; } } print '</div></td></tr>'; } // Categories if (!empty($conf->categorie->enabled) && !empty($user->rights->categorie->lire)) { print '<tr><td>' . $langs->trans("Categories") . '</td>'; print '<td colspan="3">'; print $form->showCategories($object->id, 'customer', 1); print "</td></tr>"; } // Other attributes $parameters = array('socid' => $object->id, 'colspan' => ' colspan="3"', 'colspanvalue' => '3'); $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
/** * Return label of a given status * * @param int $statut Id statut * @param int $mode 0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto * @return string Libelle du statut */ function LibProspStatut($statut, $mode = 0) { global $langs; $langs->load('customers'); if ($mode == 2) { if ($statut == -1) { return img_action($langs->trans("StatusProspect-1"), -1) . ' ' . $langs->trans("StatusProspect-1"); } if ($statut == 0) { return img_action($langs->trans("StatusProspect0"), 0) . ' ' . $langs->trans("StatusProspect0"); } if ($statut == 1) { return img_action($langs->trans("StatusProspect1"), 1) . ' ' . $langs->trans("StatusProspect1"); } if ($statut == 2) { return img_action($langs->trans("StatusProspect2"), 2) . ' ' . $langs->trans("StatusProspect2"); } if ($statut == 3) { return img_action($langs->trans("StatusProspect3"), 3) . ' ' . $langs->trans("StatusProspect3"); } } if ($mode == 3) { if ($statut == -1) { return img_action($langs->trans("StatusProspect-1"), -1); } if ($statut == 0) { return img_action($langs->trans("StatusProspect0"), 0); } if ($statut == 1) { return img_action($langs->trans("StatusProspect1"), 1); } if ($statut == 2) { return img_action($langs->trans("StatusProspect2"), 2); } if ($statut == 3) { return img_action($langs->trans("StatusProspect3"), 3); } } if ($mode == 4) { if ($statut == -1) { return img_action($langs->trans("StatusProspect-1"), -1) . ' ' . $langs->trans("StatusProspect-1"); } if ($statut == 0) { return img_action($langs->trans("StatusProspect0"), 0) . ' ' . $langs->trans("StatusProspect0"); } if ($statut == 1) { return img_action($langs->trans("StatusProspect1"), 1) . ' ' . $langs->trans("StatusProspect1"); } if ($statut == 2) { return img_action($langs->trans("StatusProspect2"), 2) . ' ' . $langs->trans("StatusProspect2"); } if ($statut == 3) { return img_action($langs->trans("StatusProspect3"), 3) . ' ' . $langs->trans("StatusProspect3"); } } return "Error, mode/status not found"; }
print '<tr><td>' . $langs->trans("StatusProsp") . '</td><td colspan="2">' . $object->getLibProspStatut(4) . '</td>'; print '<td>'; if ($object->stcomm_id != -1) { print '<a href="fiche.php?socid=' . $object->id . '&stcomm=-1&action=cstc">' . img_action(0, -1) . '</a>'; } if ($object->stcomm_id != 0) { print '<a href="fiche.php?socid=' . $object->id . '&stcomm=0&action=cstc">' . img_action(0, 0) . '</a>'; } if ($object->stcomm_id != 1) { print '<a href="fiche.php?socid=' . $object->id . '&stcomm=1&action=cstc">' . img_action(0, 1) . '</a>'; } if ($object->stcomm_id != 2) { print '<a href="fiche.php?socid=' . $object->id . '&stcomm=2&action=cstc">' . img_action(0, 2) . '</a>'; } if ($object->stcomm_id != 3) { print '<a href="fiche.php?socid=' . $object->id . '&stcomm=3&action=cstc">' . img_action(0, 3) . '</a>'; } print '</td></tr>'; // Sales representative include DOL_DOCUMENT_ROOT . '/societe/tpl/linesalesrepresentative.tpl.php'; // Module Adherent if ($conf->adherent->enabled) { $langs->load("members"); $langs->load("users"); print '<tr><td width="25%" valign="top">' . $langs->trans("LinkedToDolibarrMember") . '</td>'; print '<td colspan="3">'; $adh = new Adherent($db); $result = $adh->fetch('', '', $object->id); if ($result > 0) { $adh->ref = $adh->getFullName($langs); print $adh->getNomUrl(1);