Example #1
0
 /**
  *  Load data into info_box_contents array to show array later.
  *
  *  @param	int		$max        Maximum number of records to load
  *  @return	void
  */
 function loadBox($max = 5)
 {
     global $user, $langs, $db, $conf;
     $this->max = $max;
     $thirdpartystatic = new Client($db);
     $this->info_box_head = array('text' => $langs->trans("BoxTitleLastModifiedProspects", $max));
     if ($user->rights->societe->lire) {
         $sql = "SELECT s.nom as name, s.rowid as socid";
         $sql .= ", s.code_client";
         $sql .= ", s.client";
         $sql .= ", s.code_fournisseur";
         $sql .= ", s.fournisseur";
         $sql .= ", s.logo";
         $sql .= ", s.fk_stcomm, s.datec, s.tms, s.status";
         $sql .= " FROM " . MAIN_DB_PREFIX . "societe as s";
         if (!$user->rights->societe->client->voir && !$user->societe_id) {
             $sql .= ", " . MAIN_DB_PREFIX . "societe_commerciaux as sc";
         }
         $sql .= " WHERE s.client IN (2, 3)";
         $sql .= " AND s.entity IN (" . getEntity('societe', 1) . ")";
         if (!$user->rights->societe->client->voir && !$user->societe_id) {
             $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = "******" AND s.rowid = " . $user->societe_id;
         }
         $sql .= " ORDER BY s.tms DESC";
         $sql .= $db->plimit($max, 0);
         dol_syslog(get_class($this) . "::loadBox", LOG_DEBUG);
         $resql = $db->query($sql);
         if ($resql) {
             $num = $db->num_rows($resql);
             $line = 0;
             while ($line < $num) {
                 $objp = $db->fetch_object($resql);
                 $datec = $db->jdate($objp->datec);
                 $datem = $db->jdate($objp->tms);
                 $thirdpartystatic->id = $objp->socid;
                 $thirdpartystatic->name = $objp->name;
                 $thirdpartystatic->code_client = $objp->code_client;
                 $thirdpartystatic->code_fournisseur = $objp->code_fournisseur;
                 $thirdpartystatic->client = $objp->client;
                 $thirdpartystatic->fournisseur = $objp->fournisseur;
                 $thirdpartystatic->logo = $objp->logo;
                 $this->info_box_contents[$line][] = array('td' => 'align="left"', 'text' => $thirdpartystatic->getNomUrl(1), 'asis' => 1);
                 $this->info_box_contents[$line][] = array('td' => 'align="right"', 'text' => dol_print_date($datem, "day"));
                 $this->info_box_contents[$line][] = array('td' => 'align="right" width="18"', 'text' => str_replace('img ', 'img height="14" ', $thirdpartystatic->LibProspCommStatut($objp->fk_stcomm, 3)));
                 $this->info_box_contents[$line][] = array('td' => 'align="right" width="18"', 'text' => $thirdpartystatic->LibStatut($objp->status, 3));
                 $line++;
             }
             if ($num == 0) {
                 $this->info_box_contents[$line][0] = array('td' => 'align="center"', 'text' => $langs->trans("NoRecordedProspects"));
             }
             $db->free($resql);
         } else {
             $this->info_box_contents[0][0] = array('td' => 'align="left"', 'maxlength' => 500, 'text' => $db->error() . ' sql=' . $sql);
         }
     } else {
         $this->info_box_contents[0][0] = array('td' => 'align="left"', 'text' => $langs->trans("ReadPermissionNotAllowed"));
     }
 }
Example #2
0
 $prospectstatic->fk_prospectlevel = $obj->fk_prospectlevel;
 $prospectstatic->name_alias = $obj->name_alias;
 print $prospectstatic->getNomUrl(1, 'prospect');
 print '</td>';
 print "<td>" . $obj->zip . "</td>";
 print "<td>" . $obj->town . "</td>";
 print '<td align="center">' . $obj->departement . '</td>';
 // Creation date
 print '<td align="center">' . dol_print_date($db->jdate($obj->datec)) . '</td>';
 // Level
 print '<td align="center">';
 print $prospectstatic->getLibProspLevel();
 print "</td>";
 // Statut
 print '<td align="center" class="nowrap">';
 print $prospectstatic->LibProspCommStatut($obj->stcomm_id, 2, $prospectstatic->cacheprospectstatus[$obj->stcomm_id]['label']);
 print "</td>";
 print '<td align="center" class="nowrap">';
 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"] . '?socid=' . $obj->socid . '&stcomm=' . $val['code'] . '&action=setstcomm' . $param . ($page ? '&page=' . urlencode($page) : '') . '">' . img_action($titlealt, $val['code']) . '</a>';
     }
 }
 print '</td>';
 // Extrafields
 if (is_array($extrafields->attribute_list) && count($extrafields->attribute_list)) {
     foreach ($extrafields->attribute_list as $key => $val) {