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);
}
