public function save_user_do($inputs) { $restricted_fields = array('page', 'wpl_format', 'wpl_function', 'function', 'id'); /** edit user **/ $query = ""; $id = $inputs['id']; $columns = wpl_db::columns('wpl_users'); $crm_access = array(); /** set restriction to none **/ if (!isset($inputs['maccess_lrestrict'])) { $inputs['maccess_listings'] = ''; } if (!isset($inputs['maccess_ptrestrict'])) { $inputs['maccess_property_types'] = ''; } foreach ($inputs as $field => $value) { if (substr($field, 0, 11) == 'maccess_crm') { if ($value == 1) { $crm_access[] = substr($field, 11); } continue; } if (in_array($field, $restricted_fields) or !in_array($field, $columns)) { continue; } $query .= "`" . $field . "`='" . $value . "', "; } /** update CRM access list if available **/ if (count($crm_access) > 0) { $query .= "`maccess_crm` = '" . implode(',', $crm_access) . "', "; } $query = rtrim($query, ', '); $query = "UPDATE `#__wpl_users` SET " . $query . " WHERE `id`='" . $id . "'"; /** update user **/ wpl_db::q($query); return true; }
/** * Returns column with multilingual columns * @author Howard <*****@*****.**> * @static * @param array $columns * @param string $table * @return array */ public static function get_multilingual_columns($columns, $validation = true, $table = 'wpl_properties') { if (wpl_global::check_multilingual_status()) { $valid_columns = wpl_db::columns($table); $languages = wpl_addon_pro::get_wpl_languages(); foreach ($columns as $column) { foreach ($languages as $language) { $language_column = wpl_addon_pro::get_column_lang_name($column, $language, false); if ($validation and in_array($language_column, $valid_columns)) { $columns[] = $language_column; } elseif (!$validation) { $columns[] = $language_column; } } } } return $columns; }
/** * This function is for importing/updating properties into the WPL. It uses WPL standard format for importing * This function must call in everywhere that we need to import properties like MLS and IMPORTER Addons. * @author Howard <*****@*****.**> * @static * @param array $properties_to_import * @param string $wpl_unique_field * @param int $user_id * @param string $source * @param boolean $finalize * @param array $log_params * @return array property IDs */ public static function import($properties_to_import, $wpl_unique_field = 'mls_id', $user_id = '', $source = 'mls', $finalize = true, $log_params = array()) { if (!$user_id) { $user_id = wpl_users::get_cur_user_id(); } $pids = array(); $added = array(); // Used for logging results $updated = array(); // Used for logging results /** model **/ $model = new wpl_property(); $possible_columns = wpl_db::columns('wpl_properties'); foreach ($properties_to_import as $property_to_import) { $q = ''; $unique_value = ''; foreach ($property_to_import as $key => $row) { $wpl_field = $row['wpl_table_column'] ? $row['wpl_table_column'] : $key; $wpl_value = $row['wpl_value'] ? $row['wpl_value'] : ''; /** validation table column **/ if (!in_array($wpl_field, $possible_columns)) { continue; } /** set unique value **/ if ($wpl_field == $wpl_unique_field) { $unique_value = $wpl_value; } /** set user id value **/ if ($wpl_field == 'user_id') { $user_id = $wpl_value; } $q .= "`{$wpl_field}`='" . wpl_db::escape($wpl_value) . "',"; } $exists = $model->get_properties_count(" AND `{$wpl_unique_field}`='{$unique_value}'"); if (!$exists) { $pid = $model->create_property_default($user_id); } else { $pid = $model->pid($unique_value, $wpl_unique_field); } /** add property id to return **/ $pids[] = $pid; /** Add source and last sync date **/ if (in_array('source', $possible_columns) and in_array('last_sync_date', $possible_columns)) { $q .= "`source`='{$source}',"; $q .= "`last_sync_date`='" . date('Y-m-d H:i:s') . "',"; } $q = trim($q, ', '); $query = "UPDATE `#__wpl_properties` SET " . $q . " WHERE `id`='" . $pid . "'"; wpl_db::q($query); if ($finalize) { $mode = $exists ? 'edit' : 'add'; $model->finalize($pid, $mode, $user_id); } if ($exists) { $added[] = $unique_value; } else { $updated[] = $unique_value; } } /** Creating Log **/ if ($source == 'mls' and wpl_global::check_addon('mls')) { _wpl_import('libraries.addon_mls'); if (method_exists('wpl_addon_mls', 'log')) { wpl_addon_mls::log($added, $updated, $log_params); } } return $pids; }