34 global $db, $langs, $conf, $user;
35 $langs->loadLangs(array(
'propal',
'compta',
'companies'));
40 $head[$h][0] = DOL_URL_ROOT.
'/comm/propal/card.php?id='.
$object->id;
41 $head[$h][1] = $langs->trans(
'Proposal');
42 $head[$h][2] =
'comm';
45 if ((empty($conf->commande->enabled) && ((isModEnabled(
"shipping") &&
getDolGlobalInt(
'MAIN_SUBMODULE_EXPEDITION') && $user->hasRight(
'expedition',
'lire'))
46 || (
getDolGlobalInt(
'MAIN_SUBMODULE_DELIVERY') && $user->hasRight(
'expedition',
'delivery',
'lire'))))) {
47 $langs->load(
"sendings");
49 $head[$h][0] = DOL_URL_ROOT.
'/expedition/propal.php?id='.
$object->id;
51 $text = $langs->trans(
"Shipment");
57 $text .= $langs->trans(
"Receivings");
60 $head[$h][2] =
'shipping';
65 $nbContact = count(
$object->liste_contact(-1,
'internal')) + count(
$object->liste_contact(-1,
'external'));
66 $head[$h][0] = DOL_URL_ROOT.
'/comm/propal/contact.php?id='.
$object->id;
67 $head[$h][1] = $langs->trans(
'ContactsAddresses');
69 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbContact.
'</span>';
71 $head[$h][2] =
'contact';
83 if (!empty(
$object->note_private)) {
86 if (!empty(
$object->note_public)) {
89 $head[$h][0] = DOL_URL_ROOT.
'/comm/propal/note.php?id='.
$object->id;
90 $head[$h][1] = $langs->trans(
'Notes');
92 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
94 $head[$h][2] =
'note';
98 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
99 require_once DOL_DOCUMENT_ROOT.
'/core/class/link.class.php';
101 $nbFiles = count(
dol_dir_list($upload_dir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
103 $head[$h][0] = DOL_URL_ROOT.
'/comm/propal/document.php?id='.
$object->id;
104 $head[$h][1] = $langs->trans(
'Documents');
105 if (($nbFiles + $nbLinks) > 0) {
106 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.($nbFiles + $nbLinks).
'</span>';
108 $head[$h][2] =
'document';
112 $head[$h][0] = DOL_URL_ROOT.
'/comm/propal/agenda.php?id='.
$object->id;
113 $head[$h][1] = $langs->trans(
"Events");
114 if (isModEnabled(
'agenda')&& ($user->hasRight(
'agenda',
'myactions',
'read') || $user->hasRight(
'agenda',
'allactions',
'read'))) {
117 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
118 $cachekey =
'count_events_propal_'.$object->id;
120 if (!is_null($dataretrieved)) {
121 $nbEvent = $dataretrieved;
123 $sql =
"SELECT COUNT(id) as nb";
124 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm";
125 $sql .=
" WHERE fk_element = ".((int)
$object->id);
126 $sql .=
" AND elementtype = 'propal'";
127 $resql = $db->query($sql);
129 $obj = $db->fetch_object($resql);
132 dol_syslog(
'Failed to count actioncomm '.$db->lasterror(), LOG_ERR);
138 $head[$h][1] .= $langs->trans(
"Agenda");
140 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbEvent.
'</span>';
143 $head[$h][2] =
'agenda';
160 global $langs, $conf, $user, $db;
163 $extrafields->fetch_name_optionals_label(
'propal');
164 $extrafields->fetch_name_optionals_label(
'propaldet');
169 $head[$h][0] = DOL_URL_ROOT.
'/admin/propal.php';
170 $head[$h][1] = $langs->trans(
"Miscellaneous");
171 $head[$h][2] =
'general';
180 $head[$h][0] = DOL_URL_ROOT.
'/comm/admin/propal_extrafields.php';
181 $head[$h][1] = $langs->trans(
"ExtraFields");
182 $nbExtrafields = $extrafields->attributes[
'propal'][
'count'];
183 if ($nbExtrafields > 0) {
184 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbExtrafields.
'</span>';
186 $head[$h][2] =
'attributes';
189 $head[$h][0] = DOL_URL_ROOT.
'/comm/admin/propaldet_extrafields.php';
190 $head[$h][1] = $langs->trans(
"ExtraFieldsLines");
191 $nbExtrafields = $extrafields->attributes[
'propaldet'][
'count'];
192 if ($nbExtrafields > 0) {
193 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbExtrafields.
'</span>';
195 $head[$h][2] =
'attributeslines';
213 global $conf, $db, $langs, $user;
217 if (!isModEnabled(
'propal') || !$user->hasRight(
'propal',
'lire')) {
223 $propalstatic =
new Propal($db);
225 $sql =
"SELECT count(p.rowid) as nb, p.fk_statut as status";
226 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
227 $sql .=
", ".MAIN_DB_PREFIX.
"propal as p";
228 if (!$user->hasRight(
'societe',
'client',
'voir')) {
229 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
231 $sql .=
" WHERE p.entity IN (".getEntity($propalstatic->element).
")";
232 $sql .=
" AND p.fk_soc = s.rowid";
234 $sql .=
' AND p.fk_soc = '.((int) $user->socid);
236 if (!$user->hasRight(
'societe',
'client',
'voir')) {
237 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
239 $sql .=
" AND p.fk_statut IN (".$db->sanitize(implode(
" ,", $listofstatus)).
")";
240 $sql .=
" GROUP BY p.fk_statut";
241 $resql = $db->query($sql);
243 $num = $db->num_rows($resql);
247 $dataseries = array();
248 $colorseries = array();
252 $obj = $db->fetch_object($resql);
254 $vals[$obj->status] = $obj->nb;
255 $totalinprocess += $obj->nb;
263 global $badgeStatus0, $badgeStatus1, $badgeStatus4, $badgeStatus6, $badgeStatus9;
264 include DOL_DOCUMENT_ROOT.
'/theme/'.$conf->theme.
'/theme_vars.inc.php';
266 $result =
'<div class="div-table-responsive-no-min">';
267 $result .=
'<table class="noborder nohover centpercent">';
269 $result .=
'<tr class="liste_titre">';
270 $result .=
'<td colspan="2">'.$langs->trans(
"Statistics").
' - '.$langs->trans(
"Proposals").
'</td>';
273 foreach ($listofstatus as $status) {
274 $dataseries[] = array($propalstatic->LibStatut($status, 1), (isset($vals[$status]) ? (
int) $vals[$status] : 0));
276 $colorseries[$status] =
'-'.$badgeStatus0;
279 $colorseries[$status] = $badgeStatus1;
282 $colorseries[$status] = $badgeStatus4;
285 $colorseries[$status] = $badgeStatus9;
288 $colorseries[$status] = $badgeStatus6;
291 if (empty($conf->use_javascript_ajax)) {
292 $result .=
'<tr class="oddeven">';
293 $result .=
'<td>'.$propalstatic->LibStatut($status, 0).
'</td>';
294 $result .=
'<td class="right"><a href="list.php?statut='.$status.
'">'.(isset($vals[$status]) ? $vals[$status] : 0).
'</a></td>';
295 $result .=
"</tr>\n";
299 if ($conf->use_javascript_ajax) {
301 $result .=
'<td align="center" colspan="2">';
303 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
305 $dolgraph->SetData($dataseries);
306 $dolgraph->SetDataColor(array_values($colorseries));
307 $dolgraph->setShowLegend(2);
308 $dolgraph->setShowPercent(1);
309 $dolgraph->SetType(array(
'pie'));
310 $dolgraph->setHeight(
'150');
311 $dolgraph->setWidth(
'300');
312 $dolgraph->draw(
'idgraphthirdparties');
313 $result .= $dolgraph->show($total ? 0 : 1);
327 $result .=
'<tr class="liste_total">';
328 $result .=
'<td>'.$langs->trans(
"Total").
'</td>';
329 $result .=
'<td class="right">'.$total.
'</td>';
332 $result .=
'</table>';
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
static count($dbs, $objecttype, $objectid)
Return nb of links.
Class to manage proposals.
const STATUS_DRAFT
Draft status.
const STATUS_SIGNED
Signed quote.
const STATUS_NOTSIGNED
Not signed quote.
const STATUS_BILLED
Billed or processed quote.
const STATUS_VALIDATED
Validated status.
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
complete_head_from_modules($conf, $langs, $object, &$head, &$h, $type, $mode='add', $filterorigmodule='')
Complete or removed entries into a head array (used to build tabs).
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_setcache($memoryid, $data, $expire=0)
Save data into a memory area shared by all users, all sessions on server.
dol_getcache($memoryid)
Read a memory area shared by all users, all sessions on server.
propal_admin_prepare_head()
Return array head with list of tabs to view object information.
getCustomerProposalPieChart($socid=0)
Return a HTML table that contains a pie chart of customer proposals.
propal_prepare_head($object)
Prepare array with list of tabs.