/** * Action to be executed when the user changes the gender or status * @param $param Action parameters */ public static function onGenderChange($param) { TTransaction::open('samples'); $repo = new TRepository('Customer'); $criteria = new TCriteria(); $criteria->add(new TFilter('gender', 'IN', isset($param['check_gender']) ? $param['check_gender'] : array())); if ($param['combo_status']) { $criteria->add(new TFilter('status', '=', $param['combo_status'])); } $customers = $repo->load($criteria); TTransaction::close(); $options = array(); foreach ($customers as $customer) { $options[$customer->id] = $customer->name; } TCombo::reload('form_dynamic_filter', 'customers', $options); }
public function addPopulationTarget(TCombo $alvo, $model, $frm, $key_busca, $value, $key_valor, $ordercolumn = null) { if ($this->changeaction) { // carrega objetos do banco de dados TTransaction::open($this->banco); // instancia um repositório de Estado $repository = new TRepository($model); $criteria = new TCriteria(); $criteria->setProperty('order', isset($ordercolumn) ? $ordercolumn : $key_busca); $criteria->add(new TFilter($key_busca, '=', $key_valor)); // carrega todos objetos $collection = $repository->{$model}; $items = array(); foreach ($collection as $object) { $items[$object->{$key}] = $object->{$value}; } TCombo::reload($frm, $alvo->getName(), $items); TTransaction::close(); } else { throw new Exception('you need delcare changeaction first'); } }
/** * Action to be executed when the user changes the combo_change field */ public static function onChangeAction($param) { $obj = new StdClass(); $obj->response_c = 'Resp. for opt "' . $param['combo_change'] . '" ' . date('H:m:s'); TForm::sendData('form_interaction', $obj); $options = array(); $options[1] = $param['combo_change'] . ' - one'; $options[2] = $param['combo_change'] . ' - two'; $options[3] = $param['combo_change'] . ' - three'; TCombo::reload('form_interaction', 'response_b', $options); }
public static function onComboTicket($criteria) { try { TTransaction::open('atividade'); $repo = new TRepository('Ticket'); $tickets = $repo->load($criteria); $options[null] = null; foreach ($tickets as $ticket) { $options[$ticket->id] = $ticket->id . ' - ' . $ticket->titulo; } TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } TCombo::reload('form_Atividade', 'ticket_id', $options); }
public static function onChangeOrigem($param) { if ($param['tipo_origens']) { try { TTransaction::open('atividade'); if ($param['tipo_origens'] == 1) { $repo = new TRepository('Entidade'); $criteria = new TCriteria(); $criteria->add(new TFilter('enttipent', '=', 1)); $newparam['order'] = 'entcodent'; $newparam['direction'] = 'asc'; $criteria->setProperties($newparam); // order, offset $entidades = $repo->load($criteria); $options[] = '--Selecione--'; foreach ($entidades as $etd) { $options[$etd->entcodent . $selecao] = str_pad($etd->entcodent, 4, "0", STR_PAD_LEFT) . ' - ' . $etd->entnomfan; } } if ($param['tipo_origens'] == 2) { $repo = new TRepository('Estabelecimento'); $criteria = new TCriteria(); $newparam['order'] = 'lojcodloj'; $newparam['direction'] = 'asc'; $criteria->setProperties($newparam); // order, offset $estabelecimentos = $repo->load($criteria); $options[] = '--Selecione--'; foreach ($estabelecimentos as $ecs) { $options[$ecs->lojcodloj] = str_pad($ecs->lojcodloj, 4, "0", STR_PAD_LEFT) . ' - ' . $ecs->lojnomfan; } } if ($param['tipo_origens'] == 3) { $repo = new TRepository('Empresa'); $criteria = new TCriteria(); $newparam['order'] = 'id'; $newparam['direction'] = 'asc'; $criteria->setProperties($newparam); // order, offset $empresas = $repo->load($criteria); $options[] = '--Selecione--'; foreach ($empresas as $emp) { $options[$emp->id] = str_pad($emp->id, 4, "0", STR_PAD_LEFT) . ' - ' . $emp->razao_social; } } TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } } TCombo::reload('form_Ticket', 'solicitante_id', $opt); TCombo::reload('form_Ticket', 'codigo_cadastro_origem', $options); }