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;
}
