/**
* Find function searches Owner table for users having exact values for firstname, lastname, middlename, email address, birthdate.
*
* Set a NULL value to any of the parameters a users wishes not included on the search function.
*
* Search uses AND on query on all of the non-NULL parameters provided. Exact string match is implemented.
*
* Search result can be order by setting orderkey as any of the pre-defined data elements constants defined above,
* set $is_desc to true to use DESC otherwise set to false.
*
* Paging is automatically provided by letting users of this method provide the page number and the max records per page.
* Page result are automaticallly selected give these information, by rule $maxrec should be > 0 and $page should be > 1 and < maxpages
*
* Result of this method is a 2-dim array, having keys "page_info" and "result"
* First element of result having key "page_info" contains all the information regarding the query
* total = number of total records of search
* max_pages = number of pages in search
* count = number of records on current page
* page = current page selected
* Second element of array having key "result" contains result of the search. "result" search value is an array of EBLPSCTC objects
*
*
*/
function search($occupancy_type_code = NULL, $occupancy_type_desc = NULL)
{
if ($occupancy_type_code != NULL) {
$strWhere[OCCUPANCY_TYPE_CODE] = $occupancy_type_code;
}
if ($occupancy_type_desc != NULL) {
$strWhere[OCCUPANCY_TYPE_DESC] = $occupancy_type_desc;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_OCCUPANCY_TYPE_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
function search($zip_code = NULL, $lgu_desc = NULL)
{
if ($zip_code != NULL) {
$strWhere[ZIP_CODE] = $zip_code;
}
if ($lgu_desc != NULL) {
$strWhere[ZIP_DESC] = $zip_desc;
}
// select all columns
$strValues[] = "*";
$strValues1[] = "count(*)";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_ZIP_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$rowcount = ebpls_select_data($this->m_dbLink, EBPLS_ZIP_TABLE, $strValues1, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$fetchcount = @mysql_fetch_row($rowcount);
$this->out = $fetchrecord;
$this->rcount = $fetchcount;
}
function search($sign_id = NULL, $gs_name = NULL)
{
if ($sign_id != NULL) {
$strWhere[SIGN_ID] = $sign_id;
}
if ($gs_name != NULL) {
$strWhere[GS_NAME] = $gs_name;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_SIGNATORIES_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
/**
* Find function searches Owner table for users having exact values for firstname, lastname, middlename, email address, birthdate.
*
* Set a NULL value to any of the parameters a users wishes not included on the search function.
*
* Search uses AND on query on all of the non-NULL parameters provided. Exact string match is implemented.
*
* Search result can be order by setting orderkey as any of the pre-defined data elements constants defined above,
* set $is_desc to true to use DESC otherwise set to false.
*
* Paging is automatically provided by letting users of this method provide the page number and the max records per page.
* Page result are automaticallly selected give these information, by rule $maxrec should be > 0 and $page should be > 1 and < maxpages
*
* Result of this method is a 2-dim array, having keys "page_info" and "result"
* First element of result having key "page_info" contains all the information regarding the query
* total = number of total records of search
* max_pages = number of pages in search
* count = number of records on current page
* page = current page selected
* Second element of array having key "result" contains result of the search. "result" search value is an array of EBLPSCTC objects
*
*
*/
function search($economic_org_id = NULL, $economic_org_code = NULL)
{
if ($economic_org_id != NULL) {
$strWhere[ECONOMIC_ORG_ID] = $economic_org_id;
}
if ($economic_org_code != NULL) {
$strWhere[ECONOMIC_ORG_CODE] = $economic_org_code;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_ECONOMIC_ORGANIZATION_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
function search($rs_id = NULL, $report_file = NULL)
{
if ($rs_id != NULL and $report_file == NULL) {
$strWhere[RS_ID] = $rs_id;
}
if ($rs_id == NULL and $report_file != NULL) {
$strWhere[REPORT_FILE] = $report_file;
}
if ($rs_id != NULL and $report_file != NULL) {
$strWhere[REPORT_FILE] = $report_file;
$strWhere[SIGN_ID] = $rs_id;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_REPORT_SIGN_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
function search($reqid = NULL, $reqdesc = NULL)
{
if ($reqid != NULL) {
$strWhere[REQID] = $reqid;
}
if ($reqdesc != NULL) {
$strWhere[REQDESC] = $reqdesc;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_REQUIREMENTS_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
function search($id = NULL, $ctc_type = NULL)
{
if ($id != NULL) {
$strWhere[ID] = $id;
}
if ($ctc_type != NULL) {
$strWhere[CTC_TYPE] = $ctc_type;
}
// select all columns
$strValues[] = "*";
if (isset($orderkey)) {
//2008.05.13 RJC
$strOrder[$orderkey] = $orderkey;
} else {
// $strOrder = $orderkey;
$strOrder = '';
//2008.05.13 RJC
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_CTC_SETTINGS_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
/**
* Find function searches Owner table for users having exact values for firstname, lastname, middlename, email address, birthdate.
*
* Set a NULL value to any of the parameters a users wishes not included on the search function.
*
* Search uses AND on query on all of the non-NULL parameters provided. Exact string match is implemented.
*
* Search result can be order by setting orderkey as any of the pre-defined data elements constants defined above,
* set $is_desc to true to use DESC otherwise set to false.
*
* Paging is automatically provided by letting users of this method provide the page number and the max records per page.
* Page result are automaticallly selected give these information, by rule $maxrec should be > 0 and $page should be > 1 and < maxpages
*
* Result of this method is a 2-dim array, having keys "page_info" and "result"
* First element of result having key "page_info" contains all the information regarding the query
* total = number of total records of search
* max_pages = number of pages in search
* count = number of records on current page
* page = current page selected
* Second element of array having key "result" contains result of the search. "result" search value is an array of EBLPSCTC objects
*
*
*/
function search($industry_sector_code = NULL, $industry_sector_desc = NULL)
{
if ($industry_sector_code != NULL) {
$strWhere[INDUSTRY_SECTOR_CODE] = $industry_sector_code;
}
if ($industry_sector_desc != NULL) {
$strWhere[INDUSTRY_SECTOR_DESC] = $industry_sector_desc;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_INDUSTRY_SECTOR_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
/**
* Find function searches Owner table for users having exact values for firstname, lastname, middlename, email address, birthdate.
*
* Set a NULL value to any of the parameters a users wishes not included on the search function.
*
* Search uses AND on query on all of the non-NULL parameters provided. Exact string match is implemented.
*
* Search result can be order by setting orderkey as any of the pre-defined data elements constants defined above,
* set $is_desc to true to use DESC otherwise set to false.
*
* Paging is automatically provided by letting users of this method provide the page number and the max records per page.
* Page result are automaticallly selected give these information, by rule $maxrec should be > 0 and $page should be > 1 and < maxpages
*
* Result of this method is a 2-dim array, having keys "page_info" and "result"
* First element of result having key "page_info" contains all the information regarding the query
* total = number of total records of search
* max_pages = number of pages in search
* count = number of records on current page
* page = current page selected
* Second element of array having key "result" contains result of the search. "result" search value is an array of EBLPSCTC objects
*
*
*/
function search($temp_id = NULL, $permit_type = NULL)
{
if ($temp_id != NULL and $permit_type == NULL) {
$strWhere[TEMP_ID] = $temp_id;
}
if ($permit_type != NULL and $temp_id == NULL) {
$strWhere[PERMIT_TYPE] = $permit_type;
}
// select all columns
$strValues[] = "*";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_PERMIT_TEMPLATES_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
function search($eaid = NULL, $announcement = NULL)
{
if ($eaid != NULL) {
$strWhere[EAID] = $eaid;
}
if ($announcement != NULL) {
$strWhere[ANNOUNCEMENT] = $announcement;
}
// select all columns
$strValues[] = "*";
$strValues1[] = "count(*)";
if ($orderkey != NULL) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = $orderkey;
}
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_LOTPIN_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$rowcount = ebpls_select_data($this->m_dbLink, EBPLS_LOTPIN_TABLE, $strValues1, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$fetchcount = @mysql_fetch_row($rowcount);
$this->out = $fetchrecord;
$this->rcount = $fetchcount;
}
/**
* Find function searches Owner table for users having exact values for firstname, lastname, middlename, email address, birthdate.
*
* Set a NULL value to any of the parameters a users wishes not included on the search function.
*
* Search uses AND on query on all of the non-NULL parameters provided. Exact string match is implemented.
*
* Search result can be order by setting orderkey as any of the pre-defined data elements constants defined above,
* set $is_desc to true to use DESC otherwise set to false.
*
* Paging is automatically provided by letting users of this method provide the page number and the max records per page.
* Page result are automaticallly selected give these information, by rule $maxrec should be > 0 and $page should be > 1 and < maxpages
*
* Result of this method is a 2-dim array, having keys "page_info" and "result"
* First element of result having key "page_info" contains all the information regarding the query
* total = number of total records of search
* max_pages = number of pages in search
* count = number of records on current page
* page = current page selected
* Second element of array having key "result" contains result of the search. "result" search value is an array of EBLPSCTC objects
*
*
*/
function search($cit_id = NULL, $cit_desc = NULL)
{
if ($cit_id != NULL) {
$strWhere[CIT_ID] = $cit_id;
}
if ($cit_desc != NULL) {
$strWhere[CIT_DESC] = $cit_desc;
}
// select all columns
$strValues[] = "*";
if (isset($orderkey)) {
$strOrder[$orderkey] = $orderkey;
} else {
$strOrder = '';
}
$strWhere = isset($strWhere) ? $strWhere : '';
if (count($strWhere) <= 0) {
$this->setError(-1, "No search parameters.");
return -1;
}
$result = ebpls_select_data($this->m_dbLink, EBPLS_CITIZENSHIP_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
$fetchrecord = ebpls_fetch_data($this->m_dbLink, $result);
$this->out = $fetchrecord;
}
