/**
* Renderiza o objeto para uma string html
*/
public function render(&$profileName = '')
{
$name = '';
$itens = '';
foreach ($this->_options as $value => $config) {
$class = '';
if ($value == $this->_value) {
$name = $config['nome'];
$class = 'focus';
}
$itens .= '<li onclick="setProfile(this.value,\'' . $this->_object . '\');" value = "' . $value . '" class="link ' . $class . '">' . $config['nome'] . '</li>';
}
if (ZendT_Acl::getInstance()->isAllowed('object-view', 'profile')) {
$urlAdmin = ZendT_Url::getBaseUrl() . '/profile/object-view/list-config/objeto/' . $this->_object . '/tipo/' . $this->_type . '/id/' . $this->_value;
$itens .= '<li role = "separator" class = "divider"></li>';
$itens .= '<li>';
$itens .= ' <a href="' . $urlAdmin . '" target="_new" class="ui-helper-clearfix">';
$itens .= ' ' . _i18n('Administrar');
$itens .= ' </a>';
$itens .= '</li>';
}
if ($name) {
$profileName = $name;
}
$xhtml = '<div style="height: 30px; float:left;" class="default ui-button ui-no-radius-bottom " id="title-profile-' . $this->_name . '">';
$xhtml .= ' <span class="ui-icon ui-icon-transfer-e-w" />';
$xhtml .= ' <ul role="title-profile-' . $this->_name . '" align="left" class="dropdown-menu position ui-helper-clearfix ui-no-radius-tr">';
$xhtml .= $itens;
$xhtml .= ' </ul>';
$xhtml .= '</div>';
return $xhtml;
}
public function soapAction()
{
$this->getResponse()->setHeader('Content-Type', 'text/xml;charset=utf-8', true);
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout()->disableLayout();
$version = $this->getRequest()->getParam('version');
$wsdl = $this->getRequest()->getParam('wsdl');
$service = 'Auth_Service_Ldap';
if ($wsdl) {
$autodiscover = new Zend_Soap_AutoDiscover('Zend_Soap_Wsdl_Strategy_ArrayOfTypeComplex');
$autodiscover->setUri(ZendT_Url::getUri());
$autodiscover->setClass($service);
$autodiscover->handle();
} else {
if (!$version) {
$version = '1_0';
}
$fileWsdl = APPLICATION_PATH . '/modules/auth/services/Ldap/version_' . $version . '.wsdl';
if (file_exists($fileWsdl)) {
$wsdl = str_replace("\\", "/", $fileWsdl);
} else {
$wsdl = ZendT_Url::getUri() . '?wsdl=1';
}
$server = new Zend_Soap_Server();
$server->setWsdl($wsdl);
$server->setClass($service);
$server->handle();
}
}
/**
* Cria cria um campo hidden, um campo para id, um para descrição e um botão para a busca no seeker.
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function fileCustom($id, $value = null, array $attribs = array())
{
$params = $attribs['jQueryParams'];
unset($attribs['jQueryParams']);
if (!isset($attribs['name'])) {
$attribs['name'] = $attribs['id'];
}
$attribs['style'] .= 'width:180px;';
$attribs['readonly'] = 'true';
$name = $attribs['name'];
$xhtml = '<input type="text"' . ' name="' . $this->view->escape($name) . '_name"' . ' id="' . $this->view->escape($id) . '_name"' . ' value="' . $this->view->escape($value) . '"' . $this->_htmlAttribs($attribs) . $this->getClosingBracket();
$xhtml = '
<input id="' . $id . '" name="' . $attribs['name'] . '" type="hidden" />
<input id="' . $id . '_type" name="' . $attribs['name'] . '_type" type="hidden" />
' . $xhtml . '
<button id="buttonUpload_' . $id . '" onClick="jQuery(\'#' . $id . '\').TFile(\'uploadFile\');" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-icon-only" nofocus="true" style="width:35px;height:20px;" type="button" role="button" aria-disabled="false" title="Subir arquivo">
<span class="ui-button-icon-primary ui-icon ui-icon-arrowthickstop-1-n"></span>
<span class="ui-button-text"> </span>
</button>
<button id="buttonDownload_' . $id . '" onClick="jQuery(\'#' . $id . '\').TFile(\'downloadFile\');" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-icon-only" nofocus="true" style="width:35px;height:20px;" type="button" role="button" aria-disabled="false" title="Baixar arquivo">
<span class="ui-button-icon-primary ui-icon ui-icon-arrowthickstop-1-s"></span>
<span class="ui-button-text"> </span>
</button>
<button id="buttonDelete_' . $id . '" onClick="jQuery(\'#' . $id . '\').TFile(\'deleteFile\');" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-icon-only" nofocus="true" style="width:35px;height:20px;" type="button" role="button" aria-disabled="false" title="Limpar arquivo">
<span class="ui-button-icon-primary ui-icon ui-icon-trash"></span>
<span class="ui-button-text"> </span>
</button>
';
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TFile.js?date=' . date('dmy'));
$this->jquery->addOnLoad('jQuery("#' . $id . '").TFile(' . $params . ');');
return $xhtml;
}
/**
*
* @param type $spec
* @param type $options
*/
public function __construct($spec, $options = null)
{
parent::__construct($spec, $options);
$this->setAttrib('urlDownload', ZendT_Url::getBaseUrl() . '/file/download');
$this->setAttrib('urlUpload', ZendT_Url::getBaseUrl() . '/file');
$this->setAttrib('urlDelete', ZendT_Url::getBaseUrl() . '/file/delete');
}
public function soapAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout()->disableLayout();
$params = $this->getRequest()->getParams();
if (!isset($params['version'])) {
$params['version'] = '1.0';
}
$service = 'Ged_Service_FileSystem';
$this->getResponse()->setHeader('Content-Type', 'text/xml;charset=utf-8', true);
if (isset($params['wsdl'])) {
$autodiscover = new Zend_Soap_AutoDiscover('Zend_Soap_Wsdl_Strategy_ArrayOfTypeComplex');
$autodiscover->setUri(ZendT_Url::getUri());
$autodiscover->setClass($service);
$autodiscover->handle();
} else {
$version = str_replace('.', '_', $params['version']);
$names = explode('_', $service);
$fileWsdl = APPLICATION_PATH . '/modules/' . strtolower($names[0]) . '/' . strtolower($names[1]) . 's/' . $names[2] . '/wsdl/' . $names[2] . '_v' . $version . '.wsdl';
if (file_exists($fileWsdl)) {
$wsdl = str_replace("\\", "/", $fileWsdl);
}
$server = new Zend_Soap_Server();
$server->setWsdl($wsdl);
$server->setClass($service);
$server->handle();
}
}
public function load($reload = false)
{
$sql = "SELECT nvl(url,'menu-' || trim(to_char(cms_categoria.id,'99999999999'))) as recurso,\n descricao,\n 'menu-' || nvl(trim(to_char(cms_categoria.id_categoria_pai,'99999999999')),'root') as recurso_pai,\n level as nivel,\n ordem,\n CASE WHEN id_categoria_pai IS NOT NULL AND url IS NULL THEN\n 'S'\n ELSE\n 'N'\n END as grupo,\n level as nivel\n FROM cms_categoria\n WHERE menu = 'S' \n AND status = 'A'\n AND ( publico = 'S' OR EXISTS (" . $this->_restritionSql() . ") )\n START WITH id_categoria_pai IS NULL\n CONNECT BY PRIOR id = id_categoria_pai\n ORDER BY level, ordem, descricao";
$moduleName = 'cms';
$_session = Zend_Auth::getInstance()->getStorage()->read();
if (!isset($_session->dataMenu[$moduleName]) || $reload) {
$baseUrl = ZendT_Url::getBaseUrl();
$_session->dataMenu = array();
$rows = $this->getModel()->getAdapter()->fetchAll($sql);
foreach ($rows as $row) {
$data = array();
$data['url'] = str_replace('{baseUrl}', $baseUrl, $row['recurso']);
$data['level'] = $row['nivel'];
$data['desc'] = utf8_encode($row['descricao']);
$data['group'] = $row['grupo'] == 'S';
$_session->dataMenu[$moduleName][$row['recurso_pai']][] = $data;
}
$_session->dataMenuEncode[$moduleName] = 'UTF8';
/* echo '<pre>';
print_r($_session->dataMenu);
echo '</pre>';
exit; */
$storage = Zend_Auth::getInstance()->getStorage();
$storage->write($_session);
Zend_Auth::getInstance()->setStorage($storage);
}
return true;
}
/**
* Cria um campo texto para numeros, com incremento, verificação, valor maximo e outro (ler arquivo TNumeric.js)
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function numeric($id, $value = null, array $attribs = array())
{
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TNumeric.js');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/autoNumeric.js');
$params = ZendX_JQuery::encodeJson($attribs['jQueryParams']);
unset($attribs['jQueryParams']);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TNumeric(' . $params . ');');
/*$styles = explode(';', $attribs['style']);
if ($styles) {
foreach ($styles as $style) {
list($styleName,$styleValue) = explode(':',$style);
if ($styleName == 'width'){
$old = $style;
$width = (str_replace('px', '', trim($styleValue)) * 1);
$styleValue = $width - 25;
$new = 'width:'.$styleValue.'px';
}
}
$attribs['style'] = str_replace($old,$new,$attribs['style']);
}
if (!$width){
$width = 100;
$attribs['style'].= 'width:75px;';
}*/
$attribs['class'] .= ' item ui-input-num icon';
$btns = ' <span class="item numeric"> ' . ' <div class="ui-button ui-state-default up" nofocus="1" parent="' . $id . '" onClick="if(!$(this).attr(\'disabled\')){jQuery(\'#\' + $(this).attr(\'parent\')).Tdata(\'TNumeric\').incNumber();}" type="button"> ' . ' <span class="ui-icon ui-icon-triangle-1-n"/> ' . ' </div> ' . ' <div class="ui-button ui-state-default down" nofocus="1" parent="' . $id . '" onClick="if(!$(this).attr(\'disabled\')){jQuery(\'#\' + $(this).attr(\'parent\')).Tdata(\'TNumeric\').decNumber();}" type="button"> ' . ' <span class="ui-icon ui-icon-spinner-down"/> ' . ' </div> ' . ' </span> ';
$xhtml = '<div class="ui-form-group"> ' . ' ' . $this->view->formText($id, $value, $attribs) . $btns . '</div>';
return $xhtml;
}
/**
* Cria o script JS para a execução dos tabs
*
* @return string
*/
public function createJS()
{
//$this->addHeadScriptFile('https://www.tanet.com.br/sistemas/printer/js/deployJava.js');
$this->addHeadScriptFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TPrinter.js?date=' . date('dmy'));
$js = "jQuery('#" . $this->getId() . "').TPrinter({filter:'" . $this->_filter . "'});";
return $js;
}
public function deleteAction()
{
$this->_disableRender();
if ($this->getRequest()->getParam('all')) {
$json = new ZendT_Json_Result();
try {
if (!$this->getRequest()->getParam('confirmacao')) {
$form = new ZendT_Form();
$form->setAction(ZendT_Url::getUri());
$params = $this->getRequest()->getParams();
$params['confirmacao'] = '1';
foreach ($params as $key => $val) {
$element = new ZendT_Form_Element_Hidden($key);
$element->setValue($val);
$form->addElement($element);
}
$msg = "Deseja remover todas as notificações?";
throw new ZendT_Exception_Confirm($msg . $form->render());
} else {
if (Auth_Session_User::getInstance()->authenticated()) {
$this->getMapper()->setIdUsuario(Zend_Auth::getInstance()->getStorage()->read()->getId())->delete();
}
$json->setResult(true);
}
} catch (Exception $ex) {
$json->setException($ex);
}
echo $json->render();
} else {
parent::deleteAction();
}
}
/**
* Cria um campo de ComboCustom
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function color($id, $value = null, array $params = array(), array $attribs = array())
{
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/color/simple-color.js');
$js = "jQuery('#" . $id . "').simpleColor({\n boxWidth: '95px',\n cellMargin: 0,\n displayColorCode: true,\n livePreview: true,\n onSelect: function(hex, element) {\n jQuery('#" . $id . "').trigger('change');\n }\n });";
$this->jquery->addOnLoad($js);
return $this->view->formText($id, $value, $params);
}
/**
* Cria um campo de ComboCustom
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function comboCustom($id, $value = null, array $params = array(), array $attribs = array())
{
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TComboCustom.js')->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TOpenDownBox.js');
$params = ZendX_JQuery::encodeJson($params);
$js = sprintf('%s("#%s").TComboCustom(%s);', ZendX_JQuery_View_Helper_JQuery::getJQueryHandler(), $attribs['id'], $params);
$this->jquery->addOnLoad($js);
return $this->view->formText($id, $value, $attribs);
}
/**
*
* @param type $local
*/
public function __construct($local = false)
{
if (!$local) {
$local = ZendT_Url::getBaseUrl();
}
$this->_local = $local;
$this->_where = null;
}
/**
* Cria um campo texto com validador de data e datepicker
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function dateMonthYear($id, $value = null, array $attribs = array())
{
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/jquery.maskedinput-1.4.1.min.js');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TDateMonthYear.js');
$params = ZendX_JQuery::encodeJson($attribs['jQueryParams']);
unset($attribs['jQueryParams']);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TDateMonthYear(' . $params . ');');
return $this->view->formText($id, $value, $attribs);
}
/**
* Cria um campo texto para numeros, com incremento, verificação, valor maximo e outro (ler arquivo TNumericMulti.js)
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function numericMulti($id, $value = null, array $attribs = array())
{
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TNumericMulti.js');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/autoNumeric.js');
$params = ZendX_JQuery::encodeJson($attribs['jQueryParams']);
unset($attribs['jQueryParams']);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TNumericMulti(' . $params . ');');
return $this->view->formText($id, $value, $attribs);
}
/**
* Cria um campo texto com validador de data e datepicker
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function dateMulti($id, $value = null, array $attribs = array())
{
$data = date('dmy');
#$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TCursor.js?'.$data);
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TDateMulti.js?' . $data);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TDateMulti();');
#$button = new ZendT_View_Button('bt-calend-'.$id,'');
#$button->setIcon('ui-icon-calculator');
$attribs['style'] .= ';float:left;';
$_toolbar = new ZendT_View_Toolbar('calend-toolbar-' . $id);
$_toolbar->addStyle('width', '390px');
$_toolbar->addStyle('height', '34px');
$_toolbar->addStyle('display', 'none');
$_toolbar->setAttr('align', 'center');
$padrao = explode(' ', $value);
$hoje = new ZendT_Type_Date('SYSDATE', 'Date');
$ultimoMes[0] = clone $hoje;
$ultimoMes[0]->addMonth(-1)->firstDayMonth();
$ultimoMes[1] = clone $hoje;
$ultimoMes[1]->addMonth(-1)->lastDayMonth();
$mesCorrente[0] = clone $hoje;
$mesCorrente[0]->firstDayMonth();
$mesCorrente[1] = clone $hoje;
$mesCorrente[1]->lastDayMonth();
$ultimaSemana[0] = clone $hoje;
$ultimaSemana[0]->addWeek(-1)->firstDayWeek();
$ultimaSemana[1] = clone $hoje;
$ultimaSemana[1]->addWeek(-1)->lastDayWeek();
$semanaCorrente[0] = clone $hoje;
$semanaCorrente[0]->firstDayWeek();
$semanaCorrente[1] = clone $hoje;
$semanaCorrente[1]->lastDayWeek();
$options = "var option = jQuery('#calend_select_" . $id . "').val();\n\n if(option != ''){\n var data1 = '', data2 = '';\n if(option == '0'){\n data1 = '" . $padrao[0] . "';\n data2 = '" . $padrao[1] . "';\n }\n else if(option == '1'){\n data1 = '" . $hoje . "';\n data2 = '" . $hoje . "';\n } else if(option == 2){\n data1 = '" . $ultimoMes[0] . "';\n data2 = '" . $ultimoMes[1] . "';\n } else if(option == 3){\n data1 = '" . $mesCorrente[0] . "';\n data2 = '" . $mesCorrente[1] . "';\n } else if(option == 4){\n data1 = '" . $ultimaSemana[0] . "';\n data2 = '" . $ultimaSemana[1] . "';\n } else if(option == 5){\n data1 = '" . $semanaCorrente[0] . "';\n data2 = '" . $semanaCorrente[1] . "';\n }\n jQuery('#calend-" . $id . "-1').datepicker('setDate', data1);\n jQuery('#calend-" . $id . "-2').datepicker('setDate', data2);\n\n jQuery('#" . $id . "').val(\n jQuery('#calend-" . $id . "-1').datepicker({ dateFormat: 'yy-mm-dd' }).val() + ' ' +\n jQuery('#calend-" . $id . "-2').datepicker({ dateFormat: 'yy-mm-dd' }).val()\n );\n }\n ";
$close = " jQuery('#calend-" . $id . "-1').hide('fast');\n jQuery('#calend-" . $id . "-2').hide('fast');\n jQuery('#calend-toolbar-" . $id . "').hide('fast');";
$element = new ZendT_Form_Element_Select("calend_select_" . $id);
#$element->setLabel('Seleção');
$element->addMultiOption('', '');
$element->addMultiOption('1', 'Hoje');
$element->addMultiOption('2', 'Último Mês');
$element->addMultiOption('3', 'Mês corrente');
$element->addMultiOption('4', 'Última Semana');
$element->addMultiOption('5', 'Semana corrente');
$element->addAttr('breakline', 'none');
$element->setAttrib('onClick', $options);
$element->addStyle('float', 'left');
$element->addStyle('height', '25px');
$element->addStyle('margin', '3px');
$_toolbar->add($element);
$_button = new ZendT_View_Button('bt_ok' . $id, 'OK', $close);
$_button->setIcon('ui-icon-check');
$_button->addStyle('float', 'right');
$_button->addStyle('height', '25px');
$_button->addStyle('margin', '3px');
$_toolbar->addButton($_button);
return $this->view->formText($id, $value, $attribs) . '<span id="bt-calend-' . $id . '" style="margem:0px; float:left; height: 18px; width: 20px;" class="ui-button ui-state-default ui-corner-right ui-button-icon-only"><span id="icon-bt-calend-' . $id . '" class="ui-button-icon-primary ui-icon ui-icon-calculator"></span></span>' . '<br style="clear:both;" /><table><tr><td><div id="calend-' . $id . '-1" style="display:none"></div></td><td><div id="calend-' . $id . '-2" style="display:none"></div></td></tr></table>' . $_toolbar->render() . '<label class="error" for="dt_emissao_ctrc" generated="true" style="display:none"></label>' . '<div id="hour-' . $id . '" style="display:none"></div>';
}
/**
* Cria um campo texto com validador de data e datepicker
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function date($id, $value = null, array $attribs = array())
{
$data = date('dmy');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/layout/jquery/widget/TDate.js?' . $data);
$params = ZendX_JQuery::encodeJson($attribs['jQueryParams']);
unset($attribs['jQueryParams']);
$attribs['class'] .= ' ui-input-date';
$xhtml .= '<div class="ui-form-group">' . $this->view->formText($id, $value, $attribs) . '</div>';
$this->jquery->addOnLoad('jQuery("#' . $id . '").TDate(' . $params . ');');
return $xhtml;
}
/**
* Retorna a URL de acesso
*
* @param bool $removeAction
* @return string
*/
public static function getUri($removeAction = false)
{
$uri = ZendT_Url::getHostName();
$uri .= ZendT_Url::getBaseUrl();
$route = ZendT_Controller_Front::getInstance()->getRequest()->getParams();
$uri .= '/' . $route['module'];
$uri .= '/' . $route['controller'];
if (!$removeAction) {
$uri .= '/' . $route['action'];
}
return $uri;
}
public function indexAction()
{
Zend_Layout::getMvcInstance()->setLayout('window');
$params = $this->getRequest()->getParams();
if (is_array($params['options'])) {
$params['options'] = serialize($params['options']);
}
$form = new Application_Form_File();
$form->loadElements();
$form->setAction(ZendT_Url::getUri(true) . '/upload');
$form->populate($params);
$this->view->form = $form;
}
/**
* Cria um campo texto com validador de data e datepicker
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function dateDynamic($id, $value = null, array $attribs = array())
{
$params = $attribs['jQueryParams'];
unset($attribs['jQueryParams']);
$params['helper_script'] = 'TDateDynamic';
$data = date('dmy');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/layout/jquery/widget/TDateDynamic.js?' . $data);
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/layout/jquery/widget/TButtonsDynamic.js?' . $data);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TButtonsDynamic(' . ZendT_JS_Json::encode($params) . ');');
$attribs['style'] .= 'float:left;';
$attribs['class'] .= ' ui-input-date item';
return '<div class="ui-form-group">' . $this->view->formText($id, $value, $attribs) . '</div>';
}
public function getSidebar($idCategoria)
{
$sql = "SELECT 'menu-' || trim(to_char(nvl(cms_categoria.id,0),'99999999999')) as recurso,\n url,\n descricao,\n 'menu-' || decode({$idCategoria},cms_categoria.id_categoria_pai,'root',trim(to_char(nvl(cms_categoria.id_categoria_pai,0),'99999999999'))) as recurso_pai\n FROM cms_categoria\n WHERE status = 'A'\n AND level <= 2\n AND ( publico = 'S' OR EXISTS (" . $this->_restritionSql() . ") )\n START WITH id_categoria_pai = " . $idCategoria . "\n CONNECT BY PRIOR id = id_categoria_pai\n ORDER BY level, ordem, descricao";
//print $sql;
$rows = $this->getModel()->getAdapter()->fetchAll($sql);
$result = array();
foreach ($rows as $row) {
$data = array();
$data['id'] = $row['recurso'];
$data['url'] = ZendT_Url::formatUrl($row['url']);
$data['desc'] = utf8_encode($row['descricao']);
$result[$row['recurso_pai']][] = $data;
}
return $result;
}
/**
*
* @param string $moduleName
*
* @return ZendT_Acl_Resource_RowMenu[]
*/
public function getMenu($moduleName)
{
$moduleName = strtoupper($moduleName);
$sql = "SELECT rsu.hierarquia AS recurso, \n rsu.descricao, \n rsuPai.hierarquia AS recurso_pai,\n rsu.nivel,\n rsu.observacao\n FROM " . Auth_Model_Recurso_Mapper::$table . " rsu\n JOIN " . Auth_Model_TipoRecurso_Mapper::$table . " tpRsu ON (rsu.id_tipo_recurso = tpRsu.Id)\n LEFT JOIN " . Auth_Model_Recurso_Mapper::$table . " rsuPai ON (rsu.id_recurso_pai = rsuPai.Id)\n WHERE tpRsu.Nome = 'MENU'\n AND rsu.status = 'A'\n AND rsuPai.hierarquia LIKE '" . $moduleName . "%'\n ORDER BY rsuPai.hierarquia, rsu.ordem, rsu.hierarquia, rsu.descricao";
$rows = $this->getAdapter()->fetchAll($sql);
$result = array();
$baseUrl = ZendT_Url::getBaseUrl();
foreach ($rows as $row) {
if ($row['observacao'] == '') {
$row['observacao'] = $row['recurso'];
}
$menu = new ZendT_Acl_Resource_RowMenu();
$menu->setDescription($row['descricao'])->setParent($row['recurso'])->setUrl(str_replace("{baseUrl}", $baseUrl, $row['observacao']));
$result[$row['recurso_pai']][] = $menu;
}
return $result;
}
public function gridAction()
{
parent::gridAction();
if ($this instanceof ZendT_Controller_ActionCrud && ZendT_Acl::getInstance()->isAllowed('efetivar', $this->_resourceBase)) {
$btnId = 'btn_efetivar_' . $this->getGrid()->getID();
$_efetivar = new ZendT_Grid_Button_Ajax($idbt);
$_efetivar->setIdGrid($this->getGrid()->getID())->setButtonIcon('ui-icon-check')->setUrl(ZendT_Url::getUri(true) . '/efetivar')->setTitle('Efetivar');
$this->view->hotkeys()->add('btn_efetivar', 'ctrl+t', '$("#' . $btnId . '").click();');
$this->getGrid()->addToolbarButton('btn_efetivar', $_efetivar, 'btn_efetiva');
}
if ($this instanceof ZendT_Controller_ActionCrud && ZendT_Acl::getInstance()->isAllowed('cancelar', $this->_resourceBase)) {
$btnId = 'btn_cancelar_' . $this->getGrid()->getID();
$_efetivar = new ZendT_Grid_Button_Ajax($idbt);
$_efetivar->setIdGrid($this->getGrid()->getID())->setButtonIcon('ui-icon-cancel')->setUrl(ZendT_Url::getUri(true) . '/cancelar')->setTitle('Cancelar');
$this->view->hotkeys()->add('btn_cancelar', 'ctrl+r', '$("#' . $btnId . '").click();');
$this->getGrid()->addToolbarButton('btn_cancelar', $_efetivar, 'btn_cancelar');
}
}
/**
* Carrega os elementos no formulário para serem renderizado
* @return void
*/
public function loadElements()
{
$this->setName('frm_auth');
$this->setAction(ZendT_Url::getBaseUrl() . '/auth/user/authenticate');
$_elements = new Auth_Form_Usuario_Elements();
$element = $_elements->getLogin();
$element->setLabel(_i18n('E-Mail'));
$element->setRequired(true);
$this->addElement($element);
$element = $_elements->getSenha();
$element->setRequired(true);
$this->addElement($element);
$element = new ZendT_Form_Element_Button('btn_auth');
$element->setIcon('ui-icon-check');
$element->setLabel(_i18n('Autenticar'));
$element->setAttrib('onClick', 'jQuery.AjaxT.submitJson({selector: \'#frm_auth\', success: function(result){console.log(result);}})');
$this->addElement($element);
}
/**
* Cria um campo texto com autocomplete customizado
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function autocomplete($id, $value = null, array $attribs = array())
{
$params = $attribs['jQueryParams'];
unset($attribs['jQueryParams']);
if (!isset($params['source'])) {
if (isset($params['url'])) {
$params['source'] = $params['url'];
unset($params['url']);
} else {
if (isset($params['data'])) {
$params['source'] = $params['data'];
unset($params['data']);
} else {
require_once "ZendX/JQuery/Exception.php";
throw new ZendX_JQuery_Exception("O parametro Source é obrigatório");
}
}
}
if ($params['showButtonSearch']) {
$xhtml = '<button id="search-' . $id . '" type="button" class="ui-button ui-state-default item" nofocus="true"><span class="ui-icon ui-icon-carat-1-s"></span></button>';
} else {
$xhtml = '';
}
$xscript = '';
if ($params['multiple']) {
$onResult = 'function(event, row, formatted){
jQuery("#' . $id . '").Tdata("TAutocomplete").addElement("' . $id . '", row[0]);
}';
$params['onResult'] = new ZendT_JS_Command($onResult);
$xhtml .= '<div id="sel-elements-' . $id . '" class="" style="text-wrap: normal;">
<input id="' . $id . '-multiple" name="' . $id . '-multiple" type="hidden" value="">
</div>';
$xscript .= 'jQuery("#sel-elements-' . $id . '").width(jQuery("#' . $id . '").width());';
}
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/jquery.autocomplete.js');
$this->view->headLink()->appendStylesheet(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/jquery.autocomplete.css');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TAutocomplete.js');
$params = ZendT_JS_Json::encode($params);
$params = str_replace('{id}', $id, $params);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TAutocomplete(' . $params . ');' . $xscript);
$attribs['class'] .= ' item';
return '<div class="ui-form-group"> ' . $this->view->formText($id, $value, $attribs) . $xhtml . '</div>';
}
/**
* Cria um campo texto
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function text($id, $value = null, array $attribs = array())
{
unset($attribs['required']);
$mask = $attribs['jQueryParams']['mask'];
$charMask = $attribs['jQueryParams']['charMask'];
unset($attribs['jQueryParams']);
if ($mask) {
if (!is_array($mask)) {
$mask = array($mask);
}
$params = array('masks' => $mask, 'charMask' => $charMask);
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TMask.js');
$this->jquery->addOnLoad('jQuery("#' . $id . '").TMask(' . json_encode($params) . ').val(\'' . $value . '\');');
}
$xhtml = $this->view->formText($id, $value, $attribs);
if (!isset($attribs['noLabelError'])) {
$xhtml .= '<label class="error" for="' . $id . '" generated="true" style="display:none"></label>';
}
return $xhtml;
}
public function spreadSheet($id, $value = null, array $attribs = array())
{
#var_dump($attribs);die;
$params = $attribs['jQueryParams'];
#var_dump($params);die;
unset($attribs['jQueryParams']);
$xhtml = "<div id='{$id}'";
if ($attribs['divParams']) {
foreach ($attribs['divParams'] as $key => $val) {
$xhtml .= " {$key}='{$val}'";
}
}
$xhtml .= "><input type=\"hidden\" TSpreadSheet=\"1\" id=\"{$id}_json\" name=\"{$id}\" /></div>";
$params['elements']['id'] = $id;
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/handsontable-master/dist/handsontable.full.js?');
$this->view->headLink()->appendStylesheet(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/handsontable-master/dist/handsontable.full.css');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . "/scripts/jquery/widget/TSpreadSheet.js?date=" . strtotime("now"));
$this->jquery->addOnLoad('jQuery("#' . $id . '").TSpreadSheet(' . ZendT_JS_Json::encode($params) . ');');
return $xhtml;
}
public function widgetAction()
{
$parent = $this->getRequest()->getParam('parent');
$noLayout = $this->getRequest()->getParam('no_layout');
$fileSystem = new Ged_Model_Arquivo_FileSystem();
$this->getMapper()->setIdcategoriaPai($parent)->setStatus('A')->findAll(null, '*', array('ordem', 'id'));
$categorias = array();
while ($this->getMapper()->fetch()) {
$categoria['url'] = ZendT_Url::formatUrl($this->getMapper()->getUrl()->get());
$categoria['descricao'] = $this->getMapper()->getDescricao()->get();
$categoria['observacao'] = $this->getMapper()->getObservacao()->get();
$thumbnail = $this->getMapper()->getThumbnail()->toPhp();
$categoria['thumbnail'] = $fileSystem->getUrl($thumbnail);
$categorias[] = $categoria;
}
$this->view->categorias = $categorias;
if ($noLayout) {
$this->_disableRender(true, false);
}
}
/**
* Cria um campo texto para numeros, com incremento, verificação, valor maximo e outro (ler arquivo TDateTime.js)
*
* @param string $id
* @param string $value
* @param array $params jQuery Widget Parameters
* @param array $attribs HTML Element Attributes
* @return string
*/
public function dateTime($id, $value = null, array $attribs = array())
{
$date = $attribs['propDate'];
$time = $attribs['propTime'];
$params = $attribs['jQueryParams'];
unset($attribs['propDate']);
unset($attribs['propTime']);
unset($attribs['jQueryParams']);
$data = date('dmy');
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/jquery.autocomplete.js?' . $data);
$this->view->headLink()->appendStylesheet(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/extra/jquery.autocomplete.css?' . $data);
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/layout/jquery/widget/TTime.js?' . $data);
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/layout/jquery/widget/TDate.js?' . $data);
$this->view->headScript()->appendFile(ZendT_Url::getBaseDiretoryPublic() . '/scripts/jquery/widget/TDateTime.js?' . $data);
$params = ZendX_JQuery::encodeJson($params);
$this->jquery->addOnLoad('jQuery("#' . $id . '").TDateTime(' . $params . ');');
$xDate = '<div class="ui-form-group">' . $date->addClass('ui-input-date')->setAttrib('button', 'btn_' . $date->getId())->setAttrib('noLabelError', 1)->render() . '<label class="popover fade bottom in error" for="' . $date->getId() . '" generated="true" style="display:none"></label>' . '</div>';
$xTime = '<div class="ui-form-group">' . $time->addClass('ui-input-time')->setAttrib('button', 'btn_' . $time->getId())->setAttrib('noLabelError', 1)->render() . '<label class="popover fade bottom in error" for="' . $time->getId() . '" generated="true" style="display:none"></label>' . '</div>';
return $this->view->formHidden($id, $value, $attribs) . $xDate . $xTime;
}
public function query($id, $value = null, array $attribs = array())
{
$_mapperView = $attribs['mapperView'];
if (!$_mapperView instanceof ZendT_Db_View) {
$_mapperView = new $_mapperView();
}
$columns = $_mapperView->getColumns()->toQuery();
$_parse = new ZendT_Db_Adapter_ParseSQL();
$command = $_parse->toArray($value);
$param = array();
$param['jsonElement'] = $command;
$param['columns'] = $columns;
$param['mapper'] = get_class($_mapperView);
$param['urlQuote'] = ZendT_Url::getUri(true) . '/quote';
$urlPublic = ZendT_Url::getBaseDiretoryPublic();
$this->view->headScript()->appendFile($urlPublic . '/scripts/jquery/widget/TQueryBuilder.js');
$this->view->headLink()->appendStylesheet($urlPublic . '/scripts/jquery/widget/TQueryBuilder/TQueryBuilder.css');
$js = "jQuery('#{$id}').TQueryBuilder(" . ZendT_JS_Json::encode($param) . ");";
$this->jquery->addOnLoad($js);
return $this->view->formHidden($id, $value, $attribs);
}
public function soapAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout()->disableLayout();
$params = $this->getRequest()->getParams();
$service = 'ZendT_Mail_Service';
$this->getResponse()->setHeader('Content-Type', 'text/xml;charset=utf-8', true);
if (isset($params['wsdl'])) {
$autodiscover = new Zend_Soap_AutoDiscover('Zend_Soap_Wsdl_Strategy_ArrayOfTypeComplex');
$autodiscover->setUri(ZendT_Url::getUri());
$autodiscover->setClass($service);
$autodiscover->handle();
} else {
$server = new Zend_Soap_Server();
#$wsdl = ZendT_Url::getUri() . "?wsdl";
$wsdl = APPLICATION_PATH . '/controllers/Mail_v1.wsdl';
$server->setWsdl($wsdl);
$server->setClass($service);
$server->handle();
}
}
