function Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $index;
//Compatibility
//End Page_BeforeInitialize
//YahooAutocomplete1 Initialization @169-663F79D3
if ('sex_occupation_patient1s_keywordYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @169-D7716879
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "surname", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete1 DataSource
//YahooAutocomplete1 DataFields @169-7B8C1313
$Service->AddDataSourceField('surname');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @169-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @169-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//YahooAutocomplete2 Initialization @170-F89F3274
if ('sex_occupation_patient1s_keywordYahooAutocomplete2' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete2 Initialization
//YahooAutocomplete2 DataSource @170-A29C63C1
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "other_names", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete2 DataSource
//YahooAutocomplete2 DataFields @170-6D762D08
$Service->AddDataSourceField('other_names');
//End YahooAutocomplete2 DataFields
//YahooAutocomplete2 Execution @170-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete2 Execution
//YahooAutocomplete2 Tail @170-27890EF8
exit;
}
//End YahooAutocomplete2 Tail
//YahooAutocomplete3 Initialization @171-8D00F4E9
if ('sex_occupation_patient1s_keywordYahooAutocomplete3' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete3 Initialization
//YahooAutocomplete3 DataSource @171-6F74E980
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "hospital_no", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete3 DataSource
//YahooAutocomplete3 DataFields @171-BAEED557
$Service->AddDataSourceField('hospital_no');
//End YahooAutocomplete3 DataFields
//YahooAutocomplete3 Execution @171-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete3 Execution
//YahooAutocomplete3 Tail @171-27890EF8
exit;
}
//End YahooAutocomplete3 Tail
//YahooAutocomplete1 Initialization @172-3ED9C29E
if ('title_status_users_result1s_patient_idYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @172-EB18E68D
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "patient_id", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete1 DataSource
//YahooAutocomplete1 DataFields @172-2A140E80
$Service->AddDataSourceField('patient_id');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @172-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @172-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
function Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $index;
//Compatibility
//End Page_BeforeInitialize
//YahooAutocomplete1 Initialization @65-2A144B48
if ('sex_department_patient_re1s_surnameYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @65-D7716879
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "surname", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete1 DataSource
//YahooAutocomplete1 DataFields @65-7B8C1313
$Service->AddDataSourceField('surname');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @65-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @65-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//YahooAutocomplete2 Initialization @66-4B9AF09F
if ('sex_department_patient_re1s_other_namesYahooAutocomplete2' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete2 Initialization
//YahooAutocomplete2 DataSource @66-A29C63C1
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "other_names", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete2 DataSource
//YahooAutocomplete2 DataFields @66-6D762D08
$Service->AddDataSourceField('other_names');
//End YahooAutocomplete2 DataFields
//YahooAutocomplete2 Execution @66-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete2 Execution
//YahooAutocomplete2 Tail @66-27890EF8
exit;
}
//End YahooAutocomplete2 Tail
//YahooAutocomplete3 Initialization @67-604AB22E
if ('sex_department_patient_re1s_hospital_noYahooAutocomplete3' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete3 Initialization
//YahooAutocomplete3 DataSource @67-6F74E980
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "hospital_no", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete3 DataSource
//YahooAutocomplete3 DataFields @67-BAEED557
$Service->AddDataSourceField('hospital_no');
//End YahooAutocomplete3 DataFields
//YahooAutocomplete3 Execution @67-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete3 Execution
//YahooAutocomplete3 Tail @67-27890EF8
exit;
}
//End YahooAutocomplete3 Tail
//YahooAutocomplete4 Initialization @68-EEC841F4
if ('sex_department_patient_re1s_patient_idYahooAutocomplete4' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete4 Initialization
//YahooAutocomplete4 DataSource @68-54A4C37F
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM result {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "patient_id", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete4 DataSource
//YahooAutocomplete4 DataFields @68-2A140E80
$Service->AddDataSourceField('patient_id');
//End YahooAutocomplete4 DataFields
//YahooAutocomplete4 Execution @68-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete4 Execution
//YahooAutocomplete4 Tail @68-27890EF8
exit;
}
//End YahooAutocomplete4 Tail
//YahooAutocomplete5 Initialization @69-45F7FEB1
if ('sex_department_patient_re1s_result_idYahooAutocomplete5' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete5 Initialization
//YahooAutocomplete5 DataSource @69-96886DBA
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM result {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "result_id", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete5 DataSource
//YahooAutocomplete5 DataFields @69-F2E2F41D
$Service->AddDataSourceField('result_id');
//End YahooAutocomplete5 DataFields
//YahooAutocomplete5 Execution @69-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete5 Execution
//YahooAutocomplete5 Tail @69-27890EF8
exit;
}
//End YahooAutocomplete5 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
function Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $index;
//Compatibility
//End Page_BeforeInitialize
//YahooAutocomplete1 Initialization @74-299480B3
if ('title_user_group_departme1s_keywordYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @74-23A485AF
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM users {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "first_name", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete1 DataSource
//YahooAutocomplete1 DataFields @74-A2FDBB32
$Service->AddDataSourceField('first_name');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @74-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @74-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//YahooAutocomplete2 Initialization @75-B734CB14
if ('title_user_group_departme1s_keywordYahooAutocomplete2' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete2 Initialization
//YahooAutocomplete2 DataSource @75-E4ED46DB
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM users {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "last_name", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete2 DataSource
//YahooAutocomplete2 DataFields @75-0BC99D58
$Service->AddDataSourceField('last_name');
//End YahooAutocomplete2 DataFields
//YahooAutocomplete2 Execution @75-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete2 Execution
//YahooAutocomplete2 Tail @75-27890EF8
exit;
}
//End YahooAutocomplete2 Tail
//YahooAutocomplete3 Initialization @76-C2AB0D89
if ('title_user_group_departme1s_keywordYahooAutocomplete3' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete3 Initialization
//YahooAutocomplete3 DataSource @76-1B31722E
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM department {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "department", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete3 DataSource
//YahooAutocomplete3 DataFields @76-6EE6BEC7
$Service->AddDataSourceField('department');
//End YahooAutocomplete3 DataFields
//YahooAutocomplete3 Execution @76-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete3 Execution
//YahooAutocomplete3 Tail @76-27890EF8
exit;
}
//End YahooAutocomplete3 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}