function stateOptions()
{
$state = new StateProvince();
$data = $state->get_stateOptions(trim($_GET['v']), 'Y');
if (count($data) < 1) {
return '<input name="txtstateprovince" type="text" size="30" maxlength="100" /> ';
}
$ret .= ' <select class="select" name="txtstateprovince" onchange="javascript: cascadeStateAdmin(this.value, this.form.txt_country.value,\'txtcounty\');" >';
$ret .= '<option value="">' . get_lang('select_text') . '</option>';
foreach ($data as $k => $y) {
if ($k != 'AA') {
$ret .= "<option value='{$k}'>{$y}</option>";
}
}
unset($data);
return $ret .= '</select>';
}
protected function SetupStateProvince()
{
// Lookup Object PK information from Query String (if applicable)
// Set mode to Edit or New depending on what's found
$intStateProvinceId = QApplication::QueryString('intStateProvinceId');
if ($intStateProvinceId) {
$this->objStateProvince = StateProvince::Load($intStateProvinceId);
if (!$this->objStateProvince) {
throw new Exception('Could not find a StateProvince object with PK arguments: ' . $intStateProvinceId);
}
$this->strTitleVerb = QApplication::Translate('Edit');
$this->blnEditMode = true;
} else {
$this->objStateProvince = new StateProvince();
$this->strTitleVerb = QApplication::Translate('Create');
$this->blnEditMode = false;
}
}
public function address()
{
$address = "";
if (isset($this->address) && !empty($this->address)) {
$address .= $this->address . ":";
}
if (isset($this->address2) && !empty($this->address2)) {
$address .= $this->address2 . ":";
}
if (isset($this->city) && !empty($this->city)) {
$city = City::find_by_code($this->country, $this->state_province, $this->county, $this->city);
$address .= $city->name . ":";
}
//county
if (isset($this->county) && !empty($this->county)) {
$county = County::find_by_code($this->country, $this->state_province, $this->county);
$address .= $county->name . ":";
}
//states
if (isset($this->state_province) && !empty($this->state_province)) {
$state_province = StateProvince::find_by_code($this->country, $this->state_province);
$address .= $state_province->name . ":";
}
//post code
if (isset($this->post_code) && !empty($this->post_code)) {
$address .= $this->post_code . ":";
}
//country
if (isset($this->country) && !empty($this->country)) {
$country = Country::find_by_code($this->country);
$address .= $country->name . ":";
} else {
return "";
}
return $address;
}
protected function lstHoldAtLocationStateObject_Create()
{
$this->lstHoldAtLocationStateObject = new QListBox($this);
$this->lstHoldAtLocationStateObject->Name = QApplication::Translate('Hold At Location State Object');
$this->lstHoldAtLocationStateObject->AddItem(QApplication::Translate('- Select One -'), null);
$objHoldAtLocationStateObjectArray = StateProvince::LoadAll();
if ($objHoldAtLocationStateObjectArray) {
foreach ($objHoldAtLocationStateObjectArray as $objHoldAtLocationStateObject) {
$objListItem = new QListItem($objHoldAtLocationStateObject->__toString(), $objHoldAtLocationStateObject->StateProvinceId);
if ($this->objFedexShipment->HoldAtLocationStateObject && $this->objFedexShipment->HoldAtLocationStateObject->StateProvinceId == $objHoldAtLocationStateObject->StateProvinceId) {
$objListItem->Selected = true;
}
$this->lstHoldAtLocationStateObject->AddItem($objListItem);
}
}
}
public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects)
{
if ($objObject->objShipment) {
$objObject->objShipment = Shipment::GetSoapObjectFromObject($objObject->objShipment, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intShipmentId = null;
}
}
if ($objObject->objPackageType) {
$objObject->objPackageType = PackageType::GetSoapObjectFromObject($objObject->objPackageType, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intPackageTypeId = null;
}
}
if ($objObject->objShippingAccount) {
$objObject->objShippingAccount = ShippingAccount::GetSoapObjectFromObject($objObject->objShippingAccount, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intShippingAccountId = null;
}
}
if ($objObject->objFedexServiceType) {
$objObject->objFedexServiceType = FedexServiceType::GetSoapObjectFromObject($objObject->objFedexServiceType, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intFedexServiceTypeId = null;
}
}
if ($objObject->objCurrencyUnit) {
$objObject->objCurrencyUnit = CurrencyUnit::GetSoapObjectFromObject($objObject->objCurrencyUnit, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intCurrencyUnitId = null;
}
}
if ($objObject->objWeightUnit) {
$objObject->objWeightUnit = WeightUnit::GetSoapObjectFromObject($objObject->objWeightUnit, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intWeightUnitId = null;
}
}
if ($objObject->objLengthUnit) {
$objObject->objLengthUnit = LengthUnit::GetSoapObjectFromObject($objObject->objLengthUnit, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intLengthUnitId = null;
}
}
if ($objObject->objHoldAtLocationStateObject) {
$objObject->objHoldAtLocationStateObject = StateProvince::GetSoapObjectFromObject($objObject->objHoldAtLocationStateObject, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intHoldAtLocationState = null;
}
}
return $objObject;
}
public static function GetSoapArrayFromArray($objArray)
{
if (!$objArray) {
return null;
}
$objArrayToReturn = array();
foreach ($objArray as $objObject) {
array_push($objArrayToReturn, StateProvince::GetSoapObjectFromObject($objObject, true));
}
return unserialize(serialize($objArrayToReturn));
}
$ljs = $job_status ? $job_status->status_name : format_lang('none');
$smarty->assign('ljs', $ljs);
//job type
$job_t = empty($cv_details->look_job_type) ? 0 : $cv_details->look_job_type;
$job_type_arr = JobType::find_by_id($job_t);
//print_r( $job_type_arr);
$job_types = $job_type_arr ? $job_type_arr->type_name : format_lang('none');
$smarty->assign('job_type', $job_types);
//where do you wont to work
//country
$country_arry = Country::find_by_code($cv_details->country);
$country_var_name = $country_arry->var_name;
$country_name = $country_arry->name;
$smarty->assign('country', $country_name);
//states
$state = StateProvince::find_by_code($cv_details->country, $cv_details->state_province);
$state_name = empty($state) ? $cv_details->state_province : $state->name;
$state_var_name = $state ? $state->var_name : $cv_details->state_province;
$smarty->assign('state', $state_name);
$smarty->assign('state_url', $country_var_name . "/" . $state_var_name . "/");
//county
$county = County::find_by_code($cv_details->country, $cv_details->state_province, $cv_details->county);
$county_name = empty($county) ? $cv_details->county : $county->name;
$county_var_name = $county ? $county->var_name : $cv_details->county;
$smarty->assign('county', $county_name);
$smarty->assign('county_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/");
$city = City::find_by_code($cv_details->country, $cv_details->state_province, $cv_details->county, $cv_details->city);
$city_name = empty($city) ? $cv_details->city : $city->name;
$city_var_name = empty($city) ? $cv_details->city : $city->var_name;
$smarty->assign('city', $city_name);
$smarty->assign('city_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/" . $city_var_name . "/");
protected function lstCountry_Select()
{
// Save the currently selected StateProvince
$intStateProvinceId = $this->lstStateProvince->SelectedValue;
// Clear out the items from lstAddress
$this->lstStateProvince->RemoveAllItems();
if ($this->lstCountry->SelectedValue) {
// Load the selected country
$objCountry = Country::Load($this->lstCountry->SelectedValue);
// Get all available state/provinces for that company
$objStateProvinceArray = $objCountry->GetStateProvinceArray();
} else {
// Or load all addresses for all companies
$objStateProvinceArray = StateProvince::LoadAll();
}
$this->lstStateProvince->AddItem('- Select One -', null);
if ($objStateProvinceArray) {
foreach ($objStateProvinceArray as $objStateProvince) {
// Create a new ListItem Object
$objListItem = new QListItem($objStateProvince->__toString(), $objStateProvince->StateProvinceId);
// If this State/Province is the one previously selected, make it selected again
if ($intStateProvinceId == $objStateProvince->StateProvinceId) {
$objListItem->Selected = true;
}
// Add the ListItem object
$this->lstStateProvince->AddItem($objListItem);
// Enable the input
$this->lstStateProvince->Enabled = true;
}
} else {
$this->lstStateProvince->Enabled = false;
}
}
protected function lstStateProvince_Create()
{
$this->lstStateProvince = new QListBox($this);
$this->lstStateProvince->Name = QApplication::Translate('State Province');
$this->lstStateProvince->AddItem(QApplication::Translate('- Select One -'), null);
$objStateProvinceArray = StateProvince::LoadAll();
if ($objStateProvinceArray) {
foreach ($objStateProvinceArray as $objStateProvince) {
$objListItem = new QListItem($objStateProvince->__toString(), $objStateProvince->StateProvinceId);
if ($this->objAddress->StateProvince && $this->objAddress->StateProvince->StateProvinceId == $objStateProvince->StateProvinceId) {
$objListItem->Selected = true;
}
$this->lstStateProvince->AddItem($objListItem);
}
}
}
/**
* Counts all associated StateProvinces
* @return int
*/
public function CountStateProvinces()
{
if (is_null($this->intCountryId)) {
return 0;
}
return StateProvince::CountByCountryId($this->intCountryId);
}
/**
* Deletes all associated StateProvinces
* @return void
*/
public function DeleteAllStateProvinces()
{
if (is_null($this->intCountryId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateStateProvince on this unsaved Country.');
}
// Get the Database Object for this Class
$objDatabase = Country::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (StateProvince::LoadArrayByCountryId($this->intCountryId) as $objStateProvince) {
$objStateProvince->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`state_province`
WHERE
`country_id` = ' . $objDatabase->SqlVariable($this->intCountryId) . '
');
}
public static function recommendedJob($user_id = 0, $cvjob_title = null, $cvjob_title2 = null, $cvjob_city = null, $cvjob_county = null, $cvjob_state = null, $cvjob_country = null)
{
global $database, $db;
$select = " SELECT job_title, city, county, state_province, country, fk_employer_id,var_name, created_at ";
$select .= ", match( job.job_title, job.job_description ) against ('" . $cvjob_title . "' '+" . $cvjob_title2 . "' IN BOOLEAN MODE) as relevance ";
$from = " FROM " . self::$table_name . " AS job ";
$where = " WHERE job.id NOT IN ( SELECT job_h.fk_job_id from " . TBL_HISTORY . " as job_h WHERE job_h.fk_employee_id={$user_id}) ";
$where .= " AND job.is_active='Y' AND job.job_status='approved' AND job.id > 0 ";
//$where .= " AND var_name <> '".$old."' ";
$where .= " AND match( job.job_title, job.job_description ) against ('" . $cvjob_title . "' '+" . $cvjob_title2 . "' IN BOOLEAN MODE)";
$where .= " AND DATE_ADD( job.created_at, INTERVAL " . JOBLASTFOR . " DAY ) > NOW() ";
//$where .= " AND city='{$cvjob_city}' ";
$where .= " AND county='{$cvjob_county}' ";
$where .= " AND state_province='{$cvjob_state}'";
$where .= " AND country='{$cvjob_country}'";
$order = " ORDER BY relevance, created_at DESC ";
$limit = " LIMIT 10 ";
//SELECT job.job_title, job.city, job.county, job.state_province, job.country
//FROM jobberland_job AS job
//WHERE job.id NOT IN (SELECT job_h.fk_job_id from jobberland_job_history as job_h WHERE fk_employer_id = 1)
$sql = $select . $from . $where . $order . $limit;
//echo $sql;
$result = $database->query($sql);
$num_rows = $database->num_rows($result);
if ($num_rows > 0) {
$i = 1;
$temp = array();
while ($row = $database->fetch_object($result)) {
$temp[$i]['job_title'] = $row->job_title;
$temp[$i]['var_name'] = $row->var_name;
$temp[$i]['created_at'] = strftime(DATE_FORMAT, strtotime($row->created_at));
//country
$country_arry = Country::find_by_code($row->country);
$country_name = $country_arry->name;
//states
$state = StateProvince::find_by_code($row->country, $row->state_province);
$state_name = empty($state) ? $row->state_province : $state->name;
//county
$county = County::find_by_code($row->country, $row->state_province, $row->county);
$county_name = empty($county) ? $row->county : $county->name;
//city
$city = City::find_by_code($row->country, $row->state_province, $row->county, $row->city);
$city_name = empty($city) ? $row->city : $city->name;
$temp[$i]['location'] = $city_name . ", " . $county_name . ", " . $state_name . ", " . $country_name;
$employer = Employer::find_by_id($row->fk_employer_id);
$company_name = $employer->company_name;
$temp[$i]['company_name'] = $company_name;
//$temp[$i]['job_title'] = $row->job_title;
//$temp[$i]['job_title'] = $row->job_title;
$i++;
}
return $temp;
}
return false;
}
/**
* Internally called method to assist with early binding of objects
* on load methods. Can only early-bind references that this class owns in the database.
* @param string $strParentAlias the alias of the parent (if any)
* @param string $strAlias the alias of this object
* @param array $objExpansionMap map of referenced columns to be immediately expanded via early-binding
* @param QueryExpansion an already instantiated QueryExpansion object (used as a utility object to assist with object expansion)
*/
public static function ExpandQuery($strParentAlias, $strAlias, $objExpansionMap, QQueryExpansion $objQueryExpansion)
{
if ($strAlias) {
$objQueryExpansion->AddFromItem(sprintf('LEFT JOIN `address` AS `%s__%s` ON `%s`.`%s` = `%s__%s`.`address_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`address_id` AS `%s__%s__address_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`company_id` AS `%s__%s__company_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`short_description` AS `%s__%s__short_description`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`country_id` AS `%s__%s__country_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`address_1` AS `%s__%s__address_1`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`address_2` AS `%s__%s__address_2`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`city` AS `%s__%s__city`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`state_province_id` AS `%s__%s__state_province_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`postal_code` AS `%s__%s__postal_code`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`created_by` AS `%s__%s__created_by`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`creation_date` AS `%s__%s__creation_date`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`modified_by` AS `%s__%s__modified_by`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`modified_date` AS `%s__%s__modified_date`', $strParentAlias, $strAlias, $strParentAlias, $strAlias));
$strParentAlias = $strParentAlias . '__' . $strAlias;
}
if (is_array($objExpansionMap)) {
foreach ($objExpansionMap as $strKey => $objValue) {
switch ($strKey) {
case 'company_id':
try {
Company::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion);
break;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'country_id':
try {
Country::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion);
break;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'state_province_id':
try {
StateProvince::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion);
break;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'created_by':
try {
UserAccount::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion);
break;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'modified_by':
try {
UserAccount::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion);
break;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
default:
throw new QCallerException(sprintf('Unknown Object to Expand in %s: %s', $strParentAlias, $strKey));
}
}
}
}
$smarty->assign('apply_for', $jobs->job_title . " " . strtolower(format_lang('at')) . " " . $employer->company_name . " " . strtolower(format_lang('in')) . " " . $city_name . ", " . $country_name);
unset($employer, $city, $country_arry);
//Congratulations! You've applied for:
//IT Manager at IT Lab in London EC1A 9PT
if ($jobs) {
$job_s = array();
$i = 1;
$job_suggestions = Job::apply_suggestion($jobs->job_title, $var_name);
foreach ($job_suggestions as $job_suggestion) {
$employer = Employer::find_by_id($job_suggestion->fk_employer_id);
//locations
//country
$country_arry = Country::find_by_code($job_suggestion->country);
$country_name = $country_arry->name;
//states
$state = StateProvince::find_by_code($job_suggestion->country, $job_suggestion->state_province);
$state_name = empty($state) ? $job_suggestion->state_province : $state->name;
//county
$county = County::find_by_code($job_suggestion->country, $job_suggestion->state_province, $job_suggestion->county);
$county_name = empty($county) ? $job_suggestion->county : $county->name;
//city
$city = City::find_by_code($job_suggestion->country, $job_suggestion->state_province, $job_suggestion->county, $job_suggestion->city);
$city_name = empty($city) ? $job_suggestion->city : $city->name;
//end
$job_s[$i]['id'] = $job_suggestion->id;
$job_s[$i]['var_name'] = $job_suggestion->var_name;
$job_s[$i]['job_title'] = $job_suggestion->job_title;
$job_s[$i]['company_name'] = $employer->company_name;
$job_s[$i]['created_at'] = strftime(DATE_FORMAT, strtotime($job_suggestion->created_at));
$job_s[$i]['location'] = $city_name . ", " . $county_name . ", " . $state_name . ", " . $country_name;
$i++;
public function dtgStateProvince_Bind()
{
// Get Total Count b/c of Pagination
$this->dtgStateProvince->TotalItemCount = StateProvince::CountAll();
$objClauses = array();
if ($objClause = $this->dtgStateProvince->OrderByClause) {
array_push($objClauses, $objClause);
}
if ($objClause = $this->dtgStateProvince->LimitClause) {
array_push($objClauses, $objClause);
}
$this->dtgStateProvince->DataSource = StateProvince::LoadAll($objClauses);
}
$state = new StateProvince();
$state->countrycode = $countrycode;
$state->code = trim($data[0]);
$state->var_name = $state->mod_write_check(trim($data[1]));
$state->name = trim($data[1]);
$save = $state->save();
}
fclose($file);
$message = "<div class='success'>State codes loaded from " . $filename . " </div>";
$session->message($message);
redirect_to($_SERVER['PHP_SELF']);
}
//delete all the states from list
if (isset($_POST['deletestates'])) {
global $db, $database;
$state = new StateProvince();
$state->delete_by_country($countrycode);
/* We should remove the state definition from counties, cities and zips tables also for this country */
$db->query("update " . TBL_COUNTIES . " set statecode='' where countrycode='{$countrycode}' ");
$db->query("update " . TBL_CITY . " set statecode='' where countrycode='{$countrycode}' ");
$message = "<div class='success'>State codes for #COUNTRY# are deleted </div>";
$message = str_replace('#COUNTRY#', $countrycode, $message);
/* Analyze the table to adjust index values */
//$db->optimize_table( TBL_COUNTRY );
$db->optimize_table(TBL_STATES);
$db->optimize_table(TBL_COUNTIES);
$db->optimize_table(TBL_CITY);
$session->message($message);
redirect_to($_SERVER['PHP_SELF']);
}
//get the states files
$smarty->assign('jobtype', $type2);
$smarty->assign('var_name', $jobs->var_name);
$smarty->assign('job_ref', $jobs->job_ref);
$smarty->assign('job_title', $jobs->job_title);
$smarty->assign('job_description', $jobs->job_description);
$smarty->assign('job_postion', $jobs->job_postion);
//locations
//country
$country_arry = Country::find_by_code($jobs->country);
//$country_a($country_arry) ? $country_arry->code : $country_a;
$country_var_name = $country_arry->var_name;
$country_name = $country_arry->name;
$smarty->assign('country', $country_name);
$smarty->assign('country_url', $country_var_name);
//states
$state = StateProvince::find_by_code($jobs->country, $jobs->state_province);
$state_name = empty($state) ? $jobs->state_province : $state->name;
$state_var_name = $state ? $state->var_name : $jobs->state_province;
$smarty->assign('state', $state_name);
$smarty->assign('state_url', $country_var_name . "/" . $state_var_name . "/");
//county
$county = County::find_by_code($jobs->country, $jobs->state_province, $jobs->county);
$county_name = empty($county) ? $jobs->county : $county->name;
$county_var_name = $county ? $county->var_name : $jobs->county;
$smarty->assign('county', $county_name);
$smarty->assign('county_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/");
$city = City::find_by_code($jobs->country, $jobs->state_province, $jobs->county, $jobs->city);
$city_name = empty($city) ? $jobs->city : $city->name;
$city_var_name = empty($city) ? $jobs->city : $city->var_name;
$smarty->assign('city', $city_name);
$smarty->assign('city_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/" . $city_var_name . "/");
public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects)
{
if ($objObject->objCompany) {
$objObject->objCompany = Company::GetSoapObjectFromObject($objObject->objCompany, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intCompanyId = null;
}
}
if ($objObject->objCountry) {
$objObject->objCountry = Country::GetSoapObjectFromObject($objObject->objCountry, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intCountryId = null;
}
}
if ($objObject->objStateProvince) {
$objObject->objStateProvince = StateProvince::GetSoapObjectFromObject($objObject->objStateProvince, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intStateProvinceId = null;
}
}
if ($objObject->objCreatedByObject) {
$objObject->objCreatedByObject = UserAccount::GetSoapObjectFromObject($objObject->objCreatedByObject, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intCreatedBy = null;
}
}
if ($objObject->dttCreationDate) {
$objObject->dttCreationDate = $objObject->dttCreationDate->__toString(QDateTime::FormatSoap);
}
if ($objObject->objModifiedByObject) {
$objObject->objModifiedByObject = UserAccount::GetSoapObjectFromObject($objObject->objModifiedByObject, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intModifiedBy = null;
}
}
return $objObject;
}
/**
* Static Helper Method to Create using PK arguments
* You must pass in the PK arguments on an object to load, or leave it blank to create a new one.
* If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo
* static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to
* edit, or if we are also allowed to create a new one, etc.
*
* @param mixed $objParentObject QForm or QPanel which will be using this StateProvinceMetaControl
* @param integer $intStateProvinceId primary key value
* @param QMetaControlCreateType $intCreateType rules governing StateProvince object creation - defaults to CreateOrEdit
* @return StateProvinceMetaControl
*/
public static function Create($objParentObject, $intStateProvinceId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intStateProvinceId)) {
$objStateProvince = StateProvince::Load($intStateProvinceId);
// StateProvince was found -- return it!
if ($objStateProvince) {
return new StateProvinceMetaControl($objParentObject, $objStateProvince);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a StateProvince object with PK arguments: ' . $intStateProvinceId);
}
}
// If EditOnly is specified, throw an exception
} else {
if ($intCreateType == QMetaControlCreateType::EditOnly) {
throw new QCallerException('No PK arguments specified');
}
}
// If we are here, then we need to create a new record
return new StateProvinceMetaControl($objParentObject, new StateProvince());
}
/**
* Main utility method to aid with data binding. It is used by the default BindAllRows() databinder but
* could and should be used by any custom databind methods that would be used for instances of this
* MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause.
*
* If a paginator is set on this DataBinder, it will use it. If not, then no pagination will be used.
* It will also perform any sorting (if applicable).
*
* @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself
* @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query
* @return void
*/
public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null)
{
// Setup input parameters to default values if none passed in
if (!$objCondition) {
$objCondition = QQ::All();
}
$objClauses = $objOptionalClauses ? $objOptionalClauses : array();
// We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if ($this->Paginator) {
$this->TotalItemCount = StateProvince::QueryCount($objCondition, $objClauses);
}
// If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add
// the OrderByClause to the $objClauses array
if ($objClause = $this->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be a Query result from StateProvince, given the clauses above
$this->DataSource = StateProvince::QueryArray($objCondition, $objClauses);
}
protected function lstHoldAtLocationState_Create()
{
$this->lstHoldAtLocationState = new QListBox($this->pnlFedExShipment);
$this->lstHoldAtLocationState->Name = QApplication::Translate('Hold at Location State');
$this->lstHoldAtLocationState->AddItem(QApplication::Translate('- Select One -'), null);
$objStateProvinceArray = StateProvince::LoadAll();
if ($objStateProvinceArray) {
foreach ($objStateProvinceArray as $objStateProvince) {
$objListItem = new QListItem($objStateProvince->__toString(), $objStateProvince->StateProvinceId);
if ($this->blnEditMode && $this->objFedexShipment && $this->objFedexShipment->HoldAtLocationState && $this->objFedexShipment->HoldAtLocationState == $objStateProvince->StateProvinceId) {
$objListItem->Selected = true;
}
$this->lstHoldAtLocationState->AddItem($objListItem);
}
}
$this->lstHoldAtLocationState->TabIndex = 30;
}
}
$default_county = $_SESSION['loc']['country'];
$countrycode = $default_county = !empty($default_county) ? $default_county : "GB";
$_SESSION['loc']['country'] = $countrycode = $default_county = !empty($default_county) ? $default_county : "GB";
$country = Country::find_all_order_by_name();
if (is_array($country) && !empty($country)) {
$country_t = array();
$country_t['AA'] = 'All Countries';
foreach ($country as $co) {
if ($val['code'] != 'AA') {
$country_t[$co->code] = $co->name;
}
}
$smarty->assign('country', $country_t);
}
$state = new StateProvince();
$county = new County();
$city = new City();
$lang['states'] = $state->get_stateOptions($countrycode, 'N');
if (count($lang['states']) == 1) {
foreach ($lang['states'] as $key => $val) {
$_SESSION['loc']['stateprovince'] = $key;
}
}
//status
$_SESSION['loc']['stateprovince'] = $_SESSION['loc']['stateprovince'] != '' ? $_SESSION['loc']['stateprovince'] : "";
if ($_SESSION['loc']['stateprovince'] != '') {
$lang['counties'] = $county->get_countyOptions($countrycode, $_SESSION['loc']['stateprovince'], 'N');
if (count($lang['counties']) == 1) {
foreach ($lang['counties'] as $key => $val) {
$_SESSION['loc']['countycode'] = $key;
/**
* Refresh this MetaControl with Data from the local Address object.
* @param boolean $blnReload reload Address from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objAddress->Reload();
}
if ($this->lblAddressId) {
if ($this->blnEditMode) {
$this->lblAddressId->Text = $this->objAddress->AddressId;
}
}
if ($this->lstCompany) {
$this->lstCompany->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstCompany->AddItem(QApplication::Translate('- Select One -'), null);
}
$objCompanyArray = Company::LoadAll();
if ($objCompanyArray) {
foreach ($objCompanyArray as $objCompany) {
$objListItem = new QListItem($objCompany->__toString(), $objCompany->CompanyId);
if ($this->objAddress->Company && $this->objAddress->Company->CompanyId == $objCompany->CompanyId) {
$objListItem->Selected = true;
}
$this->lstCompany->AddItem($objListItem);
}
}
}
if ($this->lblCompanyId) {
$this->lblCompanyId->Text = $this->objAddress->Company ? $this->objAddress->Company->__toString() : null;
}
if ($this->txtShortDescription) {
$this->txtShortDescription->Text = $this->objAddress->ShortDescription;
}
if ($this->lblShortDescription) {
$this->lblShortDescription->Text = $this->objAddress->ShortDescription;
}
if ($this->lstCountry) {
$this->lstCountry->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstCountry->AddItem(QApplication::Translate('- Select One -'), null);
}
$objCountryArray = Country::LoadAll();
if ($objCountryArray) {
foreach ($objCountryArray as $objCountry) {
$objListItem = new QListItem($objCountry->__toString(), $objCountry->CountryId);
if ($this->objAddress->Country && $this->objAddress->Country->CountryId == $objCountry->CountryId) {
$objListItem->Selected = true;
}
$this->lstCountry->AddItem($objListItem);
}
}
}
if ($this->lblCountryId) {
$this->lblCountryId->Text = $this->objAddress->Country ? $this->objAddress->Country->__toString() : null;
}
if ($this->txtAddress1) {
$this->txtAddress1->Text = $this->objAddress->Address1;
}
if ($this->lblAddress1) {
$this->lblAddress1->Text = $this->objAddress->Address1;
}
if ($this->txtAddress2) {
$this->txtAddress2->Text = $this->objAddress->Address2;
}
if ($this->lblAddress2) {
$this->lblAddress2->Text = $this->objAddress->Address2;
}
if ($this->txtCity) {
$this->txtCity->Text = $this->objAddress->City;
}
if ($this->lblCity) {
$this->lblCity->Text = $this->objAddress->City;
}
if ($this->lstStateProvince) {
$this->lstStateProvince->RemoveAllItems();
$this->lstStateProvince->AddItem(QApplication::Translate('- Select One -'), null);
$objStateProvinceArray = StateProvince::LoadAll();
if ($objStateProvinceArray) {
foreach ($objStateProvinceArray as $objStateProvince) {
$objListItem = new QListItem($objStateProvince->__toString(), $objStateProvince->StateProvinceId);
if ($this->objAddress->StateProvince && $this->objAddress->StateProvince->StateProvinceId == $objStateProvince->StateProvinceId) {
$objListItem->Selected = true;
}
$this->lstStateProvince->AddItem($objListItem);
}
}
}
if ($this->lblStateProvinceId) {
$this->lblStateProvinceId->Text = $this->objAddress->StateProvince ? $this->objAddress->StateProvince->__toString() : null;
}
if ($this->txtPostalCode) {
$this->txtPostalCode->Text = $this->objAddress->PostalCode;
}
if ($this->lblPostalCode) {
$this->lblPostalCode->Text = $this->objAddress->PostalCode;
}
if ($this->lstCreatedByObject) {
$this->lstCreatedByObject->RemoveAllItems();
$this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objCreatedByObjectArray = UserAccount::LoadAll();
if ($objCreatedByObjectArray) {
foreach ($objCreatedByObjectArray as $objCreatedByObject) {
$objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId);
if ($this->objAddress->CreatedByObject && $this->objAddress->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstCreatedByObject->AddItem($objListItem);
}
}
}
if ($this->lblCreatedBy) {
$this->lblCreatedBy->Text = $this->objAddress->CreatedByObject ? $this->objAddress->CreatedByObject->__toString() : null;
}
if ($this->calCreationDate) {
$this->calCreationDate->DateTime = $this->objAddress->CreationDate;
}
if ($this->lblCreationDate) {
$this->lblCreationDate->Text = sprintf($this->objAddress->CreationDate) ? $this->objAddress->__toString($this->strCreationDateDateTimeFormat) : null;
}
if ($this->lstModifiedByObject) {
$this->lstModifiedByObject->RemoveAllItems();
$this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objModifiedByObjectArray = UserAccount::LoadAll();
if ($objModifiedByObjectArray) {
foreach ($objModifiedByObjectArray as $objModifiedByObject) {
$objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId);
if ($this->objAddress->ModifiedByObject && $this->objAddress->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstModifiedByObject->AddItem($objListItem);
}
}
}
if ($this->lblModifiedBy) {
$this->lblModifiedBy->Text = $this->objAddress->ModifiedByObject ? $this->objAddress->ModifiedByObject->__toString() : null;
}
if ($this->lblModifiedDate) {
if ($this->blnEditMode) {
$this->lblModifiedDate->Text = $this->objAddress->ModifiedDate;
}
}
if ($this->lstAddressCustomFieldHelper) {
$this->lstAddressCustomFieldHelper->RemoveAllItems();
$this->lstAddressCustomFieldHelper->AddItem(QApplication::Translate('- Select One -'), null);
$objAddressCustomFieldHelperArray = AddressCustomFieldHelper::LoadAll();
if ($objAddressCustomFieldHelperArray) {
foreach ($objAddressCustomFieldHelperArray as $objAddressCustomFieldHelper) {
$objListItem = new QListItem($objAddressCustomFieldHelper->__toString(), $objAddressCustomFieldHelper->AddressId);
if ($objAddressCustomFieldHelper->AddressId == $this->objAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstAddressCustomFieldHelper->AddItem($objListItem);
}
}
// Because AddressCustomFieldHelper's AddressCustomFieldHelper is not null, if a value is already selected, it cannot be changed.
if ($this->lstAddressCustomFieldHelper->SelectedValue) {
$this->lstAddressCustomFieldHelper->Enabled = false;
} else {
$this->lstAddressCustomFieldHelper->Enabled = true;
}
}
if ($this->lblAddressCustomFieldHelper) {
$this->lblAddressCustomFieldHelper->Text = $this->objAddress->AddressCustomFieldHelper ? $this->objAddress->AddressCustomFieldHelper->__toString() : null;
}
}
protected function lstCountry_Select($strFormId, $strControlId, $strParameter)
{
// Save the currently selected StateProvince
$intStateProvinceId = $this->lstStateProvince->SelectedValue;
// Clear out the items from lstAddress
$this->lstStateProvince->RemoveAllItems();
if ($this->lstCountry->SelectedValue) {
// Load the selected country
$objCountry = Country::Load($this->lstCountry->SelectedValue);
// Get all available state/provinces for that company
$objStateProvinceArray = $objCountry->GetStateProvinceArray();
} else {
// Or load all addresses for all companies
$objStateProvinceArray = StateProvince::LoadAll();
}
$this->lstStateProvince->AddItem('- Select One -', null);
if ($objStateProvinceArray) {
foreach ($objStateProvinceArray as $objStateProvince) {
$objListItem = new QListItem($objStateProvince->__toString(), $objStateProvince->StateProvinceId);
if ($intStateProvinceId == $objStateProvince->StateProvinceId) {
$objListItem->Selected = true;
}
$this->lstStateProvince->AddItem($objListItem);
$this->lstStateProvince->Enabled = true;
}
} else {
$this->lstStateProvince->Enabled = false;
}
}
$i++;
}
$smarty->assign('activeLink', $activeLink);
}
///jobs
$job_by_locations = Job::list_job_by_location($country_code);
if ($job_by_locations2) {
$location = array();
$i = 1;
foreach ($job_by_locations as $job_by_location) {
//city
$city_code = City::find_by_code($country_a, null, null, $job_by_location->city);
$city_var_name = $city_code ? $city_code->var_name : $job_by_location->city;
//states
$state_code = $job_by_location->state_province;
$state_ = StateProvince::find_by_code($country_a, $state_code);
$state_var_name = $state_ ? $state_->var_name : $job_by_location->state_province;
//county
$county_code = $job_by_location->county;
$county_ = County::find_by_code($country_a, $state_code, $county_code);
$county_var_name = $county_ ? $county_->var_name : $job_by_location->county;
if ($city_code) {
/**check length of text */
$location_name = strlen($city_code->name) > 60 ? substr($city_code->name, 0, 30) . " ... " : $city_code->name;
} else {
/**check length of text */
$location_name = strlen($city_var_name) > 60 ? substr($city_var_name, 0, 30) . " ... " : $city_var_name;
}
$total_jobs = Job::get_total_job_by_location($country_a, null, null, $job_by_location->city);
$location[$i]['total'] = $total_jobs;
$location[$i]['name'] = $location_name;
