/**
* check signup and if can add new user
* @return [type] [description]
*/
public static function signup($_mobile, $_pass, $_perm = null, $_name = null, $_ref = null)
{
// first if perm is true get default permission from db
if ($_perm === true) {
// if use true fill it with default value
$_perm = \lib\utility\option::get('account');
// default value not set in database
if ($_perm == '') {
$_perm = null;
}
} else {
$_perm = null;
}
$query = "\n\t\t\tSELECT\n\t\t\t\tid\n\t\t\tFROM\n\t\t\t\tusers\n\t\t\tWHERE\n\t\t\t\tuser_mobile = '{$_mobile}'\n\t\t\tLIMIT 1\n\t\t";
$result = \lib\db::get($query, 'id', true);
if ($result) {
// signup called and the mobile exist
return false;
} else {
$ref = null;
// get the ref and set in users_parent
if (isset($_SESSION['user']['ref'])) {
$ref = $_SESSION['user']['ref'];
} elseif ($_ref) {
$ref = $_ref;
}
// signup up users
$args = ['user_mobile' => $_mobile, 'user_pass' => \lib\utility::hasher($_pass), 'user_displayname' => $_name, 'user_permission' => $_perm, 'user_parent' => $ref, 'user_createdate' => date('Y-m-d H:i:s')];
$insert_new = self::insert($args);
$insert_id = \lib\db::insert_id();
self::$user_id = $insert_id;
// save ref in dashboard
if ($ref && $insert_id) {
self::dashboard_ref($ref, "user_referred");
}
return $insert_id;
}
}
public static function save($_content, $_args = null)
{
$values = ["post_id" => null, "comment_author" => null, "comment_email" => null, "comment_url" => null, "comment_meta" => null, "comment_status" => null, "comment_parent" => null, "user_id" => null, "visitor_id" => null];
if (!$_args) {
$_args = [];
}
// foreach args if isset use it
foreach ($_args as $key => $value) {
$value = "'" . $value . "'";
// check in normal condition exist
if (array_key_exists($key, $values)) {
$values[$key] = $value;
}
// check for id
$newKey = $key . '_id';
if (array_key_exists($newKey, $values)) {
$values[$newKey] = $value;
}
// check for table prefix
$newKey = 'comment_' . $key;
if (array_key_exists($newKey, $values)) {
$values[$newKey] = $value;
}
}
foreach ($values as $key => $value) {
if (!$value) {
unset($values[$key]);
}
}
// set not null fields
// set comment content
$values['comment_content'] = "'" . htmlspecialchars($_content) . "'";
// set comment status if not set
if (!isset($values['comment_status'])) {
$values['comment_status'] = "'unapproved'";
}
// set time of comment
if (isset($values['comment_meta']) && is_array($values['comment_meta'])) {
$values['comment_meta']['time'] = date('Y-m-d H:i:s');
} else {
$values['comment_meta'] = ['time' => date('Y-m-d H:i:s')];
}
$values['comment_meta'] = "'" . json_encode($values['comment_meta'], JSON_UNESCAPED_UNICODE) . "'";
// generate query text
$list_field = array_keys($values);
$list_field = implode($list_field, ', ');
$list_values = implode($values, ', ');
// create query string
$qry = "INSERT INTO comments ( {$list_field} ) VALUES ( {$list_values} )";
var_dump($qry);
// run query and insert into db
$result = \lib\db::query($qry);
// get insert id
$commentId = \lib\db::insert_id();
// return last insert id
return $commentId;
}
/**
* save question into post table
* @param [type] $_title [description]
* @param [type] $_answersList [description]
* @return [type] [description]
*/
public static function insertOrder($_title, $_meta, $_user_id = null)
{
$slug = \lib\utility\filter::slug($_title);
$pubDate = date('Y-m-d H:i:s');
$url = 'order/' . date('Y-m-d') . $_user_id . '/' . $slug;
$_meta = json_encode($_meta, JSON_UNESCAPED_UNICODE);
// create query string
$qry = "INSERT INTO posts\n\t\t(\n\t\t\t`post_language`,\n\t\t\t`post_title`,\n\t\t\t`post_slug`,\n\t\t\t`post_url`,\n\t\t\t`post_meta`,\n\t\t\t`post_type`,\n\t\t\t`post_status`,\n\t\t\t`post_publishdate`,\n\t\t\t`user_id`\n\t\t)\n\t\tVALUES\n\t\t(\n\t\t\t'fa',\n\t\t\t'{$_title}',\n\t\t\t'{$slug}',\n\t\t\t'{$url}',\n\t\t\t'{$_meta}',\n\t\t\t'order',\n\t\t\t'draft',\n\t\t\t'{$pubDate}',\n\t\t\t{$_user_id}\n\t\t)";
// run query
$result = \lib\db::query($qry);
// return last insert id
$newId = \lib\db::insert_id();
// save answers into options table
return $newId;
}
