26 require_once DOL_DOCUMENT_ROOT.
"/core/boxes/modules_boxes.php";
36 public $boxcode =
"box_last_modified_knowledgerecord";
41 public $boximg =
"knowledgemanagement";
51 public $depends = array(
"knowledgemanagement");
61 $langs->loadLangs(array(
"boxes",
"knowledgemanagement",
"languages"));
64 $this->boxlabel = $langs->transnoentitiesnoconv(
"BoxLastModifiedKnowledgerecord");
79 require_once DOL_DOCUMENT_ROOT.
"/knowledgemanagement/class/knowledgerecord.class.php";
81 $text = $langs->trans(
"BoxLastModifiedKnowledgerecordDescription", $max);
82 $this->info_box_head = array(
87 $this->info_box_contents[0][0] = array(
88 'td' =>
'class="left"',
89 'text' => $langs->trans(
"BoxLastKnowledgerecordContent"),
92 if ($user->hasRight(
'knowledgemanagement',
'knowledgerecord',
'read')) {
93 $sql =
'SELECT k.rowid as id, k.date_creation, k.ref, k.lang, k.question, k.status as status';
94 $sql .=
" FROM ".MAIN_DB_PREFIX.
"knowledgemanagement_knowledgerecord as k";
95 $sql .=
" WHERE k.entity IN (".getEntity(
'knowledgemanagement').
")";
98 $sql .=
" AND k.fk_soc= ".((int) $user->socid);
101 $sql.=
" AND k.status > 0";
103 $sql .=
" ORDER BY k.tms DESC, k.rowid DESC ";
104 $sql .= $this->db->plimit($max, 0);
106 $resql = $this->db->query(
$sql);
108 $num = $this->db->num_rows($resql);
113 $objp = $this->db->fetch_object($resql);
115 $datec = $this->db->jdate($objp->date_creation);
118 $knowledgerecord->id = $objp->id;
119 $knowledgerecord->date_creation = $objp->date_creation;
120 $knowledgerecord->ref = $objp->ref;
121 $knowledgerecord->status = $objp->status;
122 $knowledgerecord->question = $objp->question;
127 $this->info_box_contents[$i][$r] = array(
128 'td' =>
'class="nowraponall"',
129 'text' => $knowledgerecord->getNomUrl(1),
135 $this->info_box_contents[$i][$r] = array(
136 'td' =>
'class="tdoverflowmax200"',
138 'url' => DOL_URL_ROOT.
"/knowledgemanagement/knowledgerecord_card.php?id=".urlencode($objp->id),
143 $labellang = ($objp->lang ? $langs->trans(
'Language_'.$objp->lang) :
'');
144 $this->info_box_contents[$i][$r] = array(
145 'td' =>
'class="tdoverflowmax100"',
146 'text' =>
picto_from_langcode($objp->lang,
'class="paddingrightonly saturatemedium opacitylow"') . $labellang,
152 $this->info_box_contents[$i][$r] = array(
159 $this->info_box_contents[$i][$r] = array(
160 'td' =>
'class="right nowraponall"',
161 'text' => $knowledgerecord->getLibStatut(3),
169 $this->info_box_contents[$i][0] = array(
171 'text' =>
'<span class="opacitymedium">'.$langs->trans(
"BoxLastTicketNoRecordedTickets").
'</span>',
178 $this->info_box_contents[0][0] = array(
180 'text' =>
'<span class="opacitymedium">'.$langs->trans(
"ReadPermissionNotAllowed").
'</span>',
193 public function showBox($head =
null, $contents =
null, $nooutput = 0)
195 return parent::showBox($this->info_box_head, $this->info_box_contents, $nooutput);
Class for KnowledgeRecord.
loadBox($max=5)
Load data into info_box_contents array to show array later.
__construct($db, $param='')
Constructor.
showBox($head=null, $contents=null, $nooutput=0)
Method to show box.
if(isModEnabled('invoice') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&!getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') && $user->hasRight('tax', 'charges', 'lire')) if(isModEnabled('invoice') &&isModEnabled('order') && $user->hasRight("commande", "lire") &&!getDolGlobalString('WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) $sql
Social contributions to pay.
picto_from_langcode($codelang, $moreatt='', $notitlealt=0)
Return img flag of country for a language code or country code.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...