function _route()
{
// check permission to access to cp
if (Tld !== 'dev') {
parent::_permission('cp');
}
// // Restrict unwanted module
// if(!$this->cpModlueList())
// \lib\error::page(T_("Not found!"));
$exist = false;
$mymodule = $this->cpModule('table');
$cpModule = $this->cpModule('raw');
// var_dump($this->child());
$this->display_name = 'content_cp/templates/raw.html';
switch ($this->child()) {
case 'dbtables':
$exist = true;
echo \lib\utility\dbTables::create();
break;
case 'db':
$exist = true;
if (\lib\utility::get('upgrade')) {
// do upgrade
$result = \lib\db::install(true);
} elseif (\lib\utility::get('backup')) {
$result = \lib\db::backup(true);
}
echo '<pre>';
print_r($result);
echo '</pre>';
break;
case 'twigtrans':
$exist = true;
$mypath = \lib\utility::get('path');
$myupdate = \lib\utility::get('update');
echo \lib\utility\twigTrans::extract($mypath, $myupdate);
break;
case 'phpinfo':
$exist = true;
phpinfo();
break;
case 'server':
$exist = true;
if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN' && !class_exists("COM")) {
ob_start();
echo "<!DOCTYPE html><meta charset='UTF-8'/><title>Extract text form twig files</title><body style='padding:0 1%;margin:0 1%;direction:ltr;overflow:hidden'>";
echo "<h1>" . T_("First you need to enable COM on windows") . "</h1>";
echo "<a target='_blank' href='http://www.php.net/manual/en/class.com.php'>" . T_("Read More") . "</a>";
break;
}
\lib\utility\tools::linfo();
$this->display_name = 'content_cp/templates/raw-all.html';
break;
case 'twitter':
$a = \lib\utility\socialNetwork::twitter('hello! test #api');
// var_dump($a);
break;
case 'mergefiles':
$exist = true;
echo \lib\utility\tools::mergefiles('merged-project.php');
if (\lib\utility::get('type') === 'all') {
echo \lib\utility\tools::mergefiles('merged-saloos-lib.php', core . lib);
echo \lib\utility\tools::mergefiles('merged-saloos-cp.php', addons . 'content_cp/');
echo \lib\utility\tools::mergefiles('merged-saloos-account.php', addons . 'content_account/');
echo \lib\utility\tools::mergefiles('merged-saloos-includes.php', addons . 'includes/');
}
break;
case 'sitemap':
$exist = true;
$site_url = \lib\router::get_storage('url_site');
$sitemap = new \lib\utility\sitemap($site_url, root . 'public_html/', 'sitemap');
// echo "<pre>";
// add posts
foreach ($this->model()->sitemap('posts', 'post') as $row) {
$sitemap->addItem($row['post_url'], '0.8', 'daily', $row['post_publishdate']);
}
// add pages
foreach ($this->model()->sitemap('posts', 'page') as $row) {
$sitemap->addItem($row['post_url'], '0.6', 'weekly', $row['post_publishdate']);
}
// add attachments
foreach ($this->model()->sitemap('posts', 'attachment') as $row) {
$sitemap->addItem($row['post_url'], '0.2', 'weekly', $row['post_publishdate']);
}
// add books
foreach ($this->model()->sitemap('posts', 'book') as $row) {
$sitemap->addItem($row['post_url'], '0.6', 'yearly', $row['post_publishdate']);
}
// add cats and tags
foreach ($this->model()->sitemap('terms') as $row) {
$sitemap->addItem($row['term_url'], '0.4', 'weekly', $row['date_modified']);
}
$sitemap->createSitemapIndex();
echo "<p class='alert alert-success'>Create sitemap Successfully!</p>";
// echo "Create Successful";
break;
case 'git':
// declare variables
$exist = true;
$rep = null;
$result = [];
$location = '../../';
$name = \lib\utility::get('name');
$output = null;
// switch by name of repository
switch ($name) {
case 'saloos':
$location .= 'saloos';
$rep .= "https://github.com/Ermile/Saloos.git";
break;
case 'addons':
$location .= 'saloos/saloos-addons';
$rep .= "https://github.com/Ermile/Saloos-Addons.git";
break;
default:
$exist = false;
return;
break;
}
// change location to address of requested
chdir($location);
// start show result
$output = "<pre>";
$output .= 'Repository address: ' . getcwd() . '<br/>';
$output .= 'Remote address: ' . $rep . '<hr/>';
$command = 'git pull ' . $rep . ' 2>&1';
// Print the exec output inside of a pre element
exec($command, $result);
if (!$result) {
$output .= T_('Not Work!');
}
foreach ($result as $line) {
$output .= $line . "\n";
}
$output .= "</pre>";
echo $output;
break;
case null:
$mypath = $this->url('path', '_');
if (is_file(addons . 'content_cp/templates/static_' . $mypath . '.html')) {
$this->display_name = 'content_cp/templates/static_' . $mypath . '.html';
}
// $this->display_name = 'content_cp/templates/static_'.$mypath.'.html';
break;
default:
$this->display_name = 'content_cp/templates/static_tools.html';
return;
break;
}
// $this->get()->ALL();
if ($exist) {
$this->model()->_processor(object(array("force_json" => false, "force_stop" => true)));
}
return;
}
/**
* this function set custom operator for each custom module in cp
* @param [type] $_id [description]
* @return [type] [description]
*/
function cp_create_query($_id = null, $_data = null)
{
if (!$_id) {
$_id = $this->childparam('edit');
}
// set useful variables
$cpModule = $this->cpModule();
$qry = $this->sql()->table('posts');
$datarow = null;
$defaultCat = null;
// if datarow is not sending from parameter give it form post
if (!(is_array($_data) && $_data)) {
$datarow = self::cp_getPosts($_id);
$defaultCat = utility::post('cat');
} else {
// if default cat isset then
if (isset($_data['defaultCat'])) {
$defaultCat = $_data['defaultCat'];
unset($_data['defaultCat']);
}
$datarow = $_data;
}
// if don't set title return error
if (!(isset($datarow['title']) && $datarow['title'])) {
debug::warn(T_("Please enter title") . "!", 'title');
return false;
}
// set slug if is not set
if (!$datarow['slug']) {
$datarow['slug'] = utility\filter::slug($datarow['title']);
}
// fix post language
$datarow['language'] = substr($datarow['language'], 0, 2);
// start generate post url
$url_slug = $datarow['slug'];
$url_body = null;
$url_prefix = null;
switch ($cpModule['raw']) {
case 'pages':
case 'books':
// calc and set url
if ($datarow['parent']) {
$url_body = $this->sql()->table('posts')->where('post_type', $cpModule['type'])->and('id', $datarow['parent'])->select()->assoc('post_url');
} else {
$datarow['parent'] = '#NULL';
}
if ($cpModule['raw'] === 'books') {
$url_prefix = 'book/';
}
break;
// only on edit
// only on edit
case 'attachments':
// remove unuse fields like slug, url, data, status, ...
// commented row not deleted and check
unset($datarow['language']);
// unset($datarow['title']);
unset($datarow['slug']);
// unset($datarow['content']);
unset($datarow['type']);
// unset($datarow['url']);
// unset($datarow['status']);
unset($datarow['parent']);
// unset($datarow['user_id']);
unset($datarow['publishdate']);
if (!$defaultCat) {
$defaultCat = 'file';
}
$url_body = $defaultCat;
// // read post meta and rewrite it
// $datarow['meta'] = $this->sql()->table('posts')
// ->where('post_type', 'attachment')->and('id', $_id)
// ->select()->assoc('post_meta');
// $datarow['meta'] = json_decode($datarow['meta'], true);
// $datarow['meta']['slug'] = $datarow['slug'];
// $datarow['meta'] = json_encode($datarow['meta']);
break;
case 'socialnetwork':
$datarow['slug'] = 'social' . md5(time());
$url_slug = $datarow['slug'];
$url_prefix = 'social/';
$datarow['status'] = 'draft';
break;
// all other type of post
// all other type of post
default:
unset($datarow['parent']);
case 'polls':
$url_body = $defaultCat;
if (!$url_body) {
// calc and set url
$url_body = $this->sql()->table('terms')->where('id', 1)->select()->assoc('term_url');
}
if ($cpModule['raw'] === 'polls') {
$datarow['type'] = 'poll_sarshomar';
}
break;
}
// generate posturl
$datarow['url'] = self::sp_generateUrl($url_slug, $url_body, $url_prefix);
// if in edit get this record data
if ($_id) {
$record = $this->sql()->table('posts')->where('id', $_id)->select()->assoc();
$record_meta = $this->sql()->table('options')->where('post_id', $_id)->order('id', 'asc')->select()->allassoc();
// fill options value like posts field
foreach ($record_meta as $key => $value) {
$record[$record_meta[$key]['option_key']] = $record_meta[$key]['option_value'];
}
}
$changed = false;
// set values if exist
foreach ($datarow as $key => $value) {
$key = $key === 'user_id' ? 'user_id' : 'post_' . $key;
if ($_id) {
// check with old data and if change then set it
if ($record[$key] !== $value) {
$qry = $qry->set($key, $value);
$changed = true;
}
} elseif ($value) {
$qry = $qry->set($key, $value);
}
}
$post_new_id = $_id;
if ($_id) {
// on edit
if ($changed) {
$qry = $qry->where('id', $_id)->update();
}
} else {
// on add
$qry = $qry->insert();
$post_new_id = $qry->LAST_INSERT_ID();
}
if ($post_new_id === 0 || !$post_new_id) {
return;
}
// if publish post share it on twitter and save in options
// before share check db for share before
// if on add or in edit and staus exist and status !== 400
// then if status == publish and changed from old position
// $post_status = isset($record['post_status'])? $record['post_status']: null;
// $post_type = isset($record['post_type'])? $record['post_type'] : null;
// $post_type = ($post_type) ? $post_type : $cpModule['type'];
// if($datarow['status'] === 'publish' && $datarow['status'] !== $post_status && $post_type === 'post')
// {
// $url_main = $this->url('MainProtocol'). '://'.$this->url('MainSite');
// if(!(isset($record['twitter']['status']) && $record['twitter']['status'] === 400 ))
// {
// $mytwitte = $datarow['title'] . ' '. $url_main.'/'.$datarow['url'];
// $twitte_result = \lib\utility\socialNetwork::twitter($mytwitte);
// if(isset($twitte_result) && isset($twitte_result['status']))
// {
// $twitte_result = json_encode($twitte_result);
// $qry_twitter = $this->sql()->table('options')
// ->set('post_id', $post_new_id)
// ->set('option_cat', 'post'. $post_new_id. '_SocialNetwork')
// ->set('option_key', 'twitter')
// ->set('option_value', $twitte_result);
// // $qry_twitter = $qry_twitter->insertString();
// $qry_twitter = $qry_twitter->insert();
// }
// }
// $telegram = \lib\utility\socialNetwork::telegram($datarow['title'] . "\n". $url_main.'/'.$datarow['url']);
// $facebook_content = html_entity_decode($datarow['content']);
// $facebook_content = preg_replace("/<\/p>/", "\n", $facebook_content);
// $facebook_content = preg_replace("/<[^>]+>/", "", $facebook_content);
// $facebook_content = preg_replace("/^[\s\n\r\t]+/", "", $facebook_content);
// $facebook_url = $url_main.'/'.$datarow['url'];
// $result_fb = \lib\utility\socialNetwork::facebook($facebook_url, $facebook_content);
// if(isset($result_fb))
// {
// // $result_fb = json_encode($result_fb);
// $qry_facebook = $this->sql()->table('options')
// ->set('post_id', $post_new_id)
// ->set('option_cat', 'post'. $post_new_id. '_SocialNetwork')
// ->set('option_key', 'facebook')
// ->set('option_value', $result_fb);
// // $qry_facebook = $qry_facebook->insertString();
// $qry_facebook = $qry_facebook->insert();
// }
// }
// add tags to terms table
$mycats = utility::post('categories');
// if(!$mycats)
// $mycats = [1];
$mytags = utility::post('tags');
$mytags = explode(',', $mytags);
foreach ($mytags as $key => $value) {
$value = trim($value, " ");
$value = trim($value, "'");
if ($value) {
$mytags[$key] = $value;
} else {
unset($mytags[$key]);
}
}
// --------------------------------------------------- check new tag and cats with old one on edit
if ($_id) {
$myterms_del = null;
// get old tags and diff of it with new one by title of tags
$old_tags = $this->sp_term_list('tag', false);
$tags_diff = array_diff($old_tags, $mytags);
if (count($tags_diff) > 0) {
// get the list of tags id
$tags_id = $this->cp_tag_id($tags_diff);
$myterms_del = $tags_id;
}
// get old cats and diff of it with new one by id
if ($cpModule['raw'] === 'attachments') {
$old_cats = $this->sp_term_list('filecat', false);
if (!is_array($mycats)) {
$mycats = null;
}
} elseif ($cpModule['raw'] === 'books') {
$old_cats = $this->sp_term_list('bookcat', false);
if (!is_array($mycats)) {
$mycats = null;
}
} else {
$old_cats = $this->sp_term_list('cat', false);
if (!is_array($mycats)) {
$mycats = [1];
}
}
if (is_array($old_cats) && count($old_cats) && is_array($mycats) && count($mycats)) {
$cats_diff = array_diff($old_cats, $mycats);
} elseif (is_array($mycats) && count($mycats)) {
$cats_diff = $mycats;
} else {
$cats_diff = $old_cats;
}
if (is_array($cats_diff) && count($cats_diff) > 0) {
$cats_diff = implode(",", $cats_diff);
if ($myterms_del) {
$myterms_del .= ',';
}
$myterms_del .= $cats_diff;
}
// delete deleted tags and cats together in one query
if ($myterms_del) {
$qry_term_del = $this->sql()->table('termusages')->where('termusage_id', $post_new_id);
if (count(explode(',', $myterms_del)) === 1) {
$qry_term_del = $qry_term_del->and('term_id', '=', $myterms_del)->delete();
} else {
$qry_term_del = $qry_term_del->and('term_id', 'in', "(" . $myterms_del . ")")->delete();
}
}
}
// ------------------------------------------------- if user enter new tag
$tags_id = array();
if (count($mytags) > 0) {
$qry_tag = $this->sql()->table('terms');
// add each tag to sql syntax
foreach ($mytags as $value) {
if ($value) {
$qry_tag = $qry_tag->set('term_type', 'tag')->set('term_title', $value)->set('term_slug', $value)->set('term_url', $value);
}
}
$qry_tag->insert('IGNORE');
// get the list of tags id
$tags_id = $this->cp_tag_id($mytags, false);
if (!is_array($tags_id)) {
$tags_id = array();
}
}
// add selected tag to term usages table
// on pages dont need cats and only add tags
if ($cpModule['raw'] === 'pages') {
$myterms = $tags_id;
} elseif (is_array($mycats) && count($mycats)) {
$myterms = array_merge($tags_id, $mycats);
} else {
$myterms = $tags_id;
}
// ---------------------------------------------- set termusage table
// if terms exist go to foreach
if (isset($myterms) && count($myterms) > 0) {
$qry_tagusages = $this->sql()->table('termusages');
foreach ($myterms as $value) {
$qry_tagusages = $qry_tagusages->set('term_id', $value)->set('termusage_id', $post_new_id)->set('termusage_foreign', 'posts');
}
$qry_tagusages->insert('IGNORE');
}
// update post url
// $post_url = utility::post('slug', 'filter');
// $this->sql()->table('posts')->set('post_url', $post_url)
// ->where('id', $post_new_id)->update();
// ======================================================
// you can manage next event with one of these variables,
// commit for successfull and rollback for failed
// if query run without error means commit
if ($cpModule['raw'] == 'socialnetwork') {
$twitte_result = \lib\utility\socialNetwork::telegram($datarow['content']);
}
$this->commit(function ($_postId, $_edit = null) {
$_module = $this->cpModule('raw');
// if we are on create poll add into options table
if ($_module === 'polls') {
self::sp_savePoll($_postId);
}
if ($_edit) {
debug::true(T_("Update Successfully"));
$this->redirector()->set_url($_module . '/edit=' . $_postId);
} else {
debug::true(T_("Insert Successfully"));
$this->redirector()->set_url($_module . '/edit=' . $_postId);
}
}, $post_new_id, $_id);
// if a query has error or any error occour in any part of codes, run roolback
$this->rollback(function () {
debug::title(T_("Transaction error") . ': ');
});
}