88 public function __construct($db, $dirmodule, $targetmodule, $canvas, $card)
91 $this->dirmodule = $dirmodule;
92 $this->targetmodule = $targetmodule;
93 $this->canvas = $canvas;
96 $this->module =
"service";
97 $this->
name =
"service";
98 $this->definition =
"Services canvas";
99 $this->fieldListName =
"product_service";
100 $this->next_prev_filter =
"canvas='service'";
116 global $conf, $langs, $user, $mysoc, $canvas;
119 $tmpobject =
new Product($this->db);
120 if (!empty($id) || !empty($ref)) {
121 $tmpobject->fetch($id, $ref);
123 $this->
object = $tmpobject;
125 foreach ($this->
object as $key => $value) {
126 $this->tpl[$key] = $value;
132 $this->tpl[
'canvas'] = $this->canvas;
135 $this->tpl[
'id'] = $this->id;
138 $this->tpl[
'ref'] = $this->ref;
141 $this->tpl[
'label'] = $this->label;
144 $this->tpl[
'description'] = nl2br($this->
description);
147 $this->tpl[
'status'] = $this->
object->getLibStatut(2);
150 $this->tpl[
'note'] = nl2br($this->note);
152 if ($action ==
'create') {
154 $this->tpl[
'price'] = $this->price;
155 $this->tpl[
'price_min'] = $this->price_min;
156 $this->tpl[
'price_base_type'] = $form->selectPriceBaseType($this->price_base_type,
"price_base_type");
159 $this->tpl[
'tva_tx'] = $form->load_tva(
"tva_tx", -1, $mysoc,
'');
162 if ($action ==
'view') {
165 $this->tpl[
'showrefnav'] = $form->showrefnav($this->
object,
'ref',
'', 1,
'ref');
167 $titre = $langs->trans(
"CardProduct".$this->object->type);
173 $this->tpl[
'accountancyBuyCodeKey'] = $form->editfieldkey(
"ProductAccountancyBuyCode",
'productaccountancycodesell', $this->accountancy_code_sell, $this, $user->rights->produit->creer);
174 $this->tpl[
'accountancyBuyCodeVal'] = $form->editfieldval(
"ProductAccountancyBuyCode",
'productaccountancycodesell', $this->accountancy_code_sell, $this, $user->rights->produit->creer);
177 $this->tpl[
'accountancySellCodeKey'] = $form->editfieldkey(
"ProductAccountancySellCode",
'productaccountancycodebuy', $this->accountancy_code_buy, $this, $user->rights->produit->creer);
178 $this->tpl[
'accountancySellCodeVal'] = $form->editfieldval(
"ProductAccountancySellCode",
'productaccountancycodebuy', $this->accountancy_code_buy, $this, $user->rights->produit->creer);
181 $this->tpl[
'finished'] = $this->
object->finished;
182 $this->tpl[
'ref'] = $this->
object->ref;
183 $this->tpl[
'label'] = $this->
object->label;
184 $this->tpl[
'id'] = $this->
object->id;
185 $this->tpl[
'type'] = $this->
object->type;
186 $this->tpl[
'note'] = $this->
object->note_private;
187 $this->tpl[
'seuil_stock_alerte'] = $this->
object->seuil_stock_alerte;
190 $this->tpl[
'duration_value'] = $this->
object->duration_value;
192 if ($action ==
'create') {
194 $this->tpl[
'title'] = $langs->trans(
"NewService");
197 if ($action ==
'edit') {
198 $this->tpl[
'title'] = $langs->trans(
'Modify').
' '.$langs->trans(
'Service').
' : '.$this->
object->ref;
201 if ($action ==
'create' || $action ==
'edit') {
203 $statutarray = array(
'1' => $langs->trans(
"OnSell"),
'0' => $langs->trans(
"NotOnSell"));
204 $this->tpl[
'status'] = $form->selectarray(
'statut', $statutarray, $this->object->status);
206 $statutarray = array(
'1' => $langs->trans(
"ProductStatusOnBuy"),
'0' => $langs->trans(
"ProductStatusNotOnBuy"));
207 $this->tpl[
'status_buy'] = $form->selectarray(
'statut_buy', $statutarray, $this->object->status_buy);
209 $this->tpl[
'description'] = $this->description;
210 $this->tpl[
'note'] = $this->note;
214 $duration_unit =
'<input name="duration_unit" type="radio" value="h"'.($this->object->duration_unit ==
'h' ?
' checked' :
'').
'>'.$langs->trans(
"Hour");
215 $duration_unit .=
' ';
216 $duration_unit .=
'<input name="duration_unit" type="radio" value="d"'.($this->object->duration_unit ==
'd' ?
' checked' :
'').
'>'.$langs->trans(
"Day");
217 $duration_unit .=
' ';
218 $duration_unit .=
'<input name="duration_unit" type="radio" value="w"'.($this->object->duration_unit ==
'w' ?
' checked' :
'').
'>'.$langs->trans(
"Week");
219 $duration_unit .=
' ';
220 $duration_unit .=
'<input name="duration_unit" type="radio" value="m"'.($this->object->duration_unit ==
'm' ?
' checked' :
'').
'>'.$langs->trans(
"Month");
221 $duration_unit .=
' ';
222 $duration_unit .=
'<input name="duration_unit" type="radio" value="y"'.($this->object->duration_unit ==
'y' ?
' checked' :
'').
'>'.$langs->trans(
"Year");
223 $this->tpl[
'duration_unit'] = $duration_unit;
226 if ($action ==
'view') {
228 $this->tpl[
'nblines'] = 4;
229 if ($this->object->is_photo_available($conf->service->multidir_output[$this->object->entity])) {
230 $this->tpl[
'photos'] = $this->
object->show_photos(
'product', $conf->service->multidir_output[$this->object->entity], 1, 1, 0, 0, 0, 80);
235 if ($this->object->duration_value > 1) {
236 $dur = array(
"h"=>$langs->trans(
"Hours"),
"d"=>$langs->trans(
"Days"),
"w"=>$langs->trans(
"Weeks"),
"m"=>$langs->trans(
"Months"),
"y"=>$langs->trans(
"Years"));
237 } elseif ($this->object->duration_value > 0) {
238 $dur = array(
"h"=>$langs->trans(
"Hour"),
"d"=>$langs->trans(
"Day"),
"w"=>$langs->trans(
"Week"),
"m"=>$langs->trans(
"Month"),
"y"=>$langs->trans(
"Year"));
240 $this->tpl[
'duration_unit'] = $langs->trans($dur[$this->object->duration_unit]);
254 global $conf, $langs;
256 $this->field_list = array();
258 $sql =
"SELECT rowid, name, alias, title, align, sort, search, visible, enabled, rang";
259 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_field_list";
260 $sql .=
" WHERE element = '".$this->db->escape($this->fieldListName).
"'";
261 $sql .=
" AND entity = ".$conf->entity;
262 $sql .=
" ORDER BY rang ASC";
264 $resql = $this->db->query($sql);
266 $num = $this->db->num_rows($resql);
270 $fieldlist = array();
272 $obj = $this->db->fetch_object($resql);
274 $fieldlist[
"id"] = $obj->rowid;
275 $fieldlist[
"name"] = $obj->name;
276 $fieldlist[
"alias"] = $obj->alias;
277 $fieldlist[
"title"] = $langs->trans($obj->title);
278 $fieldlist[
"align"] = $obj->align;
279 $fieldlist[
"sort"] = $obj->sort;
280 $fieldlist[
"search"] = $obj->search;
281 $fieldlist[
"visible"] = $obj->visible;
282 $fieldlist[
"enabled"] =
verifCond($obj->enabled);
283 $fieldlist[
"order"] = $obj->rang;
285 array_push($this->field_list, $fieldlist);
289 $this->db->free($resql);