<?
//ini_set('error_reporting', E_ALL);
//ini_set('display_errors', "On");

include_once('config.php');

if (!isset($_SESSION["user_id"]) and basename($_SERVER["SCRIPT_NAME"])!="ajax.php" and !isset($temp)) {
        include("login.php");
        exit();
}

function my_query($data){
    global $mysql_conn;
    global $config;
    global $on;
    mysqli_select_db($mysql_conn,$config['dbname']);


mysqli_set_charset($mysql_conn, "utf8");
//      printf("Error loading character set utf8: %s\n", $mysqli->error);
//	  }
	  
    $return= mysqli_query($mysql_conn,$data);
    if ($on!="on")
        die;
    if (mysqli_errno($mysql_conn)!=0){
        echo $data;
        echo mysqli_errno($mysql_conn) . ": " . mysqli_error($mysql_conn) . "\n";
    }
    return $return;
}

function get($get,$post=false){
    global $mysql_conn;
    if ($post && isset($_POST[$get])){
        if (is_array($_POST[$get]))
            //Have to correct later for array
            return $_POST[$get];
        else
            return mysqli_real_escape_string($mysql_conn,$_POST[$get]);
    }
    if (isset($_GET[$get])){
         if (is_array($_GET[$get]))
             ////Have to correct later for array
            return $_GET[$get];
        else
            return mysqli_real_escape_string($mysql_conn, $_GET[$get]);
    }
    return "";
}

function compare($a, $b, $true="selected", $false=false)
{
    if ($a==$b)
    {
        return $true;
    } 
    else
    {
        return $false;
    }
}

function fetch($result,$onerow = false){
	$array = array();
            while ($row = mysqli_fetch_assoc($result)) $array[] = $row;
	if ($onerow && isset($array[0])) return $array[0];
	return $array;
}

function check_permission($permission,$level='full'){
    //return true;
    $res = my_query("select count(*) cnt from `t_permissions` where user_id='".$_SESSION["usr"]["id"]."' and permission='$permission'");
    $row = mysqli_fetch_array( $res );
    if ($row["cnt"]>0) return true;
    return false;
}

//usage insert_from_array("t_lead_activity", array("field"=>"value","field"=>"value"..));
function insert_from_array($table, $query=array(),$comment='',$show_current_error=true) {
     if ((is_array($query))and(count($query) > 0)) {
            $keys = array();
            $values = array();
            foreach ($query as $key => $value) {
                if (!is_array($value)) {
                    $keys[] .= '`' . $key . '`';

                    if (is_int($value) || is_float($value)) {

                        $values[] .= $value;
                    } else {
                        $value=str_replace("'","''",$value);
						$value=str_replace("\\","\\\\",$value);    
						$values[] .= "'{$value}'";
                    }
                }

            }

            $keys = implode(',', $keys);
            $values = implode(',', $values);
        } else {
            $keys = '';
            $values = '';
        }

        $query = "INSERT INTO {$table} ($keys) VALUES($values)";
        //echo $query;
		$out=my_query($query);
                mysqli_error();
			
        return $out;

}

//usage update_from_array("t_lead_activity","WHERE id = 1" array("field"=>"value","field"=>"value"..));
function update_from_array($table, $params, $query=array(),$history_function=true) {
    $result = my_query("SHOW COLUMNS FROM $table");
    $rows = fetch($result); 
    
    foreach ($rows as $row) $fields[$row["Field"]] = $row["Field"];    

    $query = array_intersect_key($query, $fields);
    if ((is_array($query))and(count($query)>0)){
     $changes=array();
     foreach ($query as $key => $value){
          $value=str_replace("'","''",$value);
          $value=str_replace("\\","\\\\",$value);   
      $changes[] .= '`'.$key."` = '". $value ."'";
     }

     $changes = implode(', ', $changes);
     $query = "UPDATE {$table} SET {$changes} {$params}";
     
     $out=my_query($query); 
     
    } else {
     $out=null;
    }
    return $out;
}

//usage delete_from_array("t_lead_activity", "where id=6");
function delete_from_array($table, $params) {
        $query = "DELETE FROM {$table} $params";
		$out=my_query($query);
		return $out;		
}

function sql_to_array($res, $aColumns) {
$output=array();
while ( $aRow = mysqli_fetch_array( $res ) )
	{
		$row = array();
		for ( $i=0 ; $i<count($aColumns) ; $i++ )
		{
			if ( $aColumns[$i] == "version" )
			{
				/* Special output formatting for 'version' column */
				$row[] = ($aRow[ $aColumns[$i] ]=="0") ? '-' : $aRow[ $aColumns[$i] ];
			}
			else if ( $aColumns[$i] != ' ' )
			{
				/* General output */
				$row[] = $aRow[ $aColumns[$i] ];
			}
		}
		$output['aaData'][] = $row;
	}	
return $output;
}


function datetime_sql_to_format( $val, $opts ) {
	$date = $val;
	$date = date_create_from_format('Y-m-d H:i:s', $date);

        
        //$tz = new DateTimeZone('America/Los_Angeles');
        //$date->setTimezone($tz);
        
        // Allow empty strings or invalid dates
	if ( $date ) {
		return date_format( $date, $opts );
	}
	return '';
}

