1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927 |
- <?php
- /* Copyright (C) 2001-2006 Rodolphe Quiedeville <rodolphe@quiedeville.org>
- * Copyright (C) 2004-2019 Laurent Destailleur <eldy@users.sourceforge.net>
- * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
- * Copyright (C) 2012-2016 Marcos García <marcosgdf@gmail.com>
- * Copyright (C) 2013-2019 Juanjo Menent <jmenent@2byte.es>
- * Copyright (C) 2013-2015 Raphaël Doursenaud <rdoursenaud@gpcsolutions.fr>
- * Copyright (C) 2013 Jean Heimburger <jean@tiaris.info>
- * Copyright (C) 2013 Cédric Salvador <csalvador@gpcsolutions.fr>
- * Copyright (C) 2013 Florian Henry <florian.henry@open-concept.pro>
- * Copyright (C) 2013 Adolfo segura <adolfo.segura@gmail.com>
- * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
- * Copyright (C) 2016 Ferran Marcet <fmarcet@2byte.es>
- * Copyright (C) 2020-2021 Open-DSI <support@open-dsi.fr>
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 3 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program. If not, see <https://www.gnu.org/licenses/>.
- */
- /**
- * \file htdocs/product/list.php
- * \ingroup produit
- * \brief Page to list products and services
- */
- require '../main.inc.php';
- require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
- require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
- require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
- require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
- require_once DOL_DOCUMENT_ROOT.'/product/class/html.formproduct.class.php';
- if (!empty($conf->categorie->enabled)) {
- require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
- }
- // Load translation files required by the page
- $langs->loadLangs(array('products', 'stocks', 'suppliers', 'companies', 'margins'));
- if (!empty($conf->productbatch->enabled)) {
- $langs->load("productbatch");
- }
- $action = GETPOST('action', 'aZ09');
- $massaction = GETPOST('massaction', 'alpha');
- $show_files = GETPOST('show_files', 'int');
- $confirm = GETPOST('confirm', 'alpha');
- $toselect = GETPOST('toselect', 'array');
- $sall = trim((GETPOST('search_all', 'alphanohtml') != '') ?GETPOST('search_all', 'alphanohtml') : GETPOST('sall', 'alphanohtml'));
- $search_id = GETPOST("search_id", 'alpha');
- $search_ref = GETPOST("search_ref", 'alpha');
- $search_ref_supplier = GETPOST("search_ref_supplier", 'alpha');
- $search_barcode = GETPOST("search_barcode", 'alpha');
- $search_label = GETPOST("search_label", 'alpha');
- $search_type = GETPOST("search_type", 'int');
- $search_vatrate = GETPOST("search_vatrate", 'alpha');
- $searchCategoryProductOperator = 0;
- if (GETPOSTISSET('formfilteraction')) {
- $searchCategoryProductOperator = GETPOST('search_category_product_operator', 'int');
- } elseif (!empty($conf->global->MAIN_SEARCH_CAT_OR_BY_DEFAULT)) {
- $searchCategoryProductOperator = $conf->global->MAIN_SEARCH_CAT_OR_BY_DEFAULT;
- }
- $searchCategoryProductList = GETPOST('search_category_product_list', 'array');
- $search_tosell = GETPOST("search_tosell", 'int');
- $search_tobuy = GETPOST("search_tobuy", 'int');
- $search_country = GETPOST("search_country", 'int');
- $search_state = GETPOST("state_id", 'int');
- $fourn_id = GETPOST("fourn_id", 'int');
- $catid = GETPOST('catid', 'int');
- $search_tobatch = GETPOST("search_tobatch", 'int');
- $search_accountancy_code_sell = GETPOST("search_accountancy_code_sell", 'alpha');
- $search_accountancy_code_sell_intra = GETPOST("search_accountancy_code_sell_intra", 'alpha');
- $search_accountancy_code_sell_export = GETPOST("search_accountancy_code_sell_export", 'alpha');
- $search_accountancy_code_buy = GETPOST("search_accountancy_code_buy", 'alpha');
- $search_accountancy_code_buy_intra = GETPOST("search_accountancy_code_buy_intra", 'alpha');
- $search_accountancy_code_buy_export = GETPOST("search_accountancy_code_buy_export", 'alpha');
- $search_finished = GETPOST("search_finished", 'int');
- $optioncss = GETPOST('optioncss', 'alpha');
- $type = GETPOST("type", "int");
- //Show/hide child products
- if (!empty($conf->variants->enabled) && !empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD)) {
- $show_childproducts = GETPOST('search_show_childproducts');
- } else {
- $show_childproducts = '';
- }
- $diroutputmassaction = $conf->product->dir_output.'/temp/massgeneration/'.$user->id;
- $limit = GETPOST('limit', 'int') ?GETPOST('limit', 'int') : $conf->liste_limit;
- $sortfield = GETPOST('sortfield', 'aZ09comma');
- $sortorder = GETPOST('sortorder', 'aZ09comma');
- $page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');
- if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
- $page = 0;
- } // If $page is not defined, or '' or -1 or if we click on clear filters or if we select empty mass action
- $offset = $limit * $page;
- $pageprev = $page - 1;
- $pagenext = $page + 1;
- if (!$sortfield) {
- $sortfield = "p.ref";
- }
- if (!$sortorder) {
- $sortorder = "ASC";
- }
- // Initialize context for list
- $contextpage = GETPOST('contextpage', 'aZ') ?GETPOST('contextpage', 'aZ') : 'productservicelist';
- if ((string) $type == '1') {
- $contextpage = 'servicelist'; if ($search_type == '') {
- $search_type = '1';
- }
- }
- if ((string) $type == '0') {
- $contextpage = 'productlist'; if ($search_type == '') {
- $search_type = '0';
- }
- }
- // Initialize technical object to manage hooks. Note that conf->hooks_modules contains array of hooks
- $object = new Product($db);
- $hookmanager->initHooks(array('productservicelist'));
- $extrafields = new ExtraFields($db);
- $form = new Form($db);
- $formcompany = new FormCompany($db);
- $formproduct = new FormProduct($db);
- // fetch optionals attributes and labels
- $extrafields->fetch_name_optionals_label($object->table_element);
- $search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
- if (empty($action)) {
- $action = 'list';
- }
- // Get object canvas (By default, this is not defined, so standard usage of dolibarr)
- $canvas = GETPOST("canvas");
- $objcanvas = null;
- if (!empty($canvas)) {
- require_once DOL_DOCUMENT_ROOT.'/core/class/canvas.class.php';
- $objcanvas = new Canvas($db, $action);
- $objcanvas->getCanvas('product', 'list', $canvas);
- }
- // Define virtualdiffersfromphysical
- $virtualdiffersfromphysical = 0;
- if (!empty($conf->global->STOCK_CALCULATE_ON_SHIPMENT)
- || !empty($conf->global->STOCK_CALCULATE_ON_SUPPLIER_DISPATCH_ORDER)
- || !empty($conf->global->STOCK_CALCULATE_ON_SHIPMENT_CLOSE)
- || !empty($conf->global->STOCK_CALCULATE_ON_RECEPTION)
- || !empty($conf->global->STOCK_CALCULATE_ON_RECEPTION_CLOSE)
- || !empty($conf->mrp->enabled)) {
- $virtualdiffersfromphysical = 1; // According to increase/decrease stock options, virtual and physical stock may differs.
- }
- // List of fields to search into when doing a "search in all"
- $fieldstosearchall = array(
- 'p.ref'=>"Ref",
- 'pfp.ref_fourn'=>"RefSupplier",
- 'p.label'=>"ProductLabel",
- 'p.description'=>"Description",
- "p.note"=>"Note",
- );
- // multilang
- if (!empty($conf->global->MAIN_MULTILANGS)) {
- $fieldstosearchall['pl.label'] = 'ProductLabelTranslated';
- $fieldstosearchall['pl.description'] = 'ProductDescriptionTranslated';
- $fieldstosearchall['pl.note'] = 'ProductNoteTranslated';
- }
- if (!empty($conf->barcode->enabled)) {
- $fieldstosearchall['p.barcode'] = 'Gencod';
- $fieldstosearchall['pfp.barcode'] = 'GencodBuyPrice';
- }
- // Personalized search criterias. Example: $conf->global->PRODUCT_QUICKSEARCH_ON_FIELDS = 'p.ref=ProductRef;p.label=ProductLabel;p.description=Description;p.note=Note;'
- if (!empty($conf->global->PRODUCT_QUICKSEARCH_ON_FIELDS)) {
- $fieldstosearchall = dolExplodeIntoArray($conf->global->PRODUCT_QUICKSEARCH_ON_FIELDS);
- }
- if (empty($conf->global->PRODUIT_MULTIPRICES)) {
- $titlesellprice = $langs->trans("SellingPrice");
- if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES)) {
- $titlesellprice = $form->textwithpicto($langs->trans("SellingPrice"), $langs->trans("DefaultPriceRealPriceMayDependOnCustomer"));
- }
- }
- $isInEEC = isInEEC($mysoc);
- $alias_product_perentity = empty($conf->global->MAIN_PRODUCT_PERENTITY_SHARED) ? "p" : "ppe";
- // Definition of array of fields for columns
- $arrayfields = array(
- 'p.rowid'=>array('type'=>'integer', 'label'=>'TechnicalID', 'enabled'=>1, 'visible'=>-2, 'noteditable'=>1, 'notnull'=> 1, 'index'=>1, 'position'=>1, 'comment'=>'Id', 'css'=>'left'),
- 'p.ref'=>array('label'=>"Ref", 'checked'=>1, 'position'=>10),
- //'pfp.ref_fourn'=>array('label'=>$langs->trans("RefSupplier"), 'checked'=>1, 'enabled'=>(! empty($conf->barcode->enabled))),
- 'thumbnail'=>array('label'=>'Photo', 'checked'=>0, 'position'=>10),
- 'p.label'=>array('label'=>"Label", 'checked'=>1, 'position'=>10),
- 'p.fk_product_type'=>array('label'=>"Type", 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && !empty($conf->service->enabled)), 'position'=>11),
- 'p.barcode'=>array('label'=>"Gencod", 'checked'=>1, 'enabled'=>(!empty($conf->barcode->enabled)), 'position'=>12),
- 'p.duration'=>array('label'=>"Duration", 'checked'=>($contextpage != 'productlist'), 'enabled'=>(!empty($conf->service->enabled) && (string) $type == '1'), 'position'=>13),
- 'p.finished'=>array('label'=>"Nature", 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && $type != '1'), 'position'=>19),
- 'p.weight'=>array('label'=>'Weight', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && $type != '1'), 'position'=>20),
- 'p.weight_units'=>array('label'=>'WeightUnits', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && $type != '1'), 'position'=>21),
- 'p.length'=>array('label'=>'Length', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SIZE) && $type != '1'), 'position'=>22),
- 'p.length_units'=>array('label'=>'LengthUnits', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SIZE) && $type != '1'), 'position'=>23),
- 'p.width'=>array('label'=>'Width', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SIZE) && $type != '1'), 'position'=>24),
- 'p.width_units'=>array('label'=>'WidthUnits', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SIZE) && $type != '1'), 'position'=>25),
- 'p.height'=>array('label'=>'Height', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SIZE) && $type != '1'), 'position'=>26),
- 'p.height_units'=>array('label'=>'HeightUnits', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SIZE) && $type != '1'), 'position'=>27),
- 'p.surface'=>array('label'=>'Surface', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SURFACE) && $type != '1'), 'position'=>28),
- 'p.surface_units'=>array('label'=>'SurfaceUnits', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_SURFACE) && $type != '1'), 'position'=>29),
- 'p.volume'=>array('label'=>'Volume', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_VOLUME) && $type != '1'), 'position'=>30),
- 'p.volume_units'=>array('label'=>'VolumeUnits', 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && empty($conf->global->PRODUCT_DISABLE_VOLUME) && $type != '1'), 'position'=>31),
- 'cu.label'=>array('label'=>"DefaultUnitToShow", 'checked'=>0, 'enabled'=>(!empty($conf->product->enabled) && !empty($conf->global->PRODUCT_USE_UNITS)), 'position'=>32),
- 'p.sellprice'=>array('label'=>"SellingPrice", 'checked'=>1, 'enabled'=>empty($conf->global->PRODUIT_MULTIPRICES), 'position'=>40),
- 'p.tva_tx'=>array('label'=>"VATRate", 'checked'=>0, 'enabled'=>empty($conf->global->PRODUIT_MULTIPRICES), 'position'=>41),
- 'p.minbuyprice'=>array('label'=>"BuyingPriceMinShort", 'checked'=>1, 'enabled'=>(!empty($user->rights->fournisseur->lire)), 'position'=>42),
- 'p.numbuyprice'=>array('label'=>"BuyingPriceNumShort", 'checked'=>0, 'enabled'=>(!empty($user->rights->fournisseur->lire)), 'position'=>43),
- 'p.pmp'=>array('label'=>"PMPValueShort", 'checked'=>0, 'enabled'=>(!empty($user->rights->fournisseur->lire)), 'position'=>44),
- 'p.cost_price'=>array('label'=>"CostPrice", 'checked'=>0, 'enabled'=>(!empty($user->rights->fournisseur->lire)), 'position'=>45),
- 'p.seuil_stock_alerte'=>array('label'=>"StockLimit", 'checked'=>0, 'enabled'=>(!empty($conf->stock->enabled) && $user->rights->stock->lire && $contextpage != 'service'), 'position'=>50),
- 'p.desiredstock'=>array('label'=>"DesiredStock", 'checked'=>1, 'enabled'=>(!empty($conf->stock->enabled) && $user->rights->stock->lire && $contextpage != 'service'), 'position'=>51),
- 'p.stock'=>array('label'=>"PhysicalStock", 'checked'=>1, 'enabled'=>(!empty($conf->stock->enabled) && $user->rights->stock->lire && $contextpage != 'service'), 'position'=>52),
- 'stock_virtual'=>array('label'=>"VirtualStock", 'checked'=>1, 'enabled'=>(!empty($conf->stock->enabled) && $user->rights->stock->lire && $contextpage != 'service' && $virtualdiffersfromphysical), 'position'=>53),
- 'p.tobatch'=>array('label'=>"ManageLotSerial", 'checked'=>0, 'enabled'=>(!empty($conf->productbatch->enabled)), 'position'=>60),
- 'p.fk_country'=>array('label'=>"Country", 'checked'=>0, 'position'=>100),
- 'p.fk_state'=>array('label'=>"State", 'checked'=>0, 'position'=>101),
- $alias_product_perentity . '.accountancy_code_sell'=>array('label'=>"ProductAccountancySellCode", 'checked'=>0, 'position'=>400),
- $alias_product_perentity . '.accountancy_code_sell_intra'=>array('label'=>"ProductAccountancySellIntraCode", 'checked'=>0, 'enabled'=>$isInEEC, 'position'=>401),
- $alias_product_perentity . '.accountancy_code_sell_export'=>array('label'=>"ProductAccountancySellExportCode", 'checked'=>0, 'position'=>402),
- $alias_product_perentity . '.accountancy_code_buy'=>array('label'=>"ProductAccountancyBuyCode", 'checked'=>0, 'position'=>403),
- $alias_product_perentity . '.accountancy_code_buy_intra'=>array('label'=>"ProductAccountancyBuyIntraCode", 'checked'=>0, 'enabled'=>$isInEEC, 'position'=>404),
- $alias_product_perentity . '.accountancy_code_buy_export'=>array('label'=>"ProductAccountancyBuyExportCode", 'checked'=>0, 'position'=>405),
- 'p.datec'=>array('label'=>"DateCreation", 'checked'=>0, 'position'=>500),
- 'p.tms'=>array('label'=>"DateModificationShort", 'checked'=>0, 'position'=>500),
- 'p.tosell'=>array('label'=>$langs->transnoentitiesnoconv("Status").' ('.$langs->transnoentitiesnoconv("Sell").')', 'checked'=>1, 'position'=>1000),
- 'p.tobuy'=>array('label'=>$langs->transnoentitiesnoconv("Status").' ('.$langs->transnoentitiesnoconv("Buy").')', 'checked'=>1, 'position'=>1000)
- );
- /*foreach ($object->fields as $key => $val) {
- // If $val['visible']==0, then we never show the field
- if (!empty($val['visible'])) {
- $visible = dol_eval($val['visible'], 1, 1, '1');
- $arrayfields['p.'.$key] = array(
- 'label'=>$val['label'],
- 'checked'=>(($visible < 0) ? 0 : 1),
- 'enabled'=>($visible != 3 && dol_eval($val['enabled'], 1, 1, '1')),
- 'position'=>$val['position']
- );
- }
- }*/
- // MultiPrices
- if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
- for ($i = 1; $i <= $conf->global->PRODUIT_MULTIPRICES_LIMIT; $i++) {
- $keyforlabel = 'PRODUIT_MULTIPRICES_LABEL'.$i;
- if (!empty($conf->global->$keyforlabel)) {
- $labelp = $i.' - '.$langs->transnoentitiesnoconv($conf->global->$keyforlabel);
- } else {
- $labelp = $langs->transnoentitiesnoconv("SellingPrice")." ".$i;
- }
- $arrayfields['p.sellprice'.$i] = array('label'=>$labelp, 'checked'=>($i == 1 ? 1 : 0), 'enabled'=>$conf->global->PRODUIT_MULTIPRICES, 'position'=>floatval('40.'.sprintf('%03s', $i)));
- $arraypricelevel[$i] = array($i);
- }
- }
- //var_dump($arraypricelevel);
- // Extra fields
- include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
- $object->fields = dol_sort_array($object->fields, 'position');
- $arrayfields = dol_sort_array($arrayfields, 'position');
- // Security check
- if ($search_type == '0') {
- $result = restrictedArea($user, 'produit', '', '', '', '', '', 0);
- } elseif ($search_type == '1') {
- $result = restrictedArea($user, 'service', '', '', '', '', '', 0);
- } else {
- $result = restrictedArea($user, 'produit|service', '', '', '', '', '', 0);
- }
- /*
- * Actions
- */
- if (GETPOST('cancel', 'alpha')) {
- $action = 'list'; $massaction = '';
- }
- if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
- $massaction = '';
- }
- $parameters = array();
- $reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
- if ($reshook < 0) {
- setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
- }
- $rightskey = 'produit';
- if ($type == Product::TYPE_SERVICE) {
- $rightskey = 'service';
- }
- if (empty($reshook)) {
- // Selection of new fields
- include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
- // Purge search criteria
- if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers
- $sall = "";
- $search_id = '';
- $search_ref = "";
- $search_ref_supplier = "";
- $search_label = "";
- $search_barcode = "";
- $searchCategoryProductOperator = 0;
- $searchCategoryProductList = array();
- $search_tosell = "";
- $search_tobuy = "";
- $search_tobatch = '';
- $search_country = "";
- $search_state = "";
- $search_vatrate = "";
- $search_finished = '';
- //$search_type=''; // There is 2 types of list: a list of product and a list of services. No list with both. So when we clear search criteria, we must keep the filter on type.
- $show_childproducts = '';
- $search_accountancy_code_sell = '';
- $search_accountancy_code_sell_intra = '';
- $search_accountancy_code_sell_export = '';
- $search_accountancy_code_buy = '';
- $search_accountancy_code_buy_intra = '';
- $search_accountancy_code_buy_export = '';
- $search_array_options = array();
- }
- // Mass actions
- $objectclass = 'Product';
- if ((string) $search_type == '1') {
- $objectlabel = 'Services';
- }
- if ((string) $search_type == '0') {
- $objectlabel = 'Products';
- }
- $permissiontoread = $user->rights->{$rightskey}->lire;
- $permissiontodelete = $user->rights->{$rightskey}->supprimer;
- $permissiontoadd = $user->rights->{$rightskey}->creer;
- $uploaddir = $conf->product->dir_output;
- include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
- if (!$error && $massaction == 'switchonsalestatus' && $permissiontoadd) {
- $product = new Product($db);
- foreach ($toselect as $toselectid) {
- $result = $product->fetch($toselectid);
- if ($result > 0 && $product->id > 0) {
- $product->setStatut($product->status ? 0 : 1, null, 'product', 'PRODUCT_MODIFY', 'tosell');
- }
- }
- }
- if (!$error && $massaction == 'switchonpurchasestatus' && $permissiontoadd) {
- $product = new Product($db);
- foreach ($toselect as $toselectid) {
- $result = $product->fetch($toselectid);
- if ($result > 0 && $product->id > 0) {
- $product->setStatut($product->status_buy ? 0 : 1, null, 'product', 'PRODUCT_MODIFY', 'tobuy');
- }
- }
- }
- }
- /*
- * View
- */
- $title = $langs->trans("ProductsAndServices");
- if ($search_type != '' && $search_type != '-1') {
- if ($search_type == 1) {
- $texte = $langs->trans("Services");
- } else {
- $texte = $langs->trans("Products");
- }
- } else {
- $texte = $langs->trans("ProductsAndServices");
- }
- $sql = 'SELECT DISTINCT p.rowid, p.ref, p.label, p.fk_product_type, p.barcode, p.price, p.tva_tx, p.price_ttc, p.price_base_type, p.entity,';
- $sql .= ' p.fk_product_type, p.duration, p.finished, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock,';
- $sql .= ' p.tobatch,';
- if (empty($conf->global->MAIN_PRODUCT_PERENTITY_SHARED)) {
- $sql .= " p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export,";
- } else {
- $sql .= " ppe.accountancy_code_sell, ppe.accountancy_code_sell_intra, ppe.accountancy_code_sell_export, ppe.accountancy_code_buy, ppe.accountancy_code_buy_intra, ppe.accountancy_code_buy_export,";
- }
- $sql .= ' p.datec as date_creation, p.tms as date_update, p.pmp, p.stock, p.cost_price,';
- $sql .= ' p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units, fk_country, fk_state,';
- if (!empty($conf->global->PRODUCT_USE_UNITS)) {
- $sql .= ' p.fk_unit, cu.label as cu_label,';
- }
- $sql .= ' MIN(pfp.unitprice) as minsellprice';
- if (!empty($conf->variants->enabled) && (!empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD) && !$show_childproducts)) {
- $sql .= ', pac.rowid prod_comb_id';
- }
- // Add fields from extrafields
- if (!empty($extrafields->attributes[$object->table_element]['label'])) {
- foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
- $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
- }
- }
- // Add fields from hooks
- $parameters = array();
- $reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- $sql .= $hookmanager->resPrint;
- $sql .= ' FROM '.MAIN_DB_PREFIX.'product as p';
- if (!empty($conf->global->MAIN_PRODUCT_PERENTITY_SHARED)) {
- $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int) $conf->entity);
- }
- if (!empty($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
- $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product_extrafields as ef on (p.rowid = ef.fk_object)";
- }
- if (!empty($searchCategoryProductList) || !empty($catid)) {
- $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX."categorie_product as cp ON p.rowid = cp.fk_product"; // We'll need this table joined to the select in order to filter by categ
- }
- $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product_fournisseur_price as pfp ON p.rowid = pfp.fk_product";
- // multilang
- if (!empty($conf->global->MAIN_MULTILANGS)) {
- $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product_lang as pl ON pl.fk_product = p.rowid AND pl.lang = '".$db->escape($langs->getDefaultLang())."'";
- }
- if (!empty($conf->variants->enabled) && (!empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD) && !$show_childproducts)) {
- $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product_attribute_combination pac ON pac.fk_product_child = p.rowid";
- }
- if (!empty($conf->global->PRODUCT_USE_UNITS)) {
- $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_units cu ON cu.rowid = p.fk_unit";
- }
- $sql .= ' WHERE p.entity IN ('.getEntity('product').')';
- if ($sall) {
- $sql .= natural_search(array_keys($fieldstosearchall), $sall);
- }
- // if the type is not 1, we show all products (type = 0,2,3)
- if (dol_strlen($search_type) && $search_type != '-1') {
- if ($search_type == 1) {
- $sql .= " AND p.fk_product_type = 1";
- } else {
- $sql .= " AND p.fk_product_type <> 1";
- }
- }
- if (!empty($conf->variants->enabled) && (!empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD) && !$show_childproducts)) {
- $sql .= " AND pac.rowid IS NULL";
- }
- if ($search_id) {
- $sql .= natural_search('p.rowid', $search_id, 1);
- }
- if ($search_ref) {
- $sql .= natural_search('p.ref', $search_ref);
- }
- if ($search_label) {
- $sql .= natural_search('p.label', $search_label);
- }
- if ($search_barcode) {
- $sql .= natural_search('p.barcode', $search_barcode);
- }
- if (isset($search_tosell) && dol_strlen($search_tosell) > 0 && $search_tosell != -1) {
- $sql .= " AND p.tosell = ".((int) $search_tosell);
- }
- if (isset($search_tobuy) && dol_strlen($search_tobuy) > 0 && $search_tobuy != -1) {
- $sql .= " AND p.tobuy = ".((int) $search_tobuy);
- }
- if (isset($search_tobatch) && dol_strlen($search_tobatch) > 0 && $search_tobatch != -1) {
- $sql .= " AND p.tobatch = ".((int) $search_tobatch);
- }
- if ($search_vatrate) {
- $sql .= natural_search('p.tva_tx', $search_vatrate, 1);
- }
- if (dol_strlen($canvas) > 0) {
- $sql .= " AND p.canvas = '".$db->escape($canvas)."'";
- }
- if ($catid > 0) {
- $sql .= " AND cp.fk_categorie = ".((int) $catid);
- }
- if ($catid == -2) {
- $sql .= " AND cp.fk_categorie IS NULL";
- }
- $searchCategoryProductSqlList = array();
- if ($searchCategoryProductOperator == 1) {
- foreach ($searchCategoryProductList as $searchCategoryProduct) {
- if (intval($searchCategoryProduct) == -2) {
- $searchCategoryProductSqlList[] = "cp.fk_categorie IS NULL";
- } elseif (intval($searchCategoryProduct) > 0) {
- $searchCategoryProductSqlList[] = "cp.fk_categorie = ".$db->escape($searchCategoryProduct);
- }
- }
- if (!empty($searchCategoryProductSqlList)) {
- $sql .= " AND (".implode(' OR ', $searchCategoryProductSqlList).")";
- }
- } else {
- foreach ($searchCategoryProductList as $searchCategoryProduct) {
- if (intval($searchCategoryProduct) == -2) {
- $searchCategoryProductSqlList[] = "cp.fk_categorie IS NULL";
- } elseif (intval($searchCategoryProduct) > 0) {
- $searchCategoryProductSqlList[] = "p.rowid IN (SELECT fk_product FROM ".MAIN_DB_PREFIX."categorie_product WHERE fk_categorie = ".((int) $searchCategoryProduct).")";
- }
- }
- if (!empty($searchCategoryProductSqlList)) {
- $sql .= " AND (".implode(' AND ', $searchCategoryProductSqlList).")";
- }
- }
- if ($fourn_id > 0) {
- $sql .= " AND pfp.fk_soc = ".((int) $fourn_id);
- }
- if ($search_country) {
- $sql .= " AND p.fk_country = ".((int) $search_country);
- }
- if ($search_state) {
- $sql .= " AND p.fk_state = ".((int) $search_state);
- }
- if ($search_finished >= 0 && $search_finished !== '') {
- $sql .= " AND p.finished = ".((int) $search_finished);
- }
- if ($search_accountancy_code_sell) {
- $sql .= natural_search($alias_product_perentity . '.accountancy_code_sell', $search_accountancy_code_sell);
- }
- if ($search_accountancy_code_sell_intra) {
- $sql .= natural_search($alias_product_perentity . '.accountancy_code_sell_intra', $search_accountancy_code_sell_intra);
- }
- if ($search_accountancy_code_sell_export) {
- $sql .= natural_search($alias_product_perentity . '.accountancy_code_sell_export', $search_accountancy_code_sell_export);
- }
- if ($search_accountancy_code_buy) {
- $sql .= natural_search($alias_product_perentity . '.accountancy_code_buy', $search_accountancy_code_buy);
- }
- if ($search_accountancy_code_buy_intra) {
- $sql .= natural_search($alias_product_perentity . '.accountancy_code_buy_intra', $search_accountancy_code_buy_intra);
- }
- if ($search_accountancy_code_buy_export) {
- $sql .= natural_search($alias_product_perentity . '.accountancy_code_buy_export', $search_accountancy_code_buy_export);
- }
- // Add where from extra fields
- include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
- // Add where from hooks
- $parameters = array();
- $reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- $sql .= $hookmanager->resPrint;
- $sql .= " GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.tva_tx, p.price_ttc, p.price_base_type,";
- $sql .= " p.fk_product_type, p.duration, p.finished, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock,";
- $sql .= ' p.datec, p.tms, p.entity, p.tobatch, p.pmp, p.cost_price, p.stock,';
- if (empty($conf->global->MAIN_PRODUCT_PERENTITY_SHARED)) {
- $sql .= " p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export,";
- } else {
- $sql .= " ppe.accountancy_code_sell, ppe.accountancy_code_sell_intra, ppe.accountancy_code_sell_export, ppe.accountancy_code_buy, ppe.accountancy_code_buy_intra, ppe.accountancy_code_buy_export,";
- }
- $sql .= ' p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units, p.fk_country, p.fk_state';
- if (!empty($conf->global->PRODUCT_USE_UNITS)) {
- $sql .= ', p.fk_unit, cu.label';
- }
- if (!empty($conf->variants->enabled) && (!empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD) && !$show_childproducts)) {
- $sql .= ', pac.rowid';
- }
- // Add fields from extrafields
- if (!empty($extrafields->attributes[$object->table_element]['label'])) {
- foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
- $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key : '');
- }
- }
- // Add fields from hooks
- $parameters = array();
- $reshook = $hookmanager->executeHooks('printFieldSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- $sql .= $hookmanager->resPrint;
- //if (GETPOST("toolowstock")) $sql.= " HAVING SUM(s.reel) < p.seuil_stock_alerte"; // Not used yet
- $sql .= $db->order($sortfield, $sortorder);
- $nbtotalofrecords = '';
- if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
- $result = $db->query($sql);
- $nbtotalofrecords = $db->num_rows($result);
- if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller then paging size (filtering), goto and load page 0
- $page = 0;
- $offset = 0;
- }
- }
- $sql .= $db->plimit($limit + 1, $offset);
- $resql = $db->query($sql);
- if ($resql) {
- $num = $db->num_rows($resql);
- $arrayofselected = is_array($toselect) ? $toselect : array();
- if ($num == 1 && !empty($conf->global->MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE) && $sall) {
- $obj = $db->fetch_object($resql);
- $id = $obj->rowid;
- header("Location: ".DOL_URL_ROOT.'/product/card.php?id='.$id);
- exit;
- }
- $helpurl = '';
- if ($search_type != '') {
- if ($search_type == 0) {
- $helpurl = 'EN:Module_Products|FR:Module_Produits|ES:Módulo_Productos';
- } elseif ($search_type == 1) {
- $helpurl = 'EN:Module_Services_En|FR:Module_Services|ES:Módulo_Servicios';
- }
- }
- $paramsCat = '';
- foreach ($searchCategoryProductList as $searchCategoryProduct) {
- $paramsCat .= "&search_category_product_list[]=".urlencode($searchCategoryProduct);
- }
- //llxHeader('', $title, $helpurl, '', 0, 0, array(), array(), $paramsCat, 'classforhorizontalscrolloftabs');
- llxHeader('', $title, $helpurl, '', 0, 0, array(), array(), $paramsCat, '');
- // Displays product removal confirmation
- if (GETPOST('delprod')) {
- setEventMessages($langs->trans("ProductDeleted", GETPOST('delprod')), null, 'mesgs');
- }
- $param = '';
- if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
- $param .= '&contextpage='.urlencode($contextpage);
- }
- if ($limit > 0 && $limit != $conf->liste_limit) {
- $param .= '&limit='.urlencode($limit);
- }
- if ($sall) {
- $param .= "&sall=".urlencode($sall);
- }
- if ($searchCategoryProductOperator == 1) {
- $param .= "&search_category_product_operator=".urlencode($searchCategoryProductOperator);
- }
- foreach ($searchCategoryProductList as $searchCategoryProduct) {
- $param .= "&search_category_product_list[]=".urlencode($searchCategoryProduct);
- }
- if ($search_ref) {
- $param = "&search_ref=".urlencode($search_ref);
- }
- if ($search_ref_supplier) {
- $param = "&search_ref_supplier=".urlencode($search_ref_supplier);
- }
- if ($search_barcode) {
- $param .= ($search_barcode ? "&search_barcode=".urlencode($search_barcode) : "");
- }
- if ($search_label) {
- $param .= "&search_label=".urlencode($search_label);
- }
- if ($search_tosell != '') {
- $param .= "&search_tosell=".urlencode($search_tosell);
- }
- if ($search_tobuy != '') {
- $param .= "&search_tobuy=".urlencode($search_tobuy);
- }
- if ($search_tobatch) {
- $param = "&search_tobatch=".urlencode($search_tobatch);
- }
- if ($search_country != '') {
- $param .= "&search_country=".urlencode($search_country);
- }
- if ($search_state != '') {
- $param .= "&search_state=".urlencode($search_state);
- }
- if ($search_vatrate) {
- $param = "&search_vatrate=".urlencode($search_vatrate);
- }
- if ($fourn_id > 0) {
- $param .= "&fourn_id=".urlencode($fourn_id);
- }
- //if ($seach_categ) $param.=($search_categ?"&search_categ=".urlencode($search_categ):"");
- if ($show_childproducts) {
- $param .= ($show_childproducts ? "&search_show_childproducts=".urlencode($show_childproducts) : "");
- }
- if ($type != '') {
- $param .= '&type='.urlencode($type);
- }
- if ($search_type != '') {
- $param .= '&search_type='.urlencode($search_type);
- }
- if ($optioncss != '') {
- $param .= '&optioncss='.urlencode($optioncss);
- }
- if ($search_accountancy_code_sell) {
- $param = "&search_accountancy_code_sell=".urlencode($search_accountancy_code_sell);
- }
- if ($search_accountancy_code_sell_intra) {
- $param = "&search_accountancy_code_sell_intra=".urlencode($search_accountancy_code_sell_intra);
- }
- if ($search_accountancy_code_sell_export) {
- $param = "&search_accountancy_code_sell_export=".urlencode($search_accountancy_code_sell_export);
- }
- if ($search_accountancy_code_buy) {
- $param = "&search_accountancy_code_buy=".urlencode($search_accountancy_code_buy);
- }
- if ($search_accountancy_code_buy_intra) {
- $param = "&search_accountancy_code_buy_intra=".urlencode($search_accountancy_code_buy_intra);
- }
- if ($search_accountancy_code_buy_export) {
- $param = "&search_accountancy_code_buy_export=".urlencode($search_accountancy_code_buy_export);
- }
- if ($search_finished) {
- $param = "&search_finished=".urlencode($search_finished);
- }
- // Add $param from extra fields
- include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
- // List of mass actions available
- $arrayofmassactions = array(
- 'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
- 'edit_extrafields'=>img_picto('', 'edit', 'class="pictofixedwidth"').$langs->trans("ModifyValueExtrafields"),
- //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
- //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
- );
- if ($user->rights->{$rightskey}->supprimer) {
- $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
- }
- if ($user->rights->{$rightskey}->creer) {
- $arrayofmassactions['switchonsalestatus'] = img_picto('', 'stop-circle', 'class="pictofixedwidth"').$langs->trans("SwitchOnSaleStatus");
- $arrayofmassactions['switchonpurchasestatus'] = img_picto('', 'stop-circle', 'class="pictofixedwidth"').$langs->trans("SwitchOnPurchaseStatus");
- $arrayofmassactions['preaffecttag'] = img_picto('', 'category', 'class="pictofixedwidth"').$langs->trans("AffectTag");
- }
- if (in_array($massaction, array('presend', 'predelete','preaffecttag', 'edit_extrafields'))) {
- $arrayofmassactions = array();
- }
- $massactionbutton = $form->selectMassAction('', $arrayofmassactions);
- $newcardbutton = '';
- if ($type === "") {
- $perm = ($user->rights->produit->creer || $user->rights->service->creer);
- } elseif ($type == Product::TYPE_SERVICE) {
- $perm = $user->rights->service->creer;
- } elseif ($type == Product::TYPE_PRODUCT) {
- $perm = $user->rights->produit->creer;
- }
- $oldtype = $type;
- $params = array();
- if ($type === "") {
- $params['forcenohideoftext'] = 1;
- }
- if ($type === "") {
- $newcardbutton .= dolGetButtonTitle($langs->trans('NewProduct'), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/product/card.php?action=create&type=0', '', $perm, $params);
- $type = Product::TYPE_SERVICE;
- }
- $label = 'NewProduct';
- if ($type == Product::TYPE_SERVICE) {
- $label = 'NewService';
- }
- $newcardbutton .= dolGetButtonTitle($langs->trans($label), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/product/card.php?action=create&type='.$type, '', $perm, $params);
- $type = $oldtype;
- print '<form action="'.$_SERVER["PHP_SELF"].'" method="post" name="formulaire">';
- if ($optioncss != '') {
- print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
- }
- print '<input type="hidden" name="token" value="'.newToken().'">';
- print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
- print '<input type="hidden" name="action" value="list">';
- print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
- print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
- //print '<input type="hidden" name="page" value="'.$page.'">';
- print '<input type="hidden" name="type" value="'.$type.'">';
- if (empty($arrayfields['p.fk_product_type']['checked'])) {
- print '<input type="hidden" name="search_type" value="'.dol_escape_htmltag($search_type).'">';
- }
- $picto = 'product';
- if ($type == 1) {
- $picto = 'service';
- }
- print_barre_liste($texte, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, $picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
- $topicmail = "Information";
- $modelmail = "product";
- $objecttmp = new Product($db);
- $trackid = 'prod'.$object->id;
- include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
- if (!empty($catid)) {
- print "<div id='ways'>";
- $c = new Categorie($db);
- $ways = $c->print_all_ways(' > ', 'product/list.php');
- print " > ".$ways[0]."<br>\n";
- print "</div><br>";
- }
- if ($sall) {
- $setupstring = '';
- foreach ($fieldstosearchall as $key => $val) {
- $fieldstosearchall[$key] = $langs->trans($val);
- $setupstring .= $key."=".$val.";";
- }
- print '<!-- Search done like if PRODUCT_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
- print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $sall).join(', ', $fieldstosearchall).'</div>'."\n";
- }
- // Filter on categories
- $moreforfilter = '';
- if (!empty($conf->categorie->enabled) && $user->rights->categorie->lire) {
- $moreforfilter .= '<div class="divsearchfield">';
- $moreforfilter .= img_picto($langs->trans('Categories'), 'category', 'class="pictofixedwidth"');
- $categoriesProductArr = $form->select_all_categories(Categorie::TYPE_PRODUCT, '', '', 64, 0, 1);
- $categoriesProductArr[-2] = '- '.$langs->trans('NotCategorized').' -';
- $moreforfilter .= Form::multiselectarray('search_category_product_list', $categoriesProductArr, $searchCategoryProductList, 0, 0, 'minwidth300');
- $moreforfilter .= ' <input type="checkbox" class="valignmiddle" id="search_category_product_operator" name="search_category_product_operator" value="1"'.($searchCategoryProductOperator == 1 ? ' checked="checked"' : '').'/><label class="none valignmiddle" for="search_category_product_operator">'.$langs->trans('UseOrOperatorForCategories').'</label>';
- $moreforfilter .= '</div>';
- }
- //Show/hide child products. Hidden by default
- if (!empty($conf->variants->enabled) && !empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD)) {
- $moreforfilter .= '<div class="divsearchfield">';
- $moreforfilter .= '<input type="checkbox" id="search_show_childproducts" name="search_show_childproducts"'.($show_childproducts ? 'checked="checked"' : '').'>';
- $moreforfilter .= ' <label for="search_show_childproducts">'.$langs->trans('ShowChildProducts').'</label>';
- $moreforfilter .= '</div>';
- }
- $parameters = array();
- $reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- if (empty($reshook)) {
- $moreforfilter .= $hookmanager->resPrint;
- } else {
- $moreforfilter = $hookmanager->resPrint;
- }
- if ($moreforfilter) {
- print '<div class="liste_titre liste_titre_bydiv centpercent">';
- print $moreforfilter;
- print '</div>';
- }
- $varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
- $selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
- if ($massactionbutton) {
- $selectedfields .= $form->showCheckAddButtons('checkforselect', 1);
- }
- print '<div class="div-table-responsive">';
- print '<table class="tagtable liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
- // Lines with input filters
- print '<tr class="liste_titre_filter">';
- if (!empty($arrayfields['p.rowid']['checked'])) {
- print '<td class="liste_titre left">';
- print '<input class="flat" type="text" name="search_id" size="4" value="'.dol_escape_htmltag($search_id).'">';
- print '</td>';
- }
- if (!empty($arrayfields['p.ref']['checked'])) {
- print '<td class="liste_titre left">';
- print '<input class="flat" type="text" name="search_ref" size="8" value="'.dol_escape_htmltag($search_ref).'">';
- print '</td>';
- }
- if (!empty($arrayfields['pfp.ref_fourn']['checked'])) {
- print '<td class="liste_titre left">';
- print '<input class="flat" type="text" name="search_ref_supplier" size="8" value="'.dol_escape_htmltag($search_ref_supplier).'">';
- print '</td>';
- }
- // Thumbnail
- if (!empty($arrayfields['thumbnail']['checked'])) {
- print '<td class="liste_titre center">';
- print '</td>';
- }
- if (!empty($arrayfields['p.label']['checked'])) {
- print '<td class="liste_titre left">';
- print '<input class="flat" type="text" name="search_label" size="12" value="'.dol_escape_htmltag($search_label).'">';
- print '</td>';
- }
- // Type
- if (!empty($arrayfields['p.fk_product_type']['checked'])) {
- print '<td class="liste_titre center">';
- $array = array('-1'=>' ', '0'=>$langs->trans('Product'), '1'=>$langs->trans('Service'));
- print $form->selectarray('search_type', $array, $search_type);
- print '</td>';
- }
- // Barcode
- if (!empty($arrayfields['p.barcode']['checked'])) {
- print '<td class="liste_titre">';
- print '<input class="flat" type="text" name="search_barcode" size="6" value="'.dol_escape_htmltag($search_barcode).'">';
- print '</td>';
- }
- // Duration
- if (!empty($arrayfields['p.duration']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Finished
- if (!empty($arrayfields['p.finished']['checked'])) {
- print '<td class="liste_titre">';
- print $formproduct->selectProductNature('search_finished', $search_finished);
- print '</td>';
- }
- // Weight
- if (!empty($arrayfields['p.weight']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Weight units
- if (!empty($arrayfields['p.weight_units']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Length
- if (!empty($arrayfields['p.length']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Length units
- if (!empty($arrayfields['p.length_units']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Width
- if (!empty($arrayfields['p.width']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Width units
- if (!empty($arrayfields['p.width_units']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Height
- if (!empty($arrayfields['p.height']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Height units
- if (!empty($arrayfields['p.height_units']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Surface
- if (!empty($arrayfields['p.surface']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Surface units
- if (!empty($arrayfields['p.surface_units']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Volume
- if (!empty($arrayfields['p.volume']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Volume units
- if (!empty($arrayfields['p.volume_units']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Unit
- if (!empty($arrayfields['cu.label']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Sell price
- if (!empty($arrayfields['p.sellprice']['checked'])) {
- print '<td class="liste_titre right">';
- print '</td>';
- }
- // Multiprice
- if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
- foreach ($arraypricelevel as $key => $value) {
- if (!empty($arrayfields['p.sellprice'.$key]['checked'])) {
- print '<td class="liste_titre right">';
- print '</td>';
- }
- }
- }
- // Minimum buying Price
- if (!empty($arrayfields['p.minbuyprice']['checked'])) {
- print '<td class="liste_titre">';
- print ' ';
- print '</td>';
- }
- // Number buying Price
- if (!empty($arrayfields['p.numbuyprice']['checked'])) {
- print '<td class="liste_titre">';
- print ' ';
- print '</td>';
- }
- // Sell price
- if (!empty($arrayfields['p.tva_tx']['checked'])) {
- print '<td class="liste_titre right">';
- print '<input class="right flat maxwidth50" placeholder="%" type="text" name="search_vatrate" size="1" value="'.dol_escape_htmltag($search_vatrate).'">';
- print '</td>';
- }
- // WAP
- if (!empty($arrayfields['p.pmp']['checked'])) {
- print '<td class="liste_titre">';
- print ' ';
- print '</td>';
- }
- // cost_price
- if (!empty($arrayfields['p.cost_price']['checked'])) {
- print '<td class="liste_titre">';
- print ' ';
- print '</td>';
- }
- // Limit for alert
- if (!empty($arrayfields['p.seuil_stock_alerte']['checked'])) {
- print '<td class="liste_titre">';
- print ' ';
- print '</td>';
- }
- // Desired stock
- if (!empty($arrayfields['p.desiredstock']['checked'])) {
- print '<td class="liste_titre">';
- print ' ';
- print '</td>';
- }
- // Stock
- if (!empty($arrayfields['p.stock']['checked'])) {
- print '<td class="liste_titre"> </td>';
- }
- // Stock
- if (!empty($arrayfields['stock_virtual']['checked'])) {
- print '<td class="liste_titre"> </td>';
- }
- // To batch
- if (!empty($arrayfields['p.tobatch']['checked'])) {
- print '<td class="liste_titre center">';
- $statutarray = array(
- '-1' => '',
- '0' => $langs->trans("ProductStatusNotOnBatchShort"),
- '1' => $langs->trans("ProductStatusOnBatchShort"),
- '2' => $langs->trans("ProductStatusOnSerialShort")
- );
- print $form->selectarray('search_tobatch', $statutarray, $search_tobatch);
- print '</td>';
- }
- // Country
- if (!empty($arrayfields['p.fk_country']['checked'])) {
- print '<td class="liste_titre center">';
- print $form->select_country($search_country, 'search_country', '', 0);
- print '</td>';
- }
- // State
- if (!empty($arrayfields['p.fk_state']['checked'])) {
- print '<td class="liste_titre center">';
- print $formcompany->select_state($search_state, $search_country);
- print '</td>';
- }
- // Accountancy code sell
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell']['checked'])) {
- print '<td class="liste_titre"><input class="flat maxwidth75" type="text" name="search_accountancy_code_sell" value="'.dol_escape_htmltag($search_accountancy_code_sell).'"></td>';
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell_intra']['checked'])) {
- print '<td class="liste_titre"><input class="flat maxwidth75" type="text" name="search_accountancy_code_sell_intra" value="'.dol_escape_htmltag($search_accountancy_code_sell_intra).'"></td>';
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell_export']['checked'])) {
- print '<td class="liste_titre"><input class="flat maxwidth75" type="text" name="search_accountancy_code_sell_export" value="'.dol_escape_htmltag($search_accountancy_code_sell_export).'"></td>';
- }
- // Accountancy code buy
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy']['checked'])) {
- print '<td class="liste_titre"><input class="flat maxwidth75" type="text" name="search_accountancy_code_buy" value="'.dol_escape_htmltag($search_accountancy_code_buy).'"></td>';
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy_intra']['checked'])) {
- print '<td class="liste_titre"><input class="flat maxwidth75" type="text" name="search_accountancy_code_buy_intra" value="'.dol_escape_htmltag($search_accountancy_code_buy_intra).'"></td>';
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy_export']['checked'])) {
- print '<td class="liste_titre"><input class="flat maxwidth75" type="text" name="search_accountancy_code_buy_export" value="'.dol_escape_htmltag($search_accountancy_code_buy_export).'"></td>';
- }
- // Extra fields
- include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
- // Fields from hook
- $parameters = array('arrayfields'=>$arrayfields);
- $reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- print $hookmanager->resPrint;
- // Date creation
- if (!empty($arrayfields['p.datec']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- // Date modification
- if (!empty($arrayfields['p.tms']['checked'])) {
- print '<td class="liste_titre">';
- print '</td>';
- }
- if (!empty($arrayfields['p.tosell']['checked'])) {
- print '<td class="liste_titre center">';
- print $form->selectarray('search_tosell', array('0'=>$langs->trans('ProductStatusNotOnSellShort'), '1'=>$langs->trans('ProductStatusOnSellShort')), $search_tosell, 1);
- print '</td >';
- }
- if (!empty($arrayfields['p.tobuy']['checked'])) {
- print '<td class="liste_titre center">';
- print $form->selectarray('search_tobuy', array('0'=>$langs->trans('ProductStatusNotOnBuyShort'), '1'=>$langs->trans('ProductStatusOnBuyShort')), $search_tobuy, 1);
- print '</td>';
- }
- print '<td class="liste_titre center maxwidthsearch">';
- $searchpicto = $form->showFilterButtons();
- print $searchpicto;
- print '</td>';
- print '</tr>';
- print '<tr class="liste_titre">';
- if (!empty($arrayfields['p.rowid']['checked'])) {
- print_liste_field_titre($arrayfields['p.rowid']['label'], $_SERVER["PHP_SELF"], "p.rowid", "", $param, "", $sortfield, $sortorder);
- }
- if (!empty($arrayfields['p.ref']['checked'])) {
- print_liste_field_titre($arrayfields['p.ref']['label'], $_SERVER["PHP_SELF"], "p.ref", "", $param, "", $sortfield, $sortorder);
- }
- if (!empty($arrayfields['pfp.ref_fourn']['checked'])) {
- print_liste_field_titre($arrayfields['pfp.ref_fourn']['label'], $_SERVER["PHP_SELF"], "pfp.ref_fourn", "", $param, "", $sortfield, $sortorder);
- }
- if (!empty($arrayfields['thumbnail']['checked'])) {
- print_liste_field_titre($arrayfields['thumbnail']['label'], $_SERVER["PHP_SELF"], '', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.label']['checked'])) {
- print_liste_field_titre($arrayfields['p.label']['label'], $_SERVER["PHP_SELF"], "p.label", "", $param, "", $sortfield, $sortorder);
- }
- if (!empty($arrayfields['p.fk_product_type']['checked'])) {
- print_liste_field_titre($arrayfields['p.fk_product_type']['label'], $_SERVER["PHP_SELF"], "p.fk_product_type", "", $param, "", $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.barcode']['checked'])) {
- print_liste_field_titre($arrayfields['p.barcode']['label'], $_SERVER["PHP_SELF"], "p.barcode", "", $param, "", $sortfield, $sortorder);
- }
- if (!empty($arrayfields['p.duration']['checked'])) {
- print_liste_field_titre($arrayfields['p.duration']['label'], $_SERVER["PHP_SELF"], "p.duration", "", $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.finished']['checked'])) {
- print_liste_field_titre($arrayfields['p.finished']['label'], $_SERVER["PHP_SELF"], "p.finished", "", $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.weight']['checked'])) {
- print_liste_field_titre($arrayfields['p.weight']['label'], $_SERVER['PHP_SELF'], 'p.weight', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.weight_units']['checked'])) {
- print_liste_field_titre($arrayfields['p.weight_units']['label'], $_SERVER['PHP_SELF'], 'p.weight_units', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.length']['checked'])) {
- print_liste_field_titre($arrayfields['p.length']['label'], $_SERVER['PHP_SELF'], 'p.length', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.length_units']['checked'])) {
- print_liste_field_titre($arrayfields['p.length_units']['label'], $_SERVER['PHP_SELF'], 'p.length_units', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.width']['checked'])) {
- print_liste_field_titre($arrayfields['p.width']['label'], $_SERVER['PHP_SELF'], 'p.width', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.width_units']['checked'])) {
- print_liste_field_titre($arrayfields['p.width_units']['label'], $_SERVER['PHP_SELF'], 'p.width_units', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.height']['checked'])) {
- print_liste_field_titre($arrayfields['p.height']['label'], $_SERVER['PHP_SELF'], 'p.height', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.height_units']['checked'])) {
- print_liste_field_titre($arrayfields['p.height_units']['label'], $_SERVER['PHP_SELF'], 'p.height_units', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.surface']['checked'])) {
- print_liste_field_titre($arrayfields['p.surface']['label'], $_SERVER['PHP_SELF'], "p.surface", '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.surface_units']['checked'])) {
- print_liste_field_titre($arrayfields['p.surface_units']['label'], $_SERVER['PHP_SELF'], 'p.surface_units', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.volume']['checked'])) {
- print_liste_field_titre($arrayfields['p.volume']['label'], $_SERVER['PHP_SELF'], 'p.volume', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.volume_units']['checked'])) {
- print_liste_field_titre($arrayfields['p.volume_units']['label'], $_SERVER['PHP_SELF'], 'p.volume_units', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['cu.label']['checked'])) {
- print_liste_field_titre($arrayfields['cu.label']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.sellprice']['checked'])) {
- print_liste_field_titre($arrayfields['p.sellprice']['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- // Multiprices
- if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
- foreach ($arraypricelevel as $key => $value) {
- if (!empty($arrayfields['p.sellprice'.$key]['checked'])) {
- print_liste_field_titre($arrayfields['p.sellprice'.$key]['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- }
- }
- if (!empty($arrayfields['p.minbuyprice']['checked'])) {
- print_liste_field_titre($arrayfields['p.minbuyprice']['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.numbuyprice']['checked'])) {
- print_liste_field_titre($arrayfields['p.numbuyprice']['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.tva_tx']['checked'])) {
- print_liste_field_titre($arrayfields['p.tva_tx']['label'], $_SERVER["PHP_SELF"], 'p.tva_tx', "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.pmp']['checked'])) {
- print_liste_field_titre($arrayfields['p.pmp']['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.cost_price']['checked'])) {
- print_liste_field_titre($arrayfields['p.cost_price']['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.seuil_stock_alerte']['checked'])) {
- print_liste_field_titre($arrayfields['p.seuil_stock_alerte']['label'], $_SERVER["PHP_SELF"], "p.seuil_stock_alerte", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.desiredstock']['checked'])) {
- print_liste_field_titre($arrayfields['p.desiredstock']['label'], $_SERVER["PHP_SELF"], "p.desiredstock", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.stock']['checked'])) {
- print_liste_field_titre($arrayfields['p.stock']['label'], $_SERVER["PHP_SELF"], "p.stock", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['stock_virtual']['checked'])) {
- print_liste_field_titre($arrayfields['stock_virtual']['label'], $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
- }
- if (!empty($arrayfields['p.tobatch']['checked'])) {
- print_liste_field_titre($arrayfields['p.tobatch']['label'], $_SERVER["PHP_SELF"], "p.tobatch", "", $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.fk_country']['checked'])) {
- print_liste_field_titre($arrayfields['p.fk_country']['label'], $_SERVER["PHP_SELF"], "p.fk_country", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields['p.fk_state']['checked'])) {
- print_liste_field_titre($arrayfields['p.fk_state']['label'], $_SERVER["PHP_SELF"], "p.fk_state", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell']['checked'])) {
- print_liste_field_titre($arrayfields[$alias_product_perentity . '.accountancy_code_sell']['label'], $_SERVER["PHP_SELF"], $alias_product_perentity . ".accountancy_code_sell", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell_intra']['checked'])) {
- print_liste_field_titre($arrayfields[$alias_product_perentity . '.accountancy_code_sell_intra']['label'], $_SERVER["PHP_SELF"], $alias_product_perentity . ".accountancy_code_sell_intra", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell_export']['checked'])) {
- print_liste_field_titre($arrayfields[$alias_product_perentity . '.accountancy_code_sell_export']['label'], $_SERVER["PHP_SELF"], $alias_product_perentity . ".accountancy_code_sell_export", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy']['checked'])) {
- print_liste_field_titre($arrayfields[$alias_product_perentity . '.accountancy_code_buy']['label'], $_SERVER["PHP_SELF"], $alias_product_perentity . ".accountancy_code_buy", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy_intra']['checked'])) {
- print_liste_field_titre($arrayfields[$alias_product_perentity . '.accountancy_code_buy_intra']['label'], $_SERVER["PHP_SELF"], $alias_product_perentity . ".accountancy_code_buy_intra", "", $param, '', $sortfield, $sortorder);
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy_export']['checked'])) {
- print_liste_field_titre($arrayfields[$alias_product_perentity . '.accountancy_code_buy_export']['label'], $_SERVER["PHP_SELF"], $alias_product_perentity . ".accountancy_code_buy_export", "", $param, '', $sortfield, $sortorder);
- }
- // Extra fields
- include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
- // Hook fields
- $parameters = array('arrayfields'=>$arrayfields, 'param'=>$param, 'sortfield'=>$sortfield, 'sortorder'=>$sortorder);
- $reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- print $hookmanager->resPrint;
- if (!empty($arrayfields['p.datec']['checked'])) {
- print_liste_field_titre($arrayfields['p.datec']['label'], $_SERVER["PHP_SELF"], "p.datec", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
- }
- if (!empty($arrayfields['p.tms']['checked'])) {
- print_liste_field_titre($arrayfields['p.tms']['label'], $_SERVER["PHP_SELF"], "p.tms", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
- }
- if (!empty($arrayfields['p.tosell']['checked'])) {
- print_liste_field_titre($arrayfields['p.tosell']['label'], $_SERVER["PHP_SELF"], "p.tosell", "", $param, '', $sortfield, $sortorder, 'center ');
- }
- if (!empty($arrayfields['p.tobuy']['checked'])) {
- print_liste_field_titre($arrayfields['p.tobuy']['label'], $_SERVER["PHP_SELF"], "p.tobuy", "", $param, '', $sortfield, $sortorder, 'center ');
- }
- print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ');
- print "</tr>\n";
- $product_static = new Product($db);
- $product_fourn = new ProductFournisseur($db);
- $i = 0;
- $totalarray = array();
- $totalarray['nbfield'] = 0;
- while ($i < min($num, $limit)) {
- $obj = $db->fetch_object($resql);
- // Multilangs
- if (!empty($conf->global->MAIN_MULTILANGS)) { // If multilang is enabled
- $sql = "SELECT label";
- $sql .= " FROM ".MAIN_DB_PREFIX."product_lang";
- $sql .= " WHERE fk_product = ".((int) $obj->rowid);
- $sql .= " AND lang = '".$db->escape($langs->getDefaultLang())."'";
- $sql .= " LIMIT 1";
- $result = $db->query($sql);
- if ($result) {
- $objtp = $db->fetch_object($result);
- if (!empty($objtp->label)) {
- $obj->label = $objtp->label;
- }
- }
- }
- $product_static->id = $obj->rowid;
- $product_static->ref = $obj->ref;
- $product_static->ref_fourn = empty($obj->ref_supplier) ? '' : $obj->ref_supplier; // deprecated
- $product_static->ref_supplier = empty($obj->ref_supplier) ? '' : $obj->ref_supplier;
- $product_static->label = $obj->label;
- $product_static->finished = $obj->finished;
- $product_static->type = $obj->fk_product_type;
- $product_static->status_buy = $obj->tobuy;
- $product_static->status = $obj->tosell;
- $product_static->status_batch = $obj->tobatch;
- $product_static->entity = $obj->entity;
- $product_static->pmp = $obj->pmp;
- $product_static->accountancy_code_sell = $obj->accountancy_code_sell;
- $product_static->accountancy_code_sell_export = $obj->accountancy_code_sell_export;
- $product_static->accountancy_code_sell_intra = $obj->accountancy_code_sell_intra;
- $product_static->accountancy_code_buy = $obj->accountancy_code_buy;
- $product_static->accountancy_code_buy_intra = $obj->accountancy_code_buy_intra;
- $product_static->accountancy_code_buy_export = $obj->accountancy_code_buy_export;
- $product_static->length = $obj->length;
- $product_static->length_units = $obj->length_units;
- $product_static->width = $obj->width;
- $product_static->width_units = $obj->width_units;
- $product_static->height = $obj->height;
- $product_static->height_units = $obj->height_units;
- $product_static->weight = $obj->weight;
- $product_static->weight_units = $obj->weight_units;
- $product_static->volume = $obj->volume;
- $product_static->volume_units = $obj->volume_units;
- $product_static->surface = $obj->surface;
- $product_static->surface_units = $obj->surface_units;
- if (!empty($conf->global->PRODUCT_USE_UNITS)) {
- $product_static->fk_unit = $obj->fk_unit;
- }
- // STOCK_DISABLE_OPTIM_LOAD can be set to force load_stock whatever is permissions on stock.
- if ((!empty($conf->stock->enabled) && $user->rights->stock->lire && $search_type != 1) || !empty($conf->global->STOCK_DISABLE_OPTIM_LOAD)) { // To optimize call of load_stock
- if ($obj->fk_product_type != 1 || !empty($conf->global->STOCK_SUPPORTS_SERVICES)) { // Not a service
- $option = 'nobatch';
- if (empty($arrayfields['stock_virtual']['checked'])) {
- $option .= ',novirtual';
- }
- $product_static->load_stock($option); // Load stock_reel + stock_warehouse. This can also call load_virtual_stock()
- }
- }
- print '<tr class="oddeven">';
- // Ref
- if (!empty($arrayfields['p.rowid']['checked'])) {
- print '<td class="nowraponall">';
- print $product_static->id;
- print "</td>\n";
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Ref
- if (!empty($arrayfields['p.ref']['checked'])) {
- print '<td class="tdoverflowmax200">';
- print $product_static->getNomUrl(1);
- print "</td>\n";
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Ref supplier
- if (!empty($arrayfields['pfp.ref_fourn']['checked'])) {
- print '<td class="tdoverflowmax200">';
- print $product_static->getNomUrl(1);
- print "</td>\n";
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Thumbnail
- if (!empty($arrayfields['thumbnail']['checked'])) {
- $product_thumbnail_html = '';
- if (!empty($product_static->entity)) {
- $product_thumbnail = $product_static->show_photos('product', $conf->product->multidir_output[$product_static->entity], 1, 1, 0, 0, 0, 80);
- if ($product_static->nbphoto > 0) {
- $product_thumbnail_html = $product_thumbnail;
- }
- }
- print '<td class="center">' . $product_thumbnail_html . '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Label
- if (!empty($arrayfields['p.label']['checked'])) {
- print '<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->label).'">'.$obj->label.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Type
- if (!empty($arrayfields['p.fk_product_type']['checked'])) {
- print '<td class="center">';
- $s = '';
- if ($obj->fk_product_type == 0) {
- $s .= img_picto($langs->trans("Product"), 'product', 'class="paddingleftonly paddingrightonly colorgrey"');
- } else {
- $s .= img_picto($langs->trans("Service"), 'service', 'class="paddingleftonly paddingrightonly colorgrey"');
- }
- print $s;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Barcode
- if (!empty($arrayfields['p.barcode']['checked'])) {
- print '<td>'.$obj->barcode.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Duration
- if (!empty($arrayfields['p.duration']['checked'])) {
- print '<td class="center nowraponall">';
- if (preg_match('/([^a-z]+)[a-z]$/i', $obj->duration)) {
- $duration_value = substr($obj->duration, 0, dol_strlen($obj->duration) - 1);
- $duration_unit = substr($obj->duration, -1);
- if ((float) $duration_value > 1) {
- $dur = array("i"=>$langs->trans("Minutes"), "h"=>$langs->trans("Hours"), "d"=>$langs->trans("Days"), "w"=>$langs->trans("Weeks"), "m"=>$langs->trans("Months"), "y"=>$langs->trans("Years"));
- } elseif ((float) $duration_value > 0) {
- $dur = array("i"=>$langs->trans("Minute"), "h"=>$langs->trans("Hour"), "d"=>$langs->trans("Day"), "w"=>$langs->trans("Week"), "m"=>$langs->trans("Month"), "y"=>$langs->trans("Year"));
- }
- print $duration_value;
- print ((!empty($duration_unit) && isset($dur[$duration_unit]) && $duration_value != '') ? ' '.$langs->trans($dur[$duration_unit]) : '');
- } elseif (!preg_match('/^[a-z]$/i', $obj->duration)) { // If duration is a simple char (like 's' of 'm'), we do not show value
- print $obj->duration;
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Finished
- if (!empty($arrayfields['p.finished']['checked'])) {
- print '<td class="center">';
- print $product_static->getLibFinished();
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Weight
- if (!empty($arrayfields['p.weight']['checked'])) {
- print '<td class="center">';
- print $obj->weight;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Weight units
- if (!empty($arrayfields['p.weight_units']['checked'])) {
- print '<td class="center">';
- if ($product_static->weight != '') {
- print measuringUnitString(0, 'weight', $product_static->weight_units);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Length
- if (!empty($arrayfields['p.length']['checked'])) {
- print '<td class="center">';
- print $obj->length;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Length units
- if (!empty($arrayfields['p.length_units']['checked'])) {
- print '<td class="center">';
- if ($product_static->length != '') {
- print measuringUnitString(0, 'size', $product_static->length_units);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Width
- if (!empty($arrayfields['p.width']['checked'])) {
- print '<td align="center">';
- print $obj->width;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Width units
- if (!empty($arrayfields['p.width_units']['checked'])) {
- print '<td class="center">';
- if ($product_static->width != '') {
- print measuringUnitString(0, 'size', $product_static->width_units);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Height
- if (!empty($arrayfields['p.height']['checked'])) {
- print '<td align="center">';
- print $obj->height;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Height units
- if (!empty($arrayfields['p.height_units']['checked'])) {
- print '<td class="center">';
- if ($product_static->height != '') {
- print measuringUnitString(0, 'size', $product_static->height_units);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Surface
- if (!empty($arrayfields['p.surface']['checked'])) {
- print '<td class="center">';
- print $obj->surface;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Surface units
- if (!empty($arrayfields['p.surface_units']['checked'])) {
- print '<td class="center">';
- if ($product_static->surface != '') {
- print measuringUnitString(0, 'surface', $product_static->surface_units);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Volume
- if (!empty($arrayfields['p.volume']['checked'])) {
- print '<td class="center">';
- print $obj->volume;
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Volume units
- if (!empty($arrayfields['p.volume_units']['checked'])) {
- print '<td class="center">';
- if ($product_static->volume != '') {
- print measuringUnitString(0, 'volume', $product_static->volume_units);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Unit
- if (!empty($arrayfields['cu.label']['checked'])) {
- print '<td align="center">';
- if (!empty($obj->cu_label)) {
- print $langs->trans($obj->cu_label);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Sell price
- if (!empty($arrayfields['p.sellprice']['checked'])) {
- print '<td class="right nowraponall">';
- if ($obj->tosell) {
- if ($obj->price_base_type == 'TTC') {
- print '<span class="amount">'.price($obj->price_ttc).' '.$langs->trans("TTC").'</span>';
- } else {
- print '<span class="amount">'.price($obj->price).' '.$langs->trans("HT").'</span>';
- }
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Multiprices
- if (! empty($conf->global->PRODUIT_MULTIPRICES)) {
- if (! isset($productpricescache)) {
- $productpricescache=array();
- }
- if (! isset($productpricescache[$obj->rowid])) {
- $productpricescache[$obj->rowid] = array();
- }
- if ($obj->tosell) {
- // Make 1 request for all price levels (without filter on price_level) and saved result into an cache array
- // then reuse the cache array if we need prices for other price levels
- $sqlp = "SELECT p.rowid, p.fk_product, p.price, p.price_ttc, p.price_level, p.date_price, p.price_base_type";
- $sqlp .= " FROM ".MAIN_DB_PREFIX."product_price as p";
- $sqlp .= " WHERE fk_product = ".((int) $obj->rowid);
- $sqlp .= " ORDER BY p.date_price DESC, p.rowid DESC, p.price_level ASC";
- $resultp = $db->query($sqlp);
- if ($resultp) {
- $nump = $db->num_rows($resultp);
- $j = 0;
- while ($j < $nump) {
- $objp = $db->fetch_object($resultp);
- if (empty($productpricescache[$obj->rowid][$objp->price_level])) {
- $productpricescache[$obj->rowid][$objp->price_level]['price'] = $objp->price;
- $productpricescache[$obj->rowid][$objp->price_level]['price_ttc'] = $objp->price_ttc;
- $productpricescache[$obj->rowid][$objp->price_level]['price_base_type'] = $objp->price_base_type;
- }
- $j++;
- }
- $db->free($resultp);
- } else {
- dol_print_error($db);
- }
- }
- foreach ($arraypricelevel as $key => $value) {
- if (!empty($arrayfields['p.sellprice'.$key]['checked'])) {
- print '<td class="right nowraponall">';
- if (!empty($productpricescache[$obj->rowid])) {
- if ($productpricescache[$obj->rowid][$key]['price_base_type'] == 'TTC') {
- print '<span class="amount">'.price($productpricescache[$obj->rowid][$key]['price_ttc']).' '.$langs->trans("TTC").'</span>';
- } else {
- print '<span class="amount">'.price($productpricescache[$obj->rowid][$key]['price']).' '.$langs->trans("HT").'</span>';
- }
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- }
- }
- // Better buy price
- if (!empty($arrayfields['p.minbuyprice']['checked'])) {
- print '<td class="right nowraponall">';
- if ($obj->tobuy && $obj->minsellprice != '') {
- //print price($obj->minsellprice).' '.$langs->trans("HT");
- if ($product_fourn->find_min_price_product_fournisseur($obj->rowid) > 0) {
- if ($product_fourn->product_fourn_price_id > 0) {
- if ((!empty($conf->fournisseur->enabled) && !empty($user->rights->fournisseur->lire) && empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD)) || (!empty($conf->supplier_order->enabled) && !empty($user->rights->supplier_order->lire)) || (!empty($conf->supplier_invoice->enabled) && !empty($user->rights->supplier_invoice->lire))) {
- $htmltext = $product_fourn->display_price_product_fournisseur(1, 1, 0, 1);
- print '<span class="amount">'.$form->textwithpicto(price($product_fourn->fourn_unitprice * (1 - $product_fourn->fourn_remise_percent / 100) - $product_fourn->fourn_remise).' '.$langs->trans("HT"), $htmltext).'</span>';
- } else {
- print '<span class="amount">'.price($product_fourn->fourn_unitprice).' '.$langs->trans("HT").'</span>';
- }
- }
- }
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Number of buy prices
- if (!empty($arrayfields['p.numbuyprice']['checked'])) {
- print '<td class="right">';
- if ($obj->tobuy) {
- if (count($productFournList = $product_fourn->list_product_fournisseur_price($obj->rowid)) > 0) {
- $htmltext = $product_fourn->display_price_product_fournisseur(1, 1, 0, 1, $productFournList);
- print $form->textwithpicto(count($productFournList), $htmltext);
- }
- }
- print '</td>';
- }
- // VAT or Sell Tax Rate
- if (!empty($arrayfields['p.tva_tx']['checked'])) {
- print '<td class="right">';
- print vatrate($obj->tva_tx, true);
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // WAP
- if (!empty($arrayfields['p.pmp']['checked'])) {
- print '<td class="nowrap right">';
- print '<span class="amount">'.price($product_static->pmp, 1, $langs)."</span>";
- print '</td>';
- }
- // Cost price
- if (!empty($arrayfields['p.cost_price']['checked'])) {
- print '<td class="nowrap right">';
- //print $obj->cost_price;
- print '<span class="amount">'.price($obj->cost_price).' '.$langs->trans("HT").'</span>';
- print '</td>';
- }
- // Limit alert
- if (!empty($arrayfields['p.seuil_stock_alerte']['checked'])) {
- print '<td class="right">';
- if ($obj->fk_product_type != 1) {
- print $obj->seuil_stock_alerte;
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Desired stock
- if (!empty($arrayfields['p.desiredstock']['checked'])) {
- print '<td class="right">';
- if ($obj->fk_product_type != 1) {
- print $obj->desiredstock;
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Stock real
- if (!empty($arrayfields['p.stock']['checked'])) {
- print '<td class="right">';
- if ($obj->fk_product_type != 1) {
- if ($obj->seuil_stock_alerte != '' && $product_static->stock_reel < (float) $obj->seuil_stock_alerte) {
- print img_warning($langs->trans("StockLowerThanLimit", $obj->seuil_stock_alerte)).' ';
- }
- print price(price2num($product_static->stock_reel, 'MS'));
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Stock virtual
- if (!empty($arrayfields['stock_virtual']['checked'])) {
- print '<td class="right">';
- if ($obj->fk_product_type != 1) {
- if ($obj->seuil_stock_alerte != '' && $product_static->stock_theorique < (float) $obj->seuil_stock_alerte) {
- print img_warning($langs->trans("StockLowerThanLimit", $obj->seuil_stock_alerte)).' ';
- }
- print price(price2num($product_static->stock_theorique, 'MS'));
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Lot/Serial
- if (!empty($arrayfields['p.tobatch']['checked'])) {
- print '<td class="center">';
- print $product_static->getLibStatut(1, 2);
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Country
- if (!empty($arrayfields['p.fk_country']['checked'])) {
- print '<td>'.getCountry($obj->fk_country, 0, $db).'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // State
- if (!empty($arrayfields['p.fk_state']['checked'])) {
- print '<td>';
- if (!empty($obj->fk_state)) {
- print getState($obj->fk_state, 0, $db);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Accountancy code sell
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell']['checked'])) {
- print '<td>'.$obj->accountancy_code_sell.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell_intra']['checked'])) {
- print '<td>'.$obj->accountancy_code_sell_intra.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_sell_export']['checked'])) {
- print '<td>'.$obj->accountancy_code_sell_export.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Accountancy code buy
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy']['checked'])) {
- print '<td>'.$obj->accountancy_code_buy.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy_intra']['checked'])) {
- print '<td>'.$obj->accountancy_code_buy_intra.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- if (!empty($arrayfields[$alias_product_perentity . '.accountancy_code_buy_export']['checked'])) {
- print '<td>'.$obj->accountancy_code_buy_export.'</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Extra fields
- include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
- // Fields from hook
- $parameters = array('arrayfields'=>$arrayfields, 'obj'=>$obj, 'i'=>$i, 'totalarray'=>&$totalarray);
- $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
- print $hookmanager->resPrint;
- // Date creation
- if (!empty($arrayfields['p.datec']['checked'])) {
- print '<td class="center nowraponall">';
- print dol_print_date($db->jdate($obj->date_creation), 'dayhour', 'tzuser');
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Date modification
- if (!empty($arrayfields['p.tms']['checked'])) {
- print '<td class="center nowraponall">';
- print dol_print_date($db->jdate($obj->date_update), 'dayhour', 'tzuser');
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Status (to sell)
- if (!empty($arrayfields['p.tosell']['checked'])) {
- print '<td class="center nowrap">';
- if (!empty($conf->use_javascript_ajax) && $user->rights->produit->creer && !empty($conf->global->MAIN_DIRECT_STATUS_UPDATE)) {
- print ajax_object_onoff($product_static, 'status', 'tosell', 'ProductStatusOnSell', 'ProductStatusNotOnSell');
- } else {
- print $product_static->LibStatut($obj->tosell, 5, 0);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Status (to buy)
- if (!empty($arrayfields['p.tobuy']['checked'])) {
- print '<td class="center nowrap">';
- if (!empty($conf->use_javascript_ajax) && $user->rights->produit->creer && !empty($conf->global->MAIN_DIRECT_STATUS_UPDATE)) {
- print ajax_object_onoff($product_static, 'status_buy', 'tobuy', 'ProductStatusOnBuy', 'ProductStatusNotOnBuy');
- } else {
- print $product_static->LibStatut($obj->tobuy, 5, 1);
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- }
- // Action
- print '<td class="nowrap center">';
- if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
- $selected = 0;
- if (in_array($obj->rowid, $arrayofselected)) {
- $selected = 1;
- }
- print '<input id="cb'.$obj->rowid.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
- }
- print '</td>';
- if (!$i) {
- $totalarray['nbfield']++;
- }
- print "</tr>\n";
- $i++;
- }
- $db->free($resql);
- print "</table>";
- print "</div>";
- print '</form>';
- } else {
- dol_print_error($db);
- }
- // End of page
- llxFooter();
- $db->close();
|