$value)
if(substr($key,0,strlen($strTableName)+1)==$strTableName."_" &&
strpos(substr($key,strlen($strTableName)+1),"_")===false)
$sess_unset[] = $key;
foreach($sess_unset as $key)
unset($_SESSION[$key]);
}
// Before Process event
if(function_exists("BeforeProcessList"))
BeforeProcessList($conn);
if(@$_REQUEST["a"]=="showall")
$_SESSION[$strTableName."_search"]=0;
else if(@$_REQUEST["a"]=="search")
{
$_SESSION[$strTableName."_searchfield"]=postvalue("SearchField");
$_SESSION[$strTableName."_searchoption"]=postvalue("SearchOption");
$_SESSION[$strTableName."_searchfor"]=postvalue("SearchFor");
if(postvalue("SearchFor")!="" || postvalue("SearchOption")=='Empty')
$_SESSION[$strTableName."_search"]=1;
else
$_SESSION[$strTableName."_search"]=0;
$_SESSION[$strTableName."_pagenumber"]=1;
}
else if(@$_REQUEST["a"]=="advsearch")
{
$_SESSION[$strTableName."_asearchnot"]=array();
$_SESSION[$strTableName."_asearchopt"]=array();
$_SESSION[$strTableName."_asearchfor"]=array();
$_SESSION[$strTableName."_asearchfor2"]=array();
$tosearch=0;
$asearchfield = postvalue("asearchfield");
$_SESSION[$strTableName."_asearchtype"] = postvalue("type");
if(!$_SESSION[$strTableName."_asearchtype"])
$_SESSION[$strTableName."_asearchtype"]="and";
foreach($asearchfield as $field)
{
$gfield=GoodFieldName($field);
$asopt=postvalue("asearchopt_".$gfield);
$value1=postvalue("value_".$gfield);
$type=postvalue("type_".$gfield);
$value2=postvalue("value1_".$gfield);
$not=postvalue("not_".$gfield);
if($value1 || $asopt=='Empty')
{
$tosearch=1;
$_SESSION[$strTableName."_asearchopt"][$field]=$asopt;
if(!is_array($value1))
$_SESSION[$strTableName."_asearchfor"][$field]=$value1;
else
$_SESSION[$strTableName."_asearchfor"][$field]=combinevalues($value1);
$_SESSION[$strTableName."_asearchfortype"][$field]=$type;
if($value2)
$_SESSION[$strTableName."_asearchfor2"][$field]=$value2;
$_SESSION[$strTableName."_asearchnot"][$field]=($not=="on");
}
}
if($tosearch)
$_SESSION[$strTableName."_search"]=2;
else
$_SESSION[$strTableName."_search"]=0;
$_SESSION[$strTableName."_pagenumber"]=1;
}
if(@$_REQUEST["orderby"])
$_SESSION[$strTableName."_orderby"]=@$_REQUEST["orderby"];
if(@$_REQUEST["pagesize"])
{
$_SESSION[$strTableName."_pagesize"]=@$_REQUEST["pagesize"];
$_SESSION[$strTableName."_pagenumber"]=1;
}
if(@$_REQUEST["goto"])
$_SESSION[$strTableName."_pagenumber"]=@$_REQUEST["goto"];
// process reqest data - end
$includes="";
$includes.="\r\n";
if ($useAJAX) {
$includes.="\r\n";
}
$includes.="\n".
"\n";
if ($useAJAX) {
$includes.="";
$includes.="";
}
$smarty->assign("includes",$includes);
$smarty->assign("useAJAX",$useAJAX);
// process session variables
// order by
$strOrderBy="";
$order_ind=-1;
$smarty->assign("order_dir_nome","a");
$smarty->assign("order_dir_cpf","a");
$smarty->assign("order_dir_email","a");
$smarty->assign("order_dir_sexo","a");
$smarty->assign("order_dir_estadoCivil","a");
$smarty->assign("order_dir_dataNascimento","a");
$smarty->assign("order_dir_cidade","a");
$smarty->assign("order_dir_telefone","a");
$smarty->assign("order_dir_celular","a");
$smarty->assign("order_dir_tempoExperiencia","a");
$smarty->assign("order_dir_categoria","a");
$smarty->assign("order_dir_turnoEstuda","a");
$smarty->assign("order_dir_possuiOab","a");
$smarty->assign("order_dir_oab","a");
$smarty->assign("order_dir_graduacao","a");
$smarty->assign("order_dir_interesseTecnico","a");
$smarty->assign("order_dir_area","a");
$recno=1;
$numrows=0;
if(@$_SESSION[$strTableName."_orderby"])
{
$order_field=substr($_SESSION[$strTableName."_orderby"],1);
$order_dir=substr($_SESSION[$strTableName."_orderby"],0,1);
$order_ind=GetFieldIndex($order_field);
$smarty->assign("order_dir_nome","a");
if($order_field=="nome")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_nome","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_nome","![](\"images/".$img.".gif\")
");
}
$smarty->assign("order_dir_cpf","a");
if($order_field=="cpf")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_cpf","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_cpf","");
}
$smarty->assign("order_dir_email","a");
if($order_field=="email")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_email","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_email","");
}
$smarty->assign("order_dir_sexo","a");
if($order_field=="sexo")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_sexo","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_sexo","");
}
$smarty->assign("order_dir_estadoCivil","a");
if($order_field=="estadoCivil")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_estadoCivil","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_estadoCivil","");
}
$smarty->assign("order_dir_dataNascimento","a");
if($order_field=="dataNascimento")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_dataNascimento","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_dataNascimento","");
}
$smarty->assign("order_dir_cidade","a");
if($order_field=="cidade")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_cidade","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_cidade","");
}
$smarty->assign("order_dir_telefone","a");
if($order_field=="telefone")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_telefone","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_telefone","");
}
$smarty->assign("order_dir_celular","a");
if($order_field=="celular")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_celular","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_celular","");
}
$smarty->assign("order_dir_tempoExperiencia","a");
if($order_field=="tempoExperiencia")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_tempoExperiencia","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_tempoExperiencia","");
}
$smarty->assign("order_dir_categoria","a");
if($order_field=="categoria")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_categoria","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_categoria","");
}
$smarty->assign("order_dir_turnoEstuda","a");
if($order_field=="turnoEstuda")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_turnoEstuda","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_turnoEstuda","");
}
$smarty->assign("order_dir_possuiOab","a");
if($order_field=="possuiOab")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_possuiOab","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_possuiOab","");
}
$smarty->assign("order_dir_oab","a");
if($order_field=="oab")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_oab","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_oab","");
}
$smarty->assign("order_dir_graduacao","a");
if($order_field=="graduacao")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_graduacao","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_graduacao","");
}
$smarty->assign("order_dir_interesseTecnico","a");
if($order_field=="interesseTecnico")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_interesseTecnico","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_interesseTecnico","");
}
$smarty->assign("order_dir_area","a");
if($order_field=="area")
{
if($order_dir=="a")
{
$smarty->assign("order_dir_area","d");
$img="up";
}
else
$img="down";
$smarty->assign("order_image_area","");
}
if($order_ind)
{
if($order_dir=="a")
$strOrderBy="order by ".($order_ind)." asc";
else
$strOrderBy="order by ".($order_ind)." desc";
}
}
if(!$strOrderBy)
$strOrderBy=$gstrOrderBy;
// page number
$mypage=(integer)$_SESSION[$strTableName."_pagenumber"];
if(!$mypage)
$mypage=1;
// page size
$PageSize=(integer)$_SESSION[$strTableName."_pagesize"];
if(!$PageSize)
$PageSize=$gPageSize;
$smarty->assign("rpp10_selected",($PageSize==10)?"selected":"");
$smarty->assign("rpp20_selected",($PageSize==20)?"selected":"");
$smarty->assign("rpp30_selected",($PageSize==30)?"selected":"");
$smarty->assign("rpp50_selected",($PageSize==50)?"selected":"");
$smarty->assign("rpp100_selected",($PageSize==100)?"selected":"");
$smarty->assign("rpp500_selected",($PageSize==500)?"selected":"");
// delete record
$selected_recs=array();
if (@$_REQUEST["mdelete"])
{
foreach(@$_REQUEST["mdelete"] as $ind)
{
$keys=array();
$selected_recs[]=$keys;
}
}
elseif(@$_REQUEST["selection"])
{
foreach(@$_REQUEST["selection"] as $keyblock)
{
$arr=split("&",refine($keyblock));
if(count($arr)<0)
continue;
$keys=array();
$selected_recs[]=$keys;
}
}
$records_deleted=0;
foreach($selected_recs as $keys)
{
$where = KeyWhere($keys);
$strSQL="delete from ".AddTableWrappers($strOriginalTableName)." where ".$where;
$retval=true;
if(function_exists("AfterDelete") || function_exists("BeforeDelete"))
{
$deletedrs = db_query(gSQLWhere($where),$conn);
$deleted_values = db_fetch_array($deletedrs);
}
if(function_exists("BeforeDelete"))
$retval = BeforeDelete($where,$deleted_values);
if($retval && @$_REQUEST["a"]=="delete")
{
$records_deleted++;
LogInfo($strSQL);
db_exec($strSQL,$conn);
if(function_exists("AfterDelete"))
AfterDelete($where,$deleted_values);
}
}
if(count($selected_recs))
{
if(function_exists("AfterMassDelete"))
AfterMassDelete($records_deleted);
}
// make sql "select" string
//$strSQL = $gstrSQL;
$strWhereClause="";
// add search params
if(@$_SESSION[$strTableName."_search"]==1)
// regular search
{
$strSearchFor=trim($_SESSION[$strTableName."_searchfor"]);
$strSearchOption=trim($_SESSION[$strTableName."_searchoption"]);
if(@$_SESSION[$strTableName."_searchfield"])
{
$strSearchField = $_SESSION[$strTableName."_searchfield"];
if($where = StrWhere($strSearchField, $strSearchFor, $strSearchOption, ""))
$strWhereClause = whereAdd($strWhereClause,$where);
// $strSQL = AddWhere($strSQL,$where);
else
$strWhereClause = whereAdd($strWhereClause,"1=0");
// $strSQL = AddWhere($strSQL,"1=0");
}
else
{
$strWhere = "1=0";
if($where=StrWhere("nome", $strSearchFor, $strSearchOption, ""))
$strWhere .= " or ".$where;
if($where=StrWhere("cpf", $strSearchFor, $strSearchOption, ""))
$strWhere .= " or ".$where;
if($where=StrWhere("oab", $strSearchFor, $strSearchOption, ""))
$strWhere .= " or ".$where;
$strWhereClause = whereAdd($strWhereClause,$strWhere);
// $strSQL = AddWhere($strSQL,$strWhere);
}
}
else if(@$_SESSION[$strTableName."_search"]==2)
// advanced search
{
$sWhere="";
foreach(@$_SESSION[$strTableName."_asearchfor"] as $f => $sfor)
{
$strSearchFor=trim($sfor);
$strSearchFor2="";
$type=@$_SESSION[$strTableName."_asearchfortype"][$f];
if(array_key_exists($f,@$_SESSION[$strTableName."_asearchfor2"]))
$strSearchFor2=trim(@$_SESSION[$strTableName."_asearchfor2"][$f]);
if($strSearchFor!="" || true)
{
if (!$sWhere)
{
if($_SESSION[$strTableName."_asearchtype"]=="and")
$sWhere="1=1";
else
$sWhere="1=0";
}
$strSearchOption=trim($_SESSION[$strTableName."_asearchopt"][$f]);
if($where=StrWhereAdv($f, $strSearchFor, $strSearchOption, $strSearchFor2,$type))
{
if($_SESSION[$strTableName."_asearchnot"][$f])
$where="not (".$where.")";
if($_SESSION[$strTableName."_asearchtype"]=="and")
$sWhere .= " and ".$where;
else
$sWhere .= " or ".$where;
}
}
}
$strWhereClause = whereAdd($strWhereClause,$sWhere);
// $strSQL = AddWhere($strSQL,$sWhere);
}
if(!count($_GET) && !count($_POST))
$strWhereClause = whereAdd($strWhereClause,"1=0");
$strSQL = gSQLWhere($strWhereClause);
// order by
$strSQL.=" ".trim($strOrderBy);
// save SQL for use in "Export" and "Printer-friendly" pages
$_SESSION[$strTableName."_sql"] = $strSQL;
$_SESSION[$strTableName."_where"] = $strWhereClause;
$_SESSION[$strTableName."_order"] = $strOrderBy;
$rowsfound=false;
// select and display records
if(CheckSecurity(@$_SESSION["_".$strTableName."_OwnerID"],"Search"))
{
$strSQLbak = $strSQL;
if(function_exists("BeforeQueryList"))
BeforeQueryList($strSQL,$strWhereClause,$strOrderBy);
// Rebuild SQL if needed
if($strSQL!=$strSQLbak)
{
// changed $strSQL - old style
$numrows=GetRowCount($strSQL);
}
else
{
$strSQL = gSQLWhere($strWhereClause);
$strSQL.=" ".trim($strOrderBy);
$numrows=gSQLRowCount($strWhereClause,0);
}
LogInfo($strSQL);
// Pagination:
if(!$numrows)
{
$smarty->assign("rowsfound",false);
$rowsfound=false;
$message="Nenhum Registro Encontrado";
$smarty->assign("message",$message);
}
else
{
$smarty->assign("rowsfound",true);
$rowsfound=true;
$smarty->assign("records_found",$numrows);
$maxRecords = $numrows;
$maxpages=ceil($maxRecords/$PageSize);
if($mypage > $maxpages)
$mypage = $maxpages;
if($mypage<1)
$mypage=1;
$maxrecs=$PageSize;
$smarty->assign("page",$mypage);
$smarty->assign("maxpages",$maxpages);
// write pagination
$smarty->assign("pagination","");
$strSQL.=" limit ".(($mypage-1)*$PageSize).",".$PageSize;
}
$rs=db_query($strSQL,$conn);
// hide colunm headers if needed
$recordsonpage=$numrows-($mypage-1)*$PageSize;
if($recordsonpage>$PageSize)
$recordsonpage=$PageSize;
if($recordsonpage>=1)
$smarty->assign("column1show",true);
else
$smarty->assign("column1show",false);
// fill $rowinfo array
$rowinfo = array();
$shade=false;
$editlink="";
$copylink="";
while($data=db_fetch_array($rs))
{
if(function_exists("BeforeProcessRowList"))
{
if(!BeforeProcessRowList($data))
continue;
}
break;
}
while($data && $recno<=$PageSize)
{
$row=array();
if(!$shade)
{
$row["shadeclass"]='class="shade"';
$row["shadeclassname"]="shade";
$shade=true;
}
else
{
$row["shadeclass"]="";
$row["shadeclassname"]="";
$shade=false;
}
for($col=1;$data && $recno<=$PageSize && $col<=1;$col++)
{
// key fields
$keyblock="";
$row[$col."keyblock"]=htmlspecialchars($keyblock);
// detail tables
// edit page link
$editlink="";
$row[$col."editlink"]=$editlink;
$copylink="";
$row[$col."copylink"]=$copylink;
$keylink="";
// nome -
$value="";
$value = ProcessLargeText(GetData($data,"nome", ""),"field=nome".$keylink,"",MODE_LIST);
$row[$col."nome_value"]=$value;
// cpf -
$value="";
$value = ProcessLargeText(GetData($data,"cpf", ""),"field=cpf".$keylink,"",MODE_LIST);
$row[$col."cpf_value"]=$value;
// email -
$value="";
$value = ProcessLargeText(GetData($data,"email", ""),"field=email".$keylink,"",MODE_LIST);
$row[$col."email_value"]=$value;
// sexo -
$value="";
$value = ProcessLargeText(GetData($data,"sexo", ""),"field=sexo".$keylink,"",MODE_LIST);
$row[$col."sexo_value"]=$value;
// estadoCivil -
$value="";
$value = ProcessLargeText(GetData($data,"estadoCivil", ""),"field=estadoCivil".$keylink,"",MODE_LIST);
$row[$col."estadoCivil_value"]=$value;
// dataNascimento -
$value="";
$value = ProcessLargeText(GetData($data,"dataNascimento", ""),"field=dataNascimento".$keylink,"",MODE_LIST);
$row[$col."dataNascimento_value"]=$value;
// cidade -
$value="";
$value = ProcessLargeText(GetData($data,"cidade", ""),"field=cidade".$keylink,"",MODE_LIST);
$row[$col."cidade_value"]=$value;
// telefone -
$value="";
$value = ProcessLargeText(GetData($data,"telefone", ""),"field=telefone".$keylink,"",MODE_LIST);
$row[$col."telefone_value"]=$value;
// celular -
$value="";
$value = ProcessLargeText(GetData($data,"celular", ""),"field=celular".$keylink,"",MODE_LIST);
$row[$col."celular_value"]=$value;
// tempoExperiencia -
$value="";
$value = ProcessLargeText(GetData($data,"tempoExperiencia", ""),"field=tempoExperiencia".$keylink,"",MODE_LIST);
$row[$col."tempoExperiencia_value"]=$value;
// categoria -
$value="";
$value = ProcessLargeText(GetData($data,"categoria", ""),"field=categoria".$keylink,"",MODE_LIST);
$row[$col."categoria_value"]=$value;
// turnoEstuda -
$value="";
$value = ProcessLargeText(GetData($data,"turnoEstuda", ""),"field=turnoEstuda".$keylink,"",MODE_LIST);
$row[$col."turnoEstuda_value"]=$value;
// possuiOab -
$value="";
$value = ProcessLargeText(GetData($data,"possuiOab", ""),"field=possuiOab".$keylink,"",MODE_LIST);
$row[$col."possuiOab_value"]=$value;
// oab -
$value="";
$value = ProcessLargeText(GetData($data,"oab", ""),"field=oab".$keylink,"",MODE_LIST);
$row[$col."oab_value"]=$value;
// graduacao -
$value="";
$value = ProcessLargeText(GetData($data,"graduacao", ""),"field=graduacao".$keylink,"",MODE_LIST);
$row[$col."graduacao_value"]=$value;
// interesseTecnico -
$value="";
$value = ProcessLargeText(GetData($data,"interesseTecnico", ""),"field=interesseTecnico".$keylink,"",MODE_LIST);
$row[$col."interesseTecnico_value"]=$value;
// area -
$value="";
$value = ProcessLargeText(GetData($data,"area", ""),"field=area".$keylink,"",MODE_LIST);
$row[$col."area_value"]=$value;
$row[$col."show"]=true;
if(function_exists("BeforeMoveNextList"))
BeforeMoveNextList($data,$row,$col);
while($data=db_fetch_array($rs))
{
if(function_exists("BeforeProcessRowList"))
{
if(!BeforeProcessRowList($data))
continue;
}
break;
}
$recno++;
}
$rowinfo[]=$row;
}
$smarty->assign("rowinfo",$rowinfo);
}
if(CheckSecurity(@$_SESSION["_".$strTableName."_OwnerID"],"Search"))
{
if($_SESSION[$strTableName."_search"]==1)
{
$onload = "onLoad=\"if(document.getElementById('SearchFor')) document.getElementById('ctlSearchFor').focus();\"";
$smarty->assign("onload",$onload);
// fill in search variables
// field selection
if(@$_SESSION[$strTableName."_searchfield"]=="nome")
$smarty->assign("search_nome","selected");
if(@$_SESSION[$strTableName."_searchfield"]=="cpf")
$smarty->assign("search_cpf","selected");
if(@$_SESSION[$strTableName."_searchfield"]=="oab")
$smarty->assign("search_oab","selected");
if(@$_SESSION[$strTableName."_searchfield"]=="tempoExperiencia ")
$smarty->assign("search_tempoExperiencia ","selected");
// search type selection
if(@$_SESSION[$strTableName."_searchoption"]=="Contains")
$smarty->assign("search_contains_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="Equals")
$smarty->assign("search_equals_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="Starts with ...")
$smarty->assign("search_startswith_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="More than ...")
$smarty->assign("search_more_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="Less than ...")
$smarty->assign("search_less_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="Equal or more than ...")
$smarty->assign("search_equalormore_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="Equal or less than ...")
$smarty->assign("search_equalorless_option_selected","selected");
if(@$_SESSION[$strTableName."_searchoption"]=="Empty")
$smarty->assign("search_empty_option_selected","selected");
$smarty->assign("search_searchfor","value=\"".htmlspecialchars(@$_SESSION[$strTableName."_searchfor"])."\"");
}
}
$display_grid=true;
$display_grid=$rowsfound;
$display_records=$display_grid;
if(!$display_grid)
$display_records=false;
$smarty->assign("display_grid",$display_grid);
$smarty->assign("display_records",$display_records);
$linkdata="";
if ($useAJAX) {
$linkdata .= "\r\n";
}
if ($useAJAX) {
$linkdata.="";
}
$smarty->assign("linkdata",$linkdata);
$strSQL=$_SESSION[$strTableName."_sql"];
$smarty->assign("guest",$_SESSION["AccessLevel"] == ACCESS_LEVEL_GUEST);
$templatefile = "jos_chronoforms_1_list.htm";
if(function_exists("BeforeShowList"))
BeforeShowList($smarty,$templatefile);
$smarty->display($templatefile);