function display($tpl = null) { $doc =& JFactory::getDocument(); require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'includes' . DS . 'jaderp_tools.php'; $JAdERPTool =& new JAdERPTools(); $db =& JFactory::getDBO(); JHTML::stylesheet('datepicker.css', 'components/com_jaderp/css/'); JHTML::script('addfields.js', 'components/com_jaderp/js/'); JHTML::script('jaderp.js', 'components/com_jaderp/js/'); JHTML::script('supplierinit.js', 'components/com_jaderp/js/'); JHTML::script('jquery.qtip-1.0.0.min.js', 'includes/js/qtip/'); $supplier =& $this->get('Data'); $this->assignRef('supplier', $supplier); $id = JRequest::getInt('cid', 0); if (!$id) { $id = JRequest::getInt('id', 0); } $contacts = JAdERPTools::ReadTable("jaderp_supplier_contact", '*', 'WHERE supplier_id=' . $db->Quote($id), 'Object'); $this->assign('contacts', $contacts); $banks = JAdERPTools::ReadTable("jaderp_supplier_bank", '*', 'WHERE supplier_id=' . $db->Quote($id), 'Object'); $this->assign('banks', $banks); $countries = $JAdERPTool->ReadCountries(); $this->assign('countries', $countries); $currencies = $JAdERPTool->ReadCountries(false, true, '', '', 'Array'); $currency = JAdERPTools::selectHTML($currencies, 'currency', 'supplierCurrency', JText::_('SELECT_CURRENCY'), $supplier->currency); //echo '<textarea cols="80" rows="10" name="source">'.htmlspecialchars($currency)."</textarea>"; $this->assign('currencies', $currency); $task = JRequest::getCmd('task', 'view'); $accesses = $JAdERPTool->accessRights('jaderp_contacts', $task); $this->assign('contactAccesses', $accesses); $post = JRequest::get('post'); $accesses = $JAdERPTool->accessRights('jaderp_suppliers', $task); $this->assign('supplierAccesses', $accesses); $menuid = JRequest::getInt('menuid', 0); $this->assign('datas', $post); if ($menuid > 0) { $this->assign('menuid', $menuid); } else { $menuid = JAdERPTools::getmenuId(); $this->assign('menuid', $menuid); } parent::display($tpl); //require_once ('tmpl'.DS.'form.php'); }
/** * display the edit form * @return void */ function edit() { $model =& $this->getModel('Product'); $user =& JFactory::getUser(); require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'includes' . DS . 'jaderp_tools.php'; $JAdERPTool =& new JAdERPTools(); require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'includes' . DS . 'menubar.php'; $menubars =& new menuBar(); if ($user->get('id')) { $uid = $user->id; $access_level = $JAdERPTool->UserAccessLevel(); if (!$access_level) { $msg = JText::_('YOU_DONT_HAVE_PERMISSION'); $this->setRedirect(JRoute::_('index.php?option=com_jaderp&func=Products&task=manage'), $msg, 'notice'); return; } //echo $user->get('id'); } else { $msg = JText::_('YOU_MUST_CONNECT'); $this->setRedirect(JRoute::_('index.php?option=com_user&view=login'), $msg, 'notice'); } JTable::addIncludePath('components' . DS . 'com_jaderp' . DS . 'tables'); $table =& JTable::getInstance('products', 'Table'); $id = JRequest::getInt('cid', 0); if (!$id) { $id = JRequest::getInt('id', 0); } $table->load($id); //echo $id." ".$table->firstname; if ($table->checked_out !== $user->get('id') && $table->checked_out != 0) { $checkuser =& JFactory::getUser($table->checked_out); $msg = JText::sprintf('IS_CHECKEDOUT_ALERT', $checkuser->name, $table->checked_out_time); $this->setRedirect(JRoute::_('index.php?option=com_jaderp&func=Products&task=manage'), $msg, 'notice'); } else { if (!$table->checkOut($user->get('id'))) { $msg = JText::_('CANT_CHECKOUT_ALERT'); $this->setRedirect(JRoute::_('index.php?option=com_jaderp&task=desktop'), $msg, 'notice'); } } $menuid = JRequest::getInt('menuid', 0); if ($menuid == 0) { $menuid = JAdERPTools::getmenuId(); } if ($menuid) { $db = JFactory::getDBO(); $where = "WHERE " . $db->nameQuote('id') . "=" . $menuid; //echo $where; $menutbl = $JAdERPTool->ReadTable('jaderp_menu', '*', $where, 'Assoc', true); //echo $menutbl['menu_icon']; if ($menutbl) { $tache = $menutbl['menu_icon']; $tacheText = JText::_($menutbl['languagename']); } } if ($this->getTask() == 'edit') { $doc =& JFactory::getDocument(); $doc->addScriptdeclaration(' var blockMenu = true; '); } ?> <script language="javascript" type="text/javascript"> <!-- function submitbutton(pressbutton) { var form = document.adminForm; var xy; if (pressbutton == 'cancel') { submitform( pressbutton ); return; } if (form.elements["country[]"].value == ""){ alert( "<?php echo JText::_('COUNTRY_IS_REQUIRED', true); ?> " ); } else if (form.code.value == ""){ alert( "<?php echo JText::_('CODE_IS_REQUIRED', true); ?> " ); } else if (form.rsoc.value == ""){ alert( "<?php echo JText::_('COMPANY_NAME_IS_REQUIRED', true); ?> " ); } else if (form.currency.value == ""){ alert( "<?php echo JText::_('CURRENCY_IS_REQUIRED', true); ?> " ); } else { submitform( pressbutton ); } } //--> </script> <?php //$blockMenu = true; $menubars->writeHead($tache, $tacheText); $menubars->addButton('save'); $menubars->addButton('cancel'); $menubars->addButton('apply'); $menubars->writeFoot(); $menubars->addDeclaration(false, false, '', 140); $menubars->render(); JRequest::setVar('view', 'Product'); JRequest::setVar('layout', 'form'); parent::display(); }
function display($tpl = null) { global $mainframe; require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'includes' . DS . 'jaderp_tools.php'; $JAdERPTool =& new JAdERPTools(); $doc =& JFactory::getDocument(); $db =& JFactory::getDBO(); $searchreq = ''; jimport('joomla.html.pagination'); $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit')); //$limitstart = $mainframe->getUserStateFromRequest('com_jaderp.limitstart', 'limitstart', 0); $limitstart = JRequest::getVar('limitstart', '0', '', 'int'); $limitreq = ''; if ($limit) { $limitreq = " LIMIT " . $limitstart . "," . $limit; } $search = JRequest::getVar('search', '', '', 'string'); $search = JString::strtolower($search); if ($search != '') { $searchreq = '(m.rsoc LIKE "%' . $search . '%" OR m.responsable LIKE "%' . $search . '%")'; } $filter_order = JRequest::getVar('filter_order', 'm.id', '', 'cmd'); $filter_order_Dir = JRequest::getVar('filter_order_Dir', 'ASC', '', 'string'); $orderreq = " ORDER BY " . $filter_order . " " . $filter_order_Dir; $filter_country = JRequest::getVar('filter_country', '0', '', 'int'); if ($filter_country > 0) { if ($searchreq == '') { $searchreq = 'm.pcountry = ' . $filter_country; } else { $searchreq .= ' AND m.pcountry =' . $filter_country; } } $filter_currency = JRequest::getVar('filter_currency', '0', '', 'int'); if ($filter_currency > 0) { if ($searchreq == '') { $searchreq = 'm.currency = ' . $filter_currency; } else { $searchreq .= ' AND m.currency =' . $filter_currency; } } $users = $JAdERPTool->ReadTable('jaderp_users', '*', '', 'Array'); if (!$users) { $msg = JText::_('NO_USERS_IN_THE_BASE'); JController::setRedirect(JRoute::_('index.php?option=com_jaderp&view=desktop'), $msg, 'notice'); JController::redirect(); } $total = count($users); $page = new JPagination($total, $limitstart, $limit); $this->assign('pagination', $page); $countries = $JAdERPTool->ReadCountries(); $this->assign('countries', $countries); $currencies = $JAdERPTool->ReadCountries(false, true); $this->assign('currencies', $currencies); //print_r ($currencies); jimport('joomla.language.helper'); $lg = JLanguageHelper::detectLanguage(); $language = substr($lg, 0, 2); $req = "select * from #__jaderp_countries"; $db->setQuery($req); $row = $db->loadAssoc(); if (!array_key_exists($language, $row)) { $language = "en"; } $req = "SELECT m.id as id,\n\t\t\t\tm.code,\n\t\t\t\tm.rsoc,\n\t\t\t\tm.responsable,\n\t\t\t\tm.checked_out,\n\t\t\t\tm.checked_out_time,\n\t\t\t\tc." . $language . " as pcountry,\n\t\t\t\td.currency,\n\t\t\t\td.currency_format,\n\t\t\t\tm.max_credit,\n\t\t\t\tm.solde,\n\t\t\t\tm.chaff"; $req .= " FROM #__jaderp_suppliers as m INNER JOIN #__jaderp_countries as c ON m.pcountry = c.id INNER JOIN #__jaderp_countries as d ON m.currency = d.id"; if ($searchreq != '') { $req .= " WHERE " . $searchreq; } $req .= $orderreq . " " . $limitreq; $db->setQuery($req); $rows = $db->loadAssocList(); $menuid = JAdERPTools::getmenuId("com_jaderp", "Suppliers", "edit"); //echo $req; $this->assign('filter_country', $filter_country); $this->assign('filter_currency', $filter_currency); $this->assign('search', $search); $this->assign('menuid', $menuid); $this->assign('rows', $rows); $this->assign('neworderdir', $filter_order_Dir); $this->assign('neworder', $filter_order); parent::display($tpl); }
function manage() { require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'includes' . DS . 'menubar.php'; $menubars =& new menuBar(); $user =& JFactory::getUser(); require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'includes' . DS . 'jaderp_tools.php'; $JAdERPTool =& new JAdERPTools(); //$JAdERPTool->tablesAccess('jaderp_contacts'); /*$accesses = $JAdERPTool->accessRights('jaderp_contacts', 'add'); echo $accesses['name']['add']; echo '<pre>'; print_r($accesses); echo '</pre>';*/ if ($user->get('id')) { $access_level = $JAdERPTool->UserAccessLevel(); if (!$access_level) { $msg = JText::_('YOU_DONT_HAVE_PERMISSION'); $this->setRedirect(JRoute::_('index.php?option=com_jaderp&task=desktop'), $msg, 'notice'); return; } } else { $msg = JText::_('YOU_MUST_CONNECT'); $this->setRedirect(JRoute::_('index.php?option=com_user&view=login'), $msg, 'notice'); } $buttons = array("save", "cancel", "edit", "apply"); $menuid = JRequest::getInt('menuid', 0); if ($menuid == 0) { $menuid = JAdERPTools::getmenuId(); } if ($menuid) { $db = JFactory::getDBO(); $where = "WHERE " . $db->nameQuote('id') . "=" . $menuid; //echo $where; $menutbl = $JAdERPTool->ReadTable('jaderp_menu', '*', $where, 'Assoc', true); //echo $menutbl['menu_icon']; if ($menutbl) { $tache = $menutbl['menu_icon']; $tacheText = JText::_($menutbl['languagename']); } } $document =& JFactory::getDocument(); JHTML::_('behavior.modal', 'a.modal'); //$menubar = $JAdERPTool-> creatMenuBar($buttons, $tache, $tacheText, true, false,true); //echo $menubar; ?> <a rel="{handler: 'iframe', size: {x: 870, y: 600}}" href="index.php?option=com_jaderp&view=Workers&tmpl=component&layout=print_preview" class="modal"> <span title="Paramètres" class="icon-32-config"> Paramètres</span> </a> <a target="_blank" href="http://localhost/tcpdf/examples/example_011.php"><span title="Paramètres" class="icon-32-config">PDF</span></a> <?php $menubars->writeHead($tache, $tacheText); $task = 'onclick="javascript:if(document.adminForm.boxchecked.value==0){alert(\'Veuillez sélectionner dans la liste les éléments à \');}else{ submitbutton(\'publish\')}"'; //$menubars->addButton('publish',$task); $task = 'onclick="javascript:if(document.adminForm.boxchecked.value==0){alert(\'Veuillez sélectionner dans la liste les éléments à \');}else{ submitbutton(\'unpublish\')}"'; //$menubars->addButton('unpublish',$task); $menubars->addButton('add'); $task = 'onclick="javascript:if(document.adminForm.boxchecked.value!=1){alert(\'Veuillez sélectionner une ligne de la liste des éléments\');}else{ hideMainMenu(); submitbutton(\'edit\')}"'; $menubars->addButton('edit', $task); $task = 'onclick="javascript:if(document.adminForm.boxchecked.value==0){alert(\'Veuillez sélectionner au moin un élément de la liste des éléments\');}else{ hideMainMenu(); submitbutton(\'remove\')}"'; $menubars->addButton('remove', $task); $task = 'onclick="javascript:if(document.adminForm.boxchecked.value==0){alert(\'Veuillez sélectionner au moin un élément de la liste des éléments\');}else{ hideMainMenu(); submitbutton(\'print\')}"'; $menubars->addButton('print', $task); $menubars->writeFoot(); $menubars->addDeclaration(false, false, '', 140); $menubars->render(); JRequest::setVar('view', 'workers'); JRequest::setVar('layout', 'listing'); parent::display(false); }