public function getFormIconify()
{
$usr = $this->getCurrentUser();
$sql = "SELECT f.o_id as form_id,f.o_nam as form_name,ic.p_vl as icon,coalesce(fw.p_vl,'640') as form_width,coalesce(fh.p_vl,'480') as form_height " . "FROM osy_obj_rel a " . "INNER JOIN osy_obj f ON (a.o_2 = f.o_own AND f.o_typ = 'form') " . "INNER JOIN osy_obj_prp i ON (f.o_id = i.o_id AND i.p_id = 'iconify' AND i.p_vl = '1') " . "LEFT JOIN osy_obj_prp ic ON (f.o_id = ic.o_id AND ic.p_id = 'iconify-icon') " . "LEFT JOIN osy_obj_prp fw ON (f.o_id = fw.o_id AND fw.p_id = 'width') " . "LEFT JOIN osy_obj_prp fh ON (f.o_id = fh.o_id AND fh.p_id = 'height') " . "WHERE a.o_1 = CONCAT('instance://',?,'/') AND a.r_typ = 'instance+application'";
//echo $sql;
$res = $this->model->dbo->exec_query($sql, array($this->request->get('instance.id')));
$iconify = new Tag('span');
$iconify->add(print_r($this->request->get('input'), true));
if (!empty($res)) {
$iconify = new Tag('ul');
foreach ($res as $rec) {
$item = new Tag('span');
$item->att('id', $rec['form_name'])->att('data-fid', $rec['form_id'])->att('data-form-width', $rec['form_width'])->att('data-form-height', $rec['form_height'])->add(str_replace('CURRENT_USER', $usr, $rec['icon']));
$iconify->add(tag::create('li'))->add($item);
}
}
return $iconify->att('id', 'iconify-forms')->att('style', 'display:none;');
}