function date_sql_to_format( $val, $opts ) {
	$date = explode(" ", $val);
	$date = date_create_from_format('Y-m-d', $date[0]);

        
        //$tz = new DateTimeZone('America/Los_Angeles');
        //$date->setTimezone($tz);
        
        // Allow empty strings or invalid dates
	if ( $date ) {
		return date_format( $date, $opts );
	}
	return '';
}

function time_sql_to_format( $val, $opts ) {
	$time = date(TIME_FORMAT, strtotime($val));

	// Allow empty strings or invalid dates
	if ( $time ) {
		return $time;
	}
	return '';
}


function date_format_to_sql( $val, $opts ) {
        $val = explode(" ",$val);
        $val=$val[0];
	$date = date_create_from_format($opts, $val);
	if ( $date ) {
		return date_format( $date, 'Y-m-d' );
	}
	return null;
}

function time_format_to_sql( $val) {
    return date("H:i:s",strtotime($val));
}

function datetime_format_to_sql( $val, $opts ) {
	$date = date_create_from_format($opts, $val);
	if ( $date ) {
		return date_format( $date, 'Y-m-d H:i:s' );
	}
	return null;
}

function FormatTime($t){
    if ($t==0 || $t=="") return "";
    if ($t<60) return intval(gmdate("s", $t))." sec.";
    if ($t<3600) return intval(gmdate("i", $t))." min ".intval(gmdate("s", $t))." sec.";//  gmdate("n \m\i\\n s \s\e\c", $t);
    return intval(gmdate("H", $t))." h ".intval(gmdate("i", $t))." min ".intval(gmdate("s", $t))." sec.";;
}

