get_total();
if ($total <= 0) {
echo App::ui_widget('info', "Nie znaleziono żadnych rekordów pasujacych do kryteriów wyszukiwania");
}
else {
$list = $qProces->get_list();
$nav = new PageNav($total, $qProces->get_param('offset'), $qProces->get_param('limit'));
$nav->set_request_args(array('task'=>'CRM_SEARCH', 'q'=>$q, '_active_tab'=>($tab_nr - 1)));
$nav->set_request_method_post();
$nav->set_request_arg_page_nr_name('f-_offset');
echo $nav->render('links_only');
?>
| ID |
DESC |
OPIS |
hit_counter |
DESC);
$desc = str_replace($q, ''.$q.'', $desc);
$desc = str_replace(strtoupper($q), ''.strtoupper($q).'', $desc);
$opis = strip_tags($r->OPIS);
if (strlen($opis) > 255) {
$opis = substr($opis, 0, 255) . ' ...';
}
$opis = str_replace($q, ''.$q.'', $opis);
$opis = str_replace(strtoupper($q), ''.strtoupper($q).'', $opis);
echo '';
echo '| ' . App::link($r->ID, array('task'=>'CRM_PROCES', 'filtr_id'=>$r->ID), array('class'=>'external', 'target'=>'_blank')) . ' | ';
echo '' . $desc . ' | ';
echo '' . $opis . ' | ';
echo '' . $r->hit_counter . ' | ';
echo '
';
}
?>
render();
}
?>
get_total();
if ($total <= 0) {
echo App::ui_widget('info', "Nie znaleziono żadnych rekordów pasujacych do kryteriów wyszukiwania");
}
else {
$list = $qZasob->get_list();
$nav = new PageNav($total, $qZasob->get_param('offset'), $qZasob->get_param('limit'));
$nav->set_request_args(array('task'=>'CRM_SEARCH', 'q'=>$q, '_active_tab'=>($tab_nr - 1)));
$nav->set_request_method_post();
$nav->set_request_arg_page_nr_name('f-_offset');
echo $nav->render('links_only');
?>
| ID |
DESC |
OPIS |
hit_counter |
DESC);
$desc = str_replace($q, ''.$q.'', $desc);
$desc = str_replace(strtoupper($q), ''.strtoupper($q).'', $desc);
$opis = strip_tags($r->OPIS);
if (strlen($opis) > 255) {
$opis = substr($opis, 0, 255) . ' ...';
}
$opis = str_replace($q, ''.$q.'', $opis);
$opis = str_replace(strtoupper($q), ''.strtoupper($q).'', $opis);
echo '';
echo '| ' . App::link($r->ID, array('task'=>'CRM_LISTA_ZASOBOW', 'filtr_id'=>$r->ID), array('class'=>'external', 'target'=>'_blank')) . ' | ';
echo '' . $desc . ' | ';
echo '' . $opis . ' | ';
echo '' . $r->hit_counter . ' | ';
echo '
';
}
?>
render();
}
?>
get_total();
if ($total <= 0) {
echo App::ui_widget('info', "Nie znaleziono żadnych rekordów pasujacych do kryteriów wyszukiwania");
}
else {
$list = $qWsk->get_list();
$nav = new PageNav($total, $qWsk->get_param('offset'), $qWsk->get_param('limit'));
$nav->set_request_args(array('task'=>'CRM_SEARCH', 'q'=>$q, '_active_tab'=>($tab_nr - 1)));
$nav->set_request_method_post();
$nav->set_request_arg_page_nr_name('f-_offset');
echo $nav->render('links_only');
?>
| ID |
ID_PROCES |
ID_ZASOB |
OPIS_ZASOB |
hit_counter |
DESC);
$desc = str_replace($q, ''.$q.'', $desc);
$desc = str_replace(strtoupper($q), ''.strtoupper($q).'', $desc);
$opis = strip_tags($r->OPIS_ZASOB);
if (strlen($opis) > 255) {
$opis = substr($opis, 0, 255) . ' ...';
}
$opis = str_replace($q, ''.$q.'', $opis);
$opis = str_replace(strtoupper($q), ''.strtoupper($q).'', $opis);
echo '';
echo '| ' . $r->ID . ' | ';
echo '' . App::link($r->ID_PROCES, array('task'=>'CRM_PROCES', 'filtr_id'=>$r->ID_PROCES), array('class'=>'external', 'target'=>'_blank')) . ' | ';
echo '' . App::link($r->ID_ZASOB, array('task'=>'CRM_LISTA_ZASOBOW', 'filtr_id'=>$r->ID_ZASOB), array('class'=>'external', 'target'=>'_blank')) . ' | ';
echo '' . $opis . ' | ';
echo '' . $r->hit_counter . ' | ';
echo '
';
}
?>
render();
}
?>
get_total();
if ($total <= 0) {
echo App::ui_widget('info', "Nie znaleziono żadnych rekordów pasujacych do kryteriów wyszukiwania");
}
else {
$list = $qProcesInit->get_list();
$nav = new PageNav($total, $qProcesInit->get_param('offset'), $qProcesInit->get_param('limit'));
$nav->set_request_args(array('task'=>'CRM_SEARCH', 'q'=>$q, '_active_tab'=>($tab_nr - 1)));
$nav->set_request_method_post();
$nav->set_request_arg_page_nr_name('f-_offset');
echo $nav->render('links_only');
?>
| ID |
DESC |
OPIS |
hit_counter |
DESC);
$desc = str_replace($q, ''.$q.'', $desc);
$desc = str_replace(strtoupper($q), ''.strtoupper($q).'', $desc);
$opis = strip_tags($r->OPIS);
if (strlen($opis) > 255) {
$opis = substr($opis, 0, 255) . ' ...';
}
$opis = str_replace($q, ''.$q.'', $opis);
$opis = str_replace(strtoupper($q), ''.strtoupper($q).'', $opis);
echo '';
echo '| ' . App::link($r->ID, array('task'=>'CRM_PROCES', 'filtr_id'=>$r->ID), array('class'=>'external', 'target'=>'_blank')) . ' | ';
echo '' . $desc . ' | ';
echo '' . $opis . ' | ';
echo '' . $r->hit_counter . ' | ';
echo '
';
}
?>
render();
}
?>
db = $db;
}
public function set_fields($fields) {
$this->fields = $fields;
}
public function add_field($field, $label) {
$this->fields[$field] = $label;
}
public function get_field_names() {
return array_keys($this->fields);
}
public function get_field_labels() {
return array_values($this->fields);
}
public function get_fields() {
return $this->fields;
}
public function set_search($q) {
$q = trim($q);
$this->q = $this->db->_($q);
}
public function check_search() {
return (!empty($this->q) && strlen($this->q) > 2);
}
public function set_param($key, $value) {
$this->params[$key] = $value;
}
public function get_param($key) {
return (array_key_exists($key, $this->params))? $this->params[$key] : null;
}
public function get_total() {
if ($this->_total === null) {
$this->_total = $this->_fetch_total();
}
return $this->_total;
}
public function get_list() {
if ($this->_list === null) {
$this->_list = $this->_fetch_list();
}
return $this->_list;
}
protected function _fetch_total() {
return 0;
}
protected function _fetch_list() {
$ret = array();
return $ret;
}
}
class CrmSearchProces extends CrmSearchBase {
function _get_sql_where() {
$sql_where = "
p.`A_STATUS` in('NORMAL','WAITING')
and (p.`DESC` like '%{$this->q}%' or p.`OPIS` like '%{$this->q}%' or p.`ID` like '{$this->q}')
";
return $sql_where;
}
function _fetch_total() {
$total = 0;
$sql_where = $this->_get_sql_where();
$sql = "select count(1) as cnt
from `CRM_PROCES` as p
where {$sql_where}
";
$res = $this->db->query($sql);
if ($r = $this->db->fetch($res)) {
$total = $r->cnt;
}
return $total;
}
function _fetch_list() {
$list = array();
$sql_where = $this->_get_sql_where();
$sql_limit = V::get('limit', 10, $this->params, 'int');
$sql_offset = V::get('offset', 0, $this->params, 'int');
$sql = "select p.`ID`, p.`DESC`, p.`OPIS`
, if(p.`ID`='{$this->q}', 100
, if(p.`DESC`='{$this->q}', 99
, if(p.`DESC` like '{$this->q}%', 90
, if(p.`DESC` like '%{$this->q}%', 80
, if(p.`OPIS`='{$this->q}', 50
, if(p.`OPIS` like '{$this->q}%', 40
, if(p.`OPIS` like '%{$this->q}%', 30
, 0
)
)
)
)
)
)
)
as hit_counter
from `CRM_PROCES` as p
where {$sql_where}
order by hit_counter DESC, p.`ID` DESC
limit {$sql_limit} offset {$sql_offset}
";
$res = $this->db->query($sql);
while ($r = $this->db->fetch($res)) {
$list[$r->ID] = $r;
}
return $list;
}
}
class CrmSearchProcesInit extends CrmSearchBase {
function _get_sql_where() {
$sql_where = "
p.`A_STATUS` in('NORMAL','WAITING')
and (p.`DESC` like '%{$this->q}%' or p.`OPIS` like '%{$this->q}%' or p.`ID` like '%{$this->q}%')
and p.`TYPE`='PROCES_INIT'
";
return $sql_where;
}
function _fetch_total() {
$total = 0;
$sql_where = $this->_get_sql_where();
$sql = "select count(1) as cnt
from `CRM_PROCES` as p
where {$sql_where}
";
$res = $this->db->query($sql);
if ($r = $this->db->fetch($res)) {
$total = $r->cnt;
}
return $total;
}
function _fetch_list() {
$list = array();
$sql_where = $this->_get_sql_where();
$sql_limit = V::get('limit', 10, $this->params, 'int');
$sql_offset = V::get('offset', 0, $this->params, 'int');
$sql = "select p.`ID`, p.`DESC`, p.`OPIS`
, if(p.`ID`='{$this->q}', 100
, if(p.`DESC`='{$this->q}', 99
, if(p.`DESC` like '{$this->q}%', 90
, if(p.`DESC` like '%{$this->q}%', 80
, if(p.`OPIS`='{$this->q}', 50
, if(p.`OPIS` like '{$this->q}%', 40
, if(p.`OPIS` like '%{$this->q}%', 30
, 0
)
)
)
)
)
)
) as hit_counter
from `CRM_PROCES` as p
where {$sql_where}
order by hit_counter DESC, p.`ID` DESC
limit {$sql_limit} offset {$sql_offset}
";
$res = $this->db->query($sql);
while ($r = $this->db->fetch($res)) {
$list[$r->ID] = $r;
}
return $list;
}
}
class CrmSearchZasob extends CrmSearchBase {
function _get_sql_where() {
$sql_where = "
z.`A_STATUS` in('NORMAL','WAITING')
and (z.`DESC` like '%{$this->q}%' or z.`OPIS` like '%{$this->q}%' or z.`ID` like '{$this->q}')
";
return $sql_where;
}
function _fetch_total() {
$total = 0;
$sql_where = $this->_get_sql_where();
$sql = "select count(1) as cnt
from `CRM_LISTA_ZASOBOW` as z
where {$sql_where}
";
$res = $this->db->query($sql);
if ($r = $this->db->fetch($res)) {
$total = $r->cnt;
}
return $total;
}
function _fetch_list() {
$list = array();
$sql_where = $this->_get_sql_where();
$sql_limit = V::get('limit', 10, $this->params, 'int');
$sql_offset = V::get('offset', 0, $this->params, 'int');
$sql = "select z.`ID`, concat(z.`DESC`,' (',z.`TYPE`,')') as `DESC`, z.`OPIS`
, if(z.`ID`='{$this->q}', 100
, if(z.`DESC`='{$this->q}', 99
, if(z.`DESC` like '{$this->q}%', 90
, if(z.`DESC` like '%{$this->q}%', 80
, if(z.`OPIS`='{$this->q}', 50
, if(z.`OPIS` like '{$this->q}%', 40
, if(z.`OPIS` like '%{$this->q}%', 30
, 0
)
)
)
)
)
)
) as hit_counter
from `CRM_LISTA_ZASOBOW` as z
where {$sql_where}
order by hit_counter DESC, z.`ID` DESC
limit {$sql_limit} offset {$sql_offset}
";
$res = $this->db->query($sql);
while ($r = $this->db->fetch($res)) {
$list[$r->ID] = $r;
}
return $list;
}
}
class CrmSearchWskaznik extends CrmSearchBase {
function _get_sql_where() {
$sql_where = "
w.`A_STATUS` in('NORMAL','WAITING')
and p.`A_STATUS` in('NORMAL','WAITING')
and z.`A_STATUS` in('NORMAL','WAITING')
and (w.`OPIS_ZASOB` like '%{$this->q}%' or w.`ID_ZASOB` like '{$this->q}' or w.`ID_PROCES` like '{$this->q}' )
";
return $sql_where;
}
function _fetch_total() {
$total = 0;
$sql_where = $this->_get_sql_where();
$sql = "select count(1) as cnt
from `CRM_WSKAZNIK` as w
join `CRM_PROCES` as p on(p.`ID`=w.`ID_PROCES`)
join `CRM_LISTA_ZASOBOW` as z on(z.`ID`=w.`ID_ZASOB`)
where {$sql_where}
";
$res = $this->db->query($sql);
if ($r = $this->db->fetch($res)) {
$total = $r->cnt;
}
return $total;
}
function _fetch_list() {
$list = array();
$sql_where = $this->_get_sql_where();
$sql_limit = V::get('limit', 10, $this->params, 'int');
$sql_offset = V::get('offset', 0, $this->params, 'int');
$sql = "select w.`ID`, w.`ID_PROCES`, w.`ID_ZASOB`, w.`OPIS_ZASOB`
, if(w.`ID_ZASOB`='{$this->q}', 100
, if(w.`ID_PROCES`='{$this->q}', 100
, if(w.`OPIS_ZASOB`='{$this->q}', 99
, if(w.`OPIS_ZASOB` like '{$this->q}%', 90
, if(w.`OPIS_ZASOB` like '%{$this->q}%', 80
, 0
)
)
)
)
) as hit_counter
from `CRM_WSKAZNIK` as w
join `CRM_PROCES` as p on(p.`ID`=w.`ID_PROCES`)
join `CRM_LISTA_ZASOBOW` as z on(z.`ID`=w.`ID_ZASOB`)
where {$sql_where}
order by hit_counter DESC, w.`ID` DESC
limit {$sql_limit} offset {$sql_offset}
";
$res = $this->db->query($sql);
while ($r = $this->db->fetch($res)) {
$list[$r->ID] = $r;
}
return $list;
}
}