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