function print_nice($elem,$max_level=10,$print_nice_stack=array()){
 if(is_array($elem) || is_object($elem)){
 if(in_array($elem,$print_nice_stack,true)){
 echo "<font color=red>RECURSION</font>";
 return;
 }
 $print_nice_stack[]=&$elem;
 if($max_level<1){
 echo "<font color=red>nivel maximo alcanzado</font>";
 return;
 }
 $max_level--;
 echo "<table border=1 cellspacing=0 cellpadding=3 width=100%>";
 if(is_array($elem)){
 echo '<tr><td colspan=2  style="background-color:#333333;"><strong><font  color=white>ARRAY</font></strong></td></tr>';
 }else{
 echo '<tr><td colspan=2 style="background-color:#333333;"><strong>';
 echo '<font color=white>'.(string)$elem.'</font><font color=gray> OBJECT Type: '.get_class($elem).'</font></strong></td></tr>';
 }
 $color=0;
 foreach($elem as $k => $v){
 if($max_level%2){
 $rgb=($color++%2)?"#888888":"#BBBBBB";
 }else{
 $rgb=($color++%2)?"#8888BB":"#BBBBFF";
 }
 echo '<tr><td valign="top" style="width:40px;background-color:'.$rgb.';">';
 echo '<strong>'.$k."</strong></td><td>";
 print_nice($v,$max_level,$print_nice_stack);
 echo "</td></tr>";
 }
 echo "</table>";
 return;
 }
 if($elem === null){
 echo "<font color=green>NULL</font>";
 }elseif($elem === 0){
 echo "0";
 }elseif($elem === true){
 echo "<font color=green>TRUE</font>";
 }elseif($elem === false){
 echo "<font color=green>FALSE</font>";
 }elseif($elem === ""){
 echo "<font color=green>EMPTY STRING</font>";
 }else{
 echo str_replace("\n","<strong><font color=red>*</font></strong><br>\n",$elem);
 }
 }
 
 function jqgridinfo($table,$get)
{

	if ($table=="t_pretenzijasP") {
		$table ="t_pretenzijas";
		$p="1";
	}
	
	if ($table=="t_pretenzijasA") {
		$table ="t_pretenzijas";
		$p="2";
	}
	
    $result = my_query("SHOW COLUMNS FROM $table");
    $rows = fetch($result); 
    $fields = array();
    foreach ($rows as $row) $fields[] = $row["Field"];
    
    $page= $get["page"];
    $limit=$get["rows"];
    $search=array();
    $searchOn = $get["_search"];
    if($searchOn=='true') {
        $sarr = $get;   
        foreach( $sarr as $k=>$v) {
            if (in_array($k,$fields)){
		$search[$k]=$v;
            }
        }
    }
    $q1=$q2=$q3=$q4=$q8=$q5=$q6=$q7=$q8=$q9=$q10="";
    
    if (isset($get["kompanija"]) and $get["kompanija"]!="")
        $q3="and object_id in (select id from t_klienti_objects where klienta_id in (select id from t_klienti where nosaukums like '%".$get["kompanija"]."%'))";
    
    if (isset($get["objekts"]) and $get["objekts"]!="")
        $q2="and object_id in (select id from t_klienti_objects where nosaukums like '%".$get["objekts"]."%')";
    
    if (isset($get["objekta_filtrs"]) and $get["objekta_filtrs"]!="" and $get["objekta_filtrs"]!="null")
        $q8="and object_id in (select id from t_klienti_objects where id in (".$get["objekta_filtrs"]."))";        
    
    if (isset($get["klienta_id_filter"]) and $get["klienta_id_filter"]!=""){
        $q1=" and klienta_id='".$get["klienta_id_filter"]."'";
    }
    
    if (isset($get["object_id_filter"]) and $get["object_id_filter"]!=""){
        $q1=" and object_id='".$get["object_id_filter"]."'";
    }
   
    //Filtri
    if (isset($get["kompanijas_filtrs"]) and $get["kompanijas_filtrs"]!="" and $get["kompanijas_filtrs"]!="null")
        $q4="and object_id in (select id from t_klienti_objects where klienta_id in (select id from t_klienti where id in (".$get["kompanijas_filtrs"].")))";

    if (isset($get["uznemuma_filtrs"]) and $get["uznemuma_filtrs"]!="" and $get["uznemuma_filtrs"]!="null")
        $q8="and uznemums in (select id from t_kompanijas where id in (".$get["uznemuma_filtrs"]."))";

    if (isset($get["izpilditajs_filtrs"]) and $get["izpilditajs_filtrs"]!="" and $get["izpilditajs_filtrs"]!="null")
        $q6="and izpilditajs like '%\"".$get["izpilditajs_filtrs"]."\"%'";
    
    if (isset($get["statusa_filtrs"]) and $get["statusa_filtrs"]!="" and $get["statusa_filtrs"]!="null")
        $q7="and status in ('".implode("','",explode(",",$get["statusa_filtrs"]))."')";
    
    if (isset($get["klients1"]) and $get["klients1"]!="" and $get["klients1"]!="null")
        $q2="and klienta_id in ('".implode("','",explode(",",$get["klients1"]))."')";
    if (isset($get["objekts1"]) and $get["objekts1"]!="" and $get["objekts1"]!="null")
        $q3="and object_id in ('".implode("','",explode(",",$get["objekts1"]))."')";
	
	if (isset($get["pretenzijas_type"]) and $get["pretenzijas_type"]!="")
		$q11="and status not in ('Izveidots', 'Nodots izpildei') ";

        
    //Datuma filtri
    if (isset($get["datuma_filtrs"]) and $get["datuma_filtrs"]!="" and $get["datuma_filtrs"]!="null"){
        if (isset($get["no"]) and $get["no"]!="" and $get["no"]!="null")
            $q9="and ".$get["datuma_filtrs"]." >='".$get["no"]."'";
        if (isset($get["lidz"]) and $get["lidz"]!="" and $get["lidz"]!="null")
            $q10="and ".$get["datuma_filtrs"]." <='".$get["lidz"]."'";
    }
    
    if ($table=="t_klienti" or $table=="t_buvniecibas_objekti_apaksuznemeji" or $table=="t_buvniecibas_objekti")
        $q1.=" and active='1' ";
	
    if ($table=="t_pretenzijas" or $table=="t_klienti_objects" or $table=="t_skaitiaja_radijumi" or $table=="t_skaitiaji")
        if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
            $q1.=" and klienta_id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    if ($table=="t_klienti")
        if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
            $q1.=" and id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";   
        
    if ($table=="t_pretenzijas" and in_array("pieteikumi_onlymy",$_SESSION["permissions"]))
        $q1.=" and izpilditajs like '%\"".$_SESSION["user_id"]."\"%' ";
       
    if (isset($get["pretenzijas_type"]) and $get["pretenzijas_type"]=="aktualais")
        $q5.=" and status in ('Izveidots', 'Nodots izpildei') ";

    if (isset($get["pretenzijas_type"]) and $get["pretenzijas_type"]=="atskaite")
        $q5.=" and status not in ('Izveidots', 'Nodots izpildei') ";
   
    $where="WHERE (1=1 $q1 $q2 $q3 $q4 $q8 $q5 $q6 $q7 $q8 $q9 $q10 ";    
    if (isset($search))  foreach( $search as $k=>&$v) {
				if (is_array($v)){
                                    $value=implode("','",$v);
                                    $where .= "and $k in ('$value')";
                                }
                                else{
                                    $v="%".$v."%";
                                    $where .= " and ".$k." like '%".$v."%'";
                                }
                        }
                        $where.=")";


$result = my_query("SELECT COUNT(*) AS count FROM $table l $where");
//echo "SELECT COUNT(*) AS count FROM $table l $where";
$row = fetch($result);
$count = $row[0]['count'];

    if( $count >0 ) {
            $total_pages = ceil($count/$limit);
    } else {
            $total_pages = 0;
    }
    if ($page > $total_pages) $page=$total_pages;
        $start = $limit*$page - $limit;
        if ($start<0) $start = 0;   
       $sidx= $get["sidx"];
   if(!$sidx) $sidx =1; 


 $data = array(
"filter"=>array(),
"search"=>$search,
"start" => $start,
"records" => $count,
"count" => $limit*$page,
"sort" => $sidx,
"order" => $get["sord"],
"echo" =>rand(0,9999),
 "total_pages"=>$total_pages);


 if (isset($get["klienta_id_filter"]) and $get["klienta_id_filter"]!="")
     $data["filter"]["klienta_id"]=$get["klienta_id_filter"];
  if (isset($get["object_id_filter"]) and $get["object_id_filter"]!="")
     $data["filter"]["object_id"]=$get["object_id_filter"];
  if (isset($get["objekts"]) and $get["objekts"]!="")
     $data["objekts"]=$get["objekts"];
  if (isset($get["kompanija"]) and $get["kompanija"]!="")
     $data["kompanija"]=$get["kompanija"];
    if (isset($get["klients1"]) and $get["klients1"]!="")
     $data["klients1"]=$get["klients1"];
      if (isset($get["objekts1"]) and $get["objekts1"]!="")
     $data["objekts1"]=$get["objekts1"];
 //maris 
  if (isset($get["uznemuma_filtrs"]) and $get["uznemuma_filtrs"]!="" and $get["uznemuma_filtrs"]!="null")
     $data["uznemuma_filtrs"]=$get["uznemuma_filtrs"];

  if (isset($get["kompanijas_filtrs"]) and $get["kompanijas_filtrs"]!="" and $get["kompanijas_filtrs"]!="null")
     $data["kompanijas_filtrs"]=$get["kompanijas_filtrs"];
  if (isset($get["objekta_filtrs"]) and $get["objekta_filtrs"]!="" and $get["objekta_filtrs"]!="null")
     $data["objekta_filtrs"]=$get["objekta_filtrs"];
   if (isset($get["izpilditajs_filtrs"]) and $get["izpilditajs_filtrs"]!="" and $get["izpilditajs_filtrs"]!="null")
     $data["izpilditajs_filtrs"]=$get["izpilditajs_filtrs"];
    if (isset($get["statusa_filtrs"]) and $get["statusa_filtrs"]!="" and $get["statusa_filtrs"]!="null")
     $data["statusa_filtrs"]=$get["statusa_filtrs"];
 
	if (isset($get["pretenzijas_type"]) and $get["pretenzijas_type"]!="")
		$data["pretenzijas_type"]=$get["pretenzijas_type"];
    //Datumu filtri
    if (isset($get["datuma_filtrs"]) and $get["datuma_filtrs"]!="" and $get["datuma_filtrs"]!="null")
        $data["datuma_filtrs"]=$get["datuma_filtrs"];
    if (isset($get["no"]) and $get["no"]!="" and $get["no"]!="null")
        $data["no"]=$get["no"];
    if (isset($get["lidz"]) and $get["lidz"]!="" and $get["lidz"]!="null")
        $data["lidz"]=$get["lidz"];
  
 return $data;
}

//Users
function getUserCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
                                if (is_array($v)){
                                    $value=implode("','",$v);
                                    $where .= " and $k in ('$value')";
                                }
                                else
                                    $where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_users $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";

    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
//    var_dump($output);
   return $output;
    
}

function getUser($id){
   $data=array(
        "filter"=>array("id"=>$id),
        "search"=>array(), 
        "echo" =>rand(0,9999),
        "sort" =>"id",
        "order" => "desc",
        "start" =>0,
        "count" =>1  
    );
     $data= getUserCollection($data);   
        if ($data["total"]>0) 
       return $data["rows"][0];
   else 
       return array();
    
}

//Klienti
function getClientCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 and active='1' ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
        $where.=" and id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_klienti $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getClient($id){
   $data=array(
        "filter"=>array("id"=>$id),
        "search"=>array(), 
        "echo" =>rand(0,9999),
        "sort" =>"id",
        "order" => "desc",
        "start" =>0,
        "count" =>1  
    );
     $data= getClientCollection($data);
        if ($data["total"]>0) 
       return $data["rows"][0];
   else 
       return array();
    
}

function getObjectCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where = "WHERE (1=1 and active='1' ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
        $where.=" and klienta_id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_klienti_objects $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getObject($id){
   $data=array(
        "filter"=>array("id"=>$id),
        "search"=>array(), 
        "echo" =>rand(0,9999),
        "sort" =>"id",
        "order" => "desc",
        "start" =>0,
        "count" =>1  
    );
     $data= getObjectCollection($data);
        if ($data["total"]>0) 
       return $data["rows"][0];
   else 
       return array();
    
}

function getDarbaKodiCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_darba_kodi $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getKontaktpersonasCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_klienti_objects_contacts $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getIekartasCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) {if ($data["sort"]=="grupa_name") $data["sort"]="grupa_name ".$data["order"].", iekarta"; $order="ORDER BY ".$data["sort"]." ".$data["order"]; }else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select i.*,g.grupa as grupa_name from t_klienti_objects_iekartas i left join t_grupas g on i.grupa=g.id $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}
//$ligumi=getLigumiCollection(array("sort"=>"liguma_nr","order"=>"asc","filter"=>array("liguma_nr"=>"5"));
function getLigumiCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_klienti_objects_ligumi $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

//Pieteikumu saraksts
function getPretenzijasCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order="";

    if (isset($data["sort"]) and $data["sort"]=="status")
        $order="ORDER by seciba desc, izpildes_termins desc";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where=" ";
    $q2=$q3=$q4=$q8=$q5=$q6=$q7=$q9=$q10="";
    if (isset($data["objekts"]) and $data["objekts"]!="")
        $q2="and object_id in (select id from t_klienti_objects where nosaukums like '%".$data["objekts"]."%')";
    if (isset($data["kompanija"]) and $data["kompanija"]!="")
        $q3="and object_id in (select id from t_klienti_objects where klienta_id in (select id from t_klienti where nosaukums like '%".$data["kompanija"]."%'))";

//maris
    if (isset($data["uznemuma_filtrs"]) and $data["uznemuma_filtrs"]!="")
        $q8="and uznemums in (select id from t_kompanijas where id in (".$data["uznemuma_filtrs"]."))";
    
    if (isset($data["kompanijas_filtrs"]) and $data["kompanijas_filtrs"]!="")
        $q4="and object_id in (select id from t_klienti_objects where klienta_id in (select id from t_klienti where id in (".$data["kompanijas_filtrs"].")))";
        
    if (isset($data["objekta_filtrs"]) and $data["objekta_filtrs"]!="")
        $q5="and object_id in (select id from t_klienti_objects where id in (".$data["objekta_filtrs"]."))";
    
    if (isset($data["izpilditajs_filtrs"]) and $data["izpilditajs_filtrs"]!="")
        $q6="and izpilditajs like '%\"".$data["izpilditajs_filtrs"]."\"%'";
        
    if (isset($data["statusa_filtrs"]) and $data["statusa_filtrs"]!="")
        $q7="and status in ('".implode("','",explode(",",$data["statusa_filtrs"]))."')";
	
     if (isset($data["pretenzijas_type"]) and $data["pretenzijas_type"]=="aktualais")
        $q7.=" and status in ('Izveidots', 'Nodots izpildei') ";

    if (isset($data["pretenzijas_type"]) and $data["pretenzijas_type"]=="atskaite")
        $q7.=" and status not in ('Izveidots', 'Nodots izpildei') ";
    
     if (isset($data["datuma_filtrs"]) and $data["datuma_filtrs"]!="" and $data["datuma_filtrs"]!="null"){
        if (isset($data["no"]) and $data["no"]!="" and $data["no"]!="null")
            $q9="and ".$data["datuma_filtrs"]." >='".$data["no"]."'";
        if (isset($data["lidz"]) and $data["lidz"]!="" and $data["lidz"]!="null")
            $q10="and ".$data["datuma_filtrs"]." <='".$data["lidz"]."'";
    }
    
    $x="";
    if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
        $x=" and klienta_id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    //pielikts klāt ka rāda tikai Izveidotos un nodotos izpildei
	$where = "WHERE (1=1 $x $q2 $q3  $q4 $q8 $q5 $q6 $q7 $q9 $q10";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
    if (in_array("pieteikumi_onlymy",$_SESSION["permissions"]))  
        $where.=" and izpilditajs like '%\"".$_SESSION["user_id"]."\"%'";
                        
    $SQL="select *,case 
            when status='Izveidots' then 3
            when status='Nodots izpildei' then 2
            when status='Izpildīts' then 1
            when status='Atcelts' then 0 end as seciba,
            (select o.nosaukums from t_klienti_objects o where o.id=p.object_id) as objekts,
            (select nosaukums from t_klienti where id =(select o.klienta_id from t_klienti_objects o where o.id=p.object_id)) as kompanija
            from t_pretenzijas p $where $order $limit";
    //echo $SQL;
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
//    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}
//Atskaites pārskats
function getPretenzijasCollectionAtskaite($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order="";

    if (isset($data["sort"]) and $data["sort"]=="status")
        $order="ORDER by seciba desc, izpildes_termins desc";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $q2=$q3=$q4=$q8=$q5=$q6=$q7=$q9=$q10="";
    if (isset($data["objekts"]) and $data["objekts"]!="")
        $q2="and object_id in (select id from t_klienti_objects where nosaukums like '%".$data["objekts"]."%')";
    if (isset($data["kompanija"]) and $data["kompanija"]!="")
        $q3="and object_id in (select id from t_klienti_objects where klienta_id in (select id from t_klienti where nosaukums like '%".$data["kompanija"]."%'))";

//maris
    if (isset($data["uznemuma_filtrs"]) and $data["uznemuma_filtrs"]!="")
        $q8="and uznemums in (select id from t_kompanijas where id in (".$data["uznemuma_filtrs"]."))";
    
    if (isset($data["kompanijas_filtrs"]) and $data["kompanijas_filtrs"]!="")
        $q4="and object_id in (select id from t_klienti_objects where klienta_id in (select id from t_klienti where id in (".$data["kompanijas_filtrs"].")))";
        
    if (isset($data["objekta_filtrs"]) and $data["objekta_filtrs"]!="")
        $q5="and object_id in (select id from t_klienti_objects where id in (".$data["objekta_filtrs"]."))";
    
    if (isset($data["izpilditajs_filtrs"]) and $data["izpilditajs_filtrs"]!="")
        $q6="and izpilditajs like '%\"".$data["izpilditajs_filtrs"]."\"%'";
        
    if (isset($data["statusa_filtrs"]) and $data["statusa_filtrs"]!="")
        $q7="and status in ('".implode("','",explode(",",$data["statusa_filtrs"]))."')";
    
     if (isset($data["datuma_filtrs"]) and $data["datuma_filtrs"]!="" and $data["datuma_filtrs"]!="null"){
        if (isset($data["no"]) and $data["no"]!="" and $data["no"]!="null")
            $q9="and ".$data["datuma_filtrs"]." >='".$data["no"]."'";
        if (isset($data["lidz"]) and $data["lidz"]!="" and $data["lidz"]!="null")
            $q10="and ".$data["datuma_filtrs"]." <='".$data["lidz"]."'";
    }
    
    $x="";
    if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
        $x=" and klienta_id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    //pielikts klāt ka nerāda tikai Izveidotos un nodotos izpildei
	$where = "WHERE (status not in ('Izveidots', 'Nodots izpildei') $x $q2 $q3  $q4 $q8 $q5 $q6 $q7 $q9 $q10";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
    if (in_array("pieteikumi_onlymy",$_SESSION["permissions"]))  
        $where.=" and izpilditajs like '%\"".$_SESSION["user_id"]."\"%'";
                        
    $SQL="select *,case 
            when status='Izveidots' then 3
            when status='Nodots izpildei' then 2
            when status='Izpildīts' then 1
            when status='Atcelts' then 0 end as seciba,
            (select o.nosaukums from t_klienti_objects o where o.id=p.object_id) as objekts,
            (select nosaukums from t_klienti where id =(select o.klienta_id from t_klienti_objects o where o.id=p.object_id)) as kompanija
            from t_pretenzijas p $where $order $limit";
    //echo $SQL;
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
//    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}


function getPretenzija($id){
   $data=array(
        "filter"=>array("id"=>$id),
        "search"=>array(), 
        "echo" =>rand(0,9999),
        "sort" =>"id",
        "order" => "desc",
        "start" =>0,
        "count" =>1  
    );
     $data= getPretenzijasCollection($data);
        if ($data["total"]>0) 
       return $data["rows"][0];
   else 
       return array();
    
}

function getHoursCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_klienti_objects_ligumi_stundas $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getRekiniCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_rekini $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getKomentariCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_komentari $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
//    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getIzpilditsCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_izpildits $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getKompanijasCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_kompanijas $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getKompanija($id){
   $data=array(
        "filter"=>array("id"=>$id),
        "search"=>array(), 
        "echo" =>rand(0,9999),
        "sort" =>"id",
        "order" => "desc",
        "start" =>0,
        "count" =>1  
    );
     $data= getKompanijasCollection($data);
        if ($data["total"]>0) 
       return $data["rows"][0];
   else 
       return array();
    
}

function getFilesCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_files $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getPermissionCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_permissions $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count=0;// 09/09/2019 bija "" ieliku 0 deļ log faila kļūdam Māris
    if (isset($data["start"])) $start=$data["start"]; else $start=0;// 09/09/2019 bija "" ieliku 0 deļ log faila kļūdam Māris
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getGrupasCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_grupas $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getFile($id){
   $data=array(
        "filter"=>array("id"=>$id),
        "search"=>array(), 
        "echo" =>rand(0,9999),
        "sort" =>"id",
        "order" => "desc",
        "start" =>0,
        "count" =>1  
    );
     $data= getFilesCollection($data);
        if ($data["total"]>0) 
       return $data["rows"][0];
   else 
       return array();
    
}

function SendMail($id,$mail_izpilditajs=array(),$file_uploded=0){
//    require("phpmailer/PHPMailerAutoload.php");
//    $mail = new PHPMailer();
//    $mail->CharSet = 'UTF-8';
//    $mail->isMail();
//    $mail->From="kvs@cander.lv";
//    $mail->FromName="KVS";
//    $mail->Sender="kvs@cander.lv";
    require("phpmailer/PHPMailerAutoload.php");
    $mail = new PHPMailer();
    $mail->CharSet = 'UTF-8';
    $mail->isMail();
    $mail->setFrom('kvs@cander.lv', 'KVS');
    $mail->addReplyTo('kvs@cander.lv');


    $mail_array=array();
    $pretenzija=  getPretenzija($id);
    $kontaktperonas=getKontaktpersonasCollection(array("filter"=>array("id"=>$pretenzija["kontaktpersonas_id"])));
    foreach ($kontaktperonas["rows"] as $kontaktpersona)
        if (isset($kontaktpersona["epasts"]) and $kontaktpersona["epasts"]!="")
            $mail_array[]=$kontaktpersona["epasts"];

    $assigned=getObject($pretenzija["object_id"]);
    $mail_array[]=$assigned["epasts"];
    $assigned_persons="";
    $assigned_persons=json_decode($assigned["atbildiga_persona"]);
    if ($assigned_persons!="")
    foreach ($assigned_persons as $persona){
        $user=getUser($persona);
        if (isset($user["epasts"]) and $user["epasts"]!="")
        $mail_array[]=$user["epasts"];
    }
    $izpilditatjs="";
    $izpilditatjs=json_decode($pretenzija["izpilditajs"]);
    if ($izpilditatjs!="")
    foreach ($izpilditatjs as $persona){
        $user=getUser($persona);
        if (isset($user["epasts"]) and $user["epasts"]!="")
        $mail_array[]=$user["epasts"];
    }

    $mail_array=array_unique($mail_array);
    $objekts=  getObject($pretenzija["object_id"]);
    $kompanija=  getClient($objekts["klienta_id"]);

    foreach ($mail_array as $mails){
            $mail->AddAddress($mails);
    }
    $mail->IsHTML(true);
    $uznemums=  getKompanija($pretenzija["uznemums"]);
    

    $user=getUser($pretenzija["createdby"]);
    $kontaktpersona_meilam=getKontaktpersonasCollection(array("filter"=>array("id"=>$pretenzija["kontaktpersonas_id"])));
    if (isset($kontaktpersona_meilam["rows"][0]))
        $kontaktpersona_meilam=$kontaktpersona_meilam["rows"][0];
    else
        $kontaktpersona_meilam="";
    //Mail    
    if ($pretenzija["status"]=="Izveidots")
        $teksts="Jūsu pieteikums ir saņemts!";
    else
        $teksts="Pieteikumam mainīts status!";
    $subject = 'Nr.'.$id.', statuss: '.$pretenzija["status"];
    $komentars=  getKomentariCollection(array("sort"=>"created","order"=>"desc","filter"=>array("pretenzijas_id"=>$pretenzija["id"])));
            if (isset($komentars["rows"][0]))
                $pretenzija["apraksts"]=$komentars["rows"][0]["komentars"];

    $faktiski_izpildits_teksts="";
    $faktiski_izdarits=  getIzpilditsCollection(array("sort"=>"created","order"=>"desc","filter"=>array("pretenzijas_id"=>$pretenzija["id"])));
        if (isset($faktiski_izdarits["rows"][0]) and $pretenzija["status"]=="Izpildīts")
            $faktiski_izpildits_teksts="Faktiski izdarīts: ".$faktiski_izdarits["rows"][0]["izpildits"]."<br/>";

    $message = '
        <html>
        <body>
        Sveicināti!<br/>
        '.$teksts.'<br/><br/>

        <b>Status: '.$pretenzija["status"].'</b><br/>
        Pieteikums Nr: <b>'.$pretenzija["id"].'</b><br/>
        Pieteikums reģistrēts: '.$pretenzija["created"].'<br/>
        Pieteikumu ievadīja: '.$user["username"].', '.$user["talrunis"].', <a href="mailto:'.$user["epasts"].'">'.$user["epasts"].'</a><br/>
        Pieteicējs: '.$kontaktpersona_meilam["vards"].' '.$kontaktpersona_meilam["uzvards"].', '.$kontaktpersona_meilam["telefons"].', <a href="mailto:'.$kontaktpersona_meilam["epasts"].'">'.$kontaktpersona_meilam["epasts"].'</a><br/>
        Objekts: '.$kompanija["nosaukums"].'<br/>
        Klients: '.$objekts["nosaukums"].'<br/>
        Termiņš: '.$pretenzija["izpildes_termins"].'<br/>
        Problēmas apraksts: '.$pretenzija["uzdevums"].'<br/>
        Komentāri: '.$pretenzija["apraksts"].'<br/>
        '.$faktiski_izpildits_teksts.'
        <br/>';
    if (isset($uznemums["nosaukums"])){
        $message.='
        <table><tr><td>
        Ar cieņu,<br/>
        '.$uznemums["nosaukums"].'<br/>
        Tālr: '.$uznemums["telefons"].'<br/>';
        if (isset ($uznemums["epasts"]) and $uznemums["epasts"]!="")
         $message .=   'E-pasts: <a href="mailto:'.$uznemums["epasts"].'">'.$uznemums["epasts"].'</a>';
        $message .='</td>';
        if (isset ($uznemums["bilde"]) and file_exists($uznemums["bilde"])){ 
            $mail->AddEmbeddedImage($uznemums["bilde"], 'logoimg'); // attach file logo.jpg, and later link to it using identfier logoimg
            $message .='<td><img width="130" src="cid:logoimg" style="width:130;">';
        }
        $message .='</tr></table>';
    }
   $message .=' </body>
    </html>
        ';
   $mail->Body=$message;
   $mail->Subject = $subject;
   if ($file_uploded=="1"){
        $files=  getFilesCollection(array("filter"=>array("pretenzijas_id"=>$pretenzija["id"])));
        foreach ($files["rows"] as $file)
            $mail->AddAttachment('files/'.$pretenzija["id"].'/'.$file["name"]);      // attachment
   }

   if(!$mail->Send())
    {
        return "Error sending: " . $mail->ErrorInfo;;
    }
    else
    {
       return "Letter is sent";
    }
}

function rekinaNumurs($counter=""){
    $result=my_query("select count(*) as cnt, YEAR(now()) as year,month(now()) as month from t_rekini where YEAR(created)=YEAR(now()) and MONTH(created)=MONTH(now())");
    $result=fetch($result);
    if ($counter=="")
        return $result[0]["year"].$result[0]["month"]."-".($result[0]["cnt"]+1);
    else{
        $return=array();
        $return["counter"]=$result[0]["cnt"]+1;
        $return["year"]=$result[0]["year"];
        return $return;
        
    }
        
}

function getMervienibasCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_mervienibas $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

 function object_to_array($data)
{
    if (is_array($data) || is_object($data))
    {
        $result = array();
        foreach ($data as $key => $value)
        {
            $result[$key] = object_to_array($value);
        }
        return $result;
    }
    return $data;
}

function getSkaititajiCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["klients1"]) and $data["klients1"]!="" and $data["klients1"]!="null")
        $where .="and klienta_id in ('".implode("','",explode(",",$data["klients1"]))."')";
    if (isset($data["objekts1"]) and $data["objekts1"]!="" and $data["objekts1"]!="null")
        $where .="and object_id in ('".implode("','",explode(",",$data["objekts1"]))."')";
    
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
        $where.=" and klienta_id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_skaititaji $where $order $limit";
    //echo $SQL;
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;   
}

function getSkaititajuRadijumiCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["klients1"]) and $data["klients1"]!="" and $data["klients1"]!="null")
        $where .="and klienta_id in ('".implode("','",explode(",",$data["klients1"]))."')";
    if (isset($data["objekts1"]) and $data["objekts1"]!="" and $data["objekts1"]!="null")
        $where .="and object_id in ('".implode("','",explode(",",$data["objekts1"]))."')";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($_SESSION["user"]["klienti_allow"]) and $_SESSION["user"]["klienti_allow"]!="")
        $where.=" and klienta_id in ('".implode("','",json_decode($_SESSION["user"]["klienti_allow"]))."')";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_skaitiaja_radijumi $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}
function getSkaititajuRadijumiViewCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["klients1"]) and $data["klients1"]!="" and $data["klients1"]!="null")
        $where .="and klienta_id in ('".implode("','",explode(",",$data["klients1"]))."')";
    if (isset($data["objekts1"]) and $data["objekts1"]!="" and $data["objekts1"]!="null")
        $where .="and object_id in ('".implode("','",explode(",",$data["objekts1"]))."')";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_radijumi_view $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output;
    
}

function getBuvniecibasObjektiCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 and active=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
				$where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_buvniecibas_objekti $where $order $limit";
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if($count != 0 and $count + $start != 0)
    {
       $page = ($count - $start) / $count;

    }else {
        $page = 0;
    }
//    if ($count + $start != 0) {
//        $page = ($count - $start) / $count;
//    } else {
//        $page = 0;
//    }
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output; 
}

function getBuvniecibasObjektiApaksuznemejiCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 and active=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
                                if (is_array($v)){
                                    $value=implode("','",$v);
                                    $where .= " and $k in ('$value')";
                                }
                                else
                                    $where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_buvniecibas_objekti_apaksuznemeji $where $order $limit";

    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if($count != 0)
    {
      if ($count+$start!=0) $page=($count-$start)/$count;

    }else $page=0;
//    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output; 
}

function getBuvniecibasObjektiAtskaiteCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
                                if (is_array($v)){
                                    $value=implode("','",$v);
                                    $where .= " and $k in ('$value')";
                                }
                                else
                                    $where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_bo_statistics $where $order $limit";

    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output; 
}

//Pārskata funkcionalitate
function getBOParskatsCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
                                if (is_array($v)){
                                    $value=implode("','",$v);
                                    $where .= " and $k in ('$value')";
                                }
                                else
                                    $where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_bo_stat_visual $where $order $limit";

    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output; 
}

//atskaites funkcionalitāte
function getBOAtskaiteCollection($data){
    if (isset($data["sort"]) and isset($data["order"])) $order="ORDER BY ".$data["sort"]." ".$data["order"]; else $order=";";
    if (isset($data["count"]) and isset($data["start"])) $limit="LIMIT ".$data["start"].", ".$data["count"]; else $limit="";
    $where="";
    $where = "WHERE (1=1 ";
    if (isset($data["notnull"])) $where.= "AND ".$data["notnull"]." is not null and ".$data["notnull"]."!=''";
    if (isset($data["filter"])) foreach( $data["filter"] as $k=>$v) {
				$where .= " AND ".$k." = '".$v."'";
                        }
    $where.=") and (1=1";
    if (isset($data["search"]))  foreach( $data["search"] as $k=>$v) {
                                if (is_array($v)){
                                    $value=implode("','",$v);
                                    $where .= " and $k in ('$value')";
                                }
                                else
                                    $where .= " and ".$k." like '".$v."'";
                        }
                        $where.=")";
                        
    $SQL="select * from t_bo_summary_view $where $order $limit";
	
    $result = my_query( $SQL ) or die("Couldn t execute query.".mysqli_error());
	
    if (isset($data["echo"])) $echo=$data["echo"]; else $echo="";
    if (isset($data["count"])) $count=$data["count"]; else $count="";
    if (isset($data["start"])) $start=$data["start"]; else $start="";
    if ($count+$start!=0) $page=($count-$start)/$count; else $page=0;
    $output["rows"] = fetch($result);
    $output["echo"] = $echo;
    $output["total"] = count($output["rows"]);
    $output["page"] = $page;
   return $output; 
}
?>