/**
* JSON action method
*
* @return void
*/
public function json()
{
$json = ['seo_title' => '', 'description' => '', 'keywords' => ''];
$seoTitle = \Phire\Fields\Table\Fields::findBy(['name' => 'seo_title']);
$description = \Phire\Fields\Table\Fields::findBy(['name' => 'description']);
$keywords = \Phire\Fields\Table\Fields::findBy(['name' => 'keywords']);
if (isset($seoTitle->id)) {
$json['seo_title'] = $seoTitle->id;
}
if (isset($description->id)) {
$json['description'] = $description->id;
}
if (isset($keywords->id)) {
$json['keywords'] = $keywords->id;
}
$body = json_encode($json, JSON_PRETTY_PRINT);
$this->send(200, ['Content-Type' => 'application/json'], $body);
}
/**
* Bootstrap the module
*
* @param Application $application
* @return void
*/
public static function bootstrap(Application $application)
{
if ($application->isRegistered('phire-content') && $application->isRegistered('phire-fields')) {
$fields = \Phire\Fields\Table\Fields::findBy(['models' => "%Phire\\\\Content\\\\Model\\\\Content%"]);
$names = [];
foreach ($fields->rows() as $field) {
$names[] = $field->name;
}
if (!in_array('seo_title', $names)) {
$field = new \Phire\Fields\Table\Fields(['group_id' => null, 'storage' => 'eav', 'type' => 'text', 'name' => 'seo_title', 'label' => 'SEO Title', 'values' => null, 'default_values' => null, 'attributes' => 'size="80" style="width: 99.5%;"', 'validators' => 'a:0:{}', 'encrypt' => 0, 'order' => -3, 'required' => 0, 'prepend' => 0, 'dynamic' => 0, 'editor' => null, 'models' => 'a:1:{i:0;a:3:{s:5:"model";s:27:"Phire\\Content\\Model\\Content";s:10:"type_field";N;s:10:"type_value";N;}}']);
$field->save();
}
if (!in_array('description', $names)) {
$field = new \Phire\Fields\Table\Fields(['group_id' => null, 'storage' => 'eav', 'type' => 'text', 'name' => 'description', 'label' => 'Description', 'values' => null, 'default_values' => null, 'attributes' => 'size="80" style="width: 99.5%;"', 'validators' => 'a:0:{}', 'encrypt' => 0, 'order' => -2, 'required' => 0, 'prepend' => 0, 'dynamic' => 0, 'editor' => null, 'models' => 'a:1:{i:0;a:3:{s:5:"model";s:27:"Phire\\Content\\Model\\Content";s:10:"type_field";N;s:10:"type_value";N;}}']);
$field->save();
}
if (!in_array('keywords', $names)) {
$field = new \Phire\Fields\Table\Fields(['group_id' => null, 'storage' => 'eav', 'type' => 'text', 'name' => 'keywords', 'label' => 'Keywords', 'values' => null, 'default_values' => null, 'attributes' => 'size="80" style="width: 99.5%;"', 'validators' => 'a:0:{}', 'encrypt' => 0, 'order' => -1, 'required' => 0, 'prepend' => 0, 'dynamic' => 0, 'editor' => null, 'models' => 'a:1:{i:0;a:3:{s:5:"model";s:27:"Phire\\Content\\Model\\Content";s:10:"type_field";N;s:10:"type_value";N;}}']);
$field->save();
}
}
}
/**
* Process and save seo config
*
* @param array $exclude
* @return void
*/
public function saveAnalysis(array $exclude = [])
{
$config = Table\Config::findById('seo_config');
$cfg = isset($config->value) && !empty($config->value) && $config->value != '' ? unserialize($config->value) : [];
$analysis = ['tracking' => false, 'sitemap' => false, 'robots' => false, 'caching' => false, 'site-verify' => false, 'content' => ['good' => [], 'bad' => []]];
if (!empty($cfg['tracking']) && $cfg['tracking'] != '') {
$analysis['tracking'] = true;
}
$sitemap = \Phire\Table\Modules::findBy(['name' => 'phire-sitemap']);
if (file_exists($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . '/sitemap.xml') || isset($sitemap->id) && $sitemap->active) {
$analysis['sitemap'] = true;
}
if (file_exists($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . '/robots.txt') || isset($cfg['robots']) && !empty($cfg['robots']) && $cfg['robots'] != '') {
$analysis['robots'] = true;
}
$cacheDetect = false;
$curl = new Curl('http://' . $_SERVER['HTTP_HOST'] . BASE_PATH);
if ($curl->getCode() == 200 && null !== $curl->getHeader('Cache-Control') && null !== $curl->getHeader('Expires') && null !== $curl->getHeader('Last-Modified') && null !== $curl->getHeader('Etag')) {
$cacheDetect = true;
}
$cache = \Phire\Table\Modules::findBy(['name' => 'phire-cache']);
if ($cacheDetect || isset($cache->id) && $cache->active) {
$analysis['caching'] = true;
}
$dir = new Dir($_SERVER['DOCUMENT_ROOT'] . BASE_PATH, ['relative' => true, 'filesOnly' => true]);
$googleFileDetect = false;
foreach ($dir->getFiles() as $file) {
if (substr($file, 0, 6) == 'google' && strpos(file_get_contents($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . '/' . $file), 'google-site-verification') !== false) {
$googleFileDetect = true;
}
}
$googleMetaDetect = false;
if (isset($cfg['meta'])) {
foreach ($cfg['meta'] as $meta) {
if ($meta['name'] == 'google-site-verification') {
$googleMetaDetect = true;
}
}
}
if ($googleFileDetect || $googleMetaDetect) {
$analysis['site-verify'] = true;
} else {
if (function_exists('dns_get_record') && $_SERVER['HTTP_HOST'] != 'localhost') {
$dns = dns_get_record($_SERVER['HTTP_HOST'], DNS_TXT);
if (count($dns) > 0) {
foreach ($dns as $record) {
if (isset($record['txt']) && strpos($record['txt'], 'google-site-verification') !== false) {
$analysis['site-verify'] = true;
}
}
}
}
}
$fields = ['seo_title' => '', 'description' => '', 'keywords' => ''];
$seoTitle = \Phire\Fields\Table\Fields::findBy(['name' => 'seo_title']);
$description = \Phire\Fields\Table\Fields::findBy(['name' => 'description']);
$keywords = \Phire\Fields\Table\Fields::findBy(['name' => 'keywords']);
if (isset($seoTitle->id)) {
$fields['seo_title'] = $seoTitle->id;
}
if (isset($description->id)) {
$fields['description'] = $description->id;
}
if (isset($keywords->id)) {
$fields['keywords'] = $keywords->id;
}
$content = \Phire\Content\Table\Content::findAll();
foreach ($content->rows() as $c) {
if (!in_array($c->type_id, $exclude)) {
$seoTitle = '';
$metaDesc = '';
$metaKeys = '';
if ($fields['seo_title'] != '') {
$seoTitleField = \Phire\Fields\Table\FieldValues::findById([$fields['seo_title'], $c->id, "Phire\\Content\\Model\\Content"]);
if (isset($seoTitleField->field_id)) {
$seoTitle = json_decode($seoTitleField->value);
}
}
if ($fields['description'] != '') {
$descriptionField = \Phire\Fields\Table\FieldValues::findById([$fields['description'], $c->id, "Phire\\Content\\Model\\Content"]);
if (isset($descriptionField->field_id)) {
$metaDesc = json_decode($descriptionField->value);
}
}
if ($fields['keywords'] != '') {
$keywordsField = \Phire\Fields\Table\FieldValues::findById([$fields['keywords'], $c->id, "Phire\\Content\\Model\\Content"]);
if (isset($keywordsField->field_id)) {
$metaKeys = json_decode($keywordsField->value);
}
}
if (strlen($seoTitle) > 0 && strlen($seoTitle) <= 60 && strlen($metaDesc) > 0 && strlen($metaDesc) <= 160 && strlen($metaKeys) > 0 && strlen($metaKeys) <= 255) {
$analysis['content']['good'][$c->id] = ['title' => $c->title, 'uri' => $c->uri];
} else {
$analysis['content']['bad'][$c->id] = ['title' => $c->title, 'type_id' => $c->type_id, 'uri' => $c->uri, 'issues' => []];
if (strlen($seoTitle) == 0) {
$analysis['content']['bad'][$c->id]['issues'][] = 'No SEO Title';
} else {
if (strlen($seoTitle) > 60) {
$analysis['content']['bad'][$c->id]['issues'][] = 'SEO Title is too long';
}
}
if (strlen($metaDesc) == 0) {
$analysis['content']['bad'][$c->id]['issues'][] = 'No description meta tag';
} else {
if (strlen($metaDesc) > 160) {
$analysis['content']['bad'][$c->id]['issues'][] = 'Description meta tag is too long';
}
}
if (strlen($metaKeys) == 0) {
$analysis['content']['bad'][$c->id]['issues'][] = 'No keywords meta tag';
} else {
if (strlen($metaKeys) > 255) {
$analysis['content']['bad'][$c->id]['issues'][] = 'Keywords meta tag is too long';
}
}
}
}
}
$config = Table\Config::findById('seo_analysis');
$config->value = serialize($analysis);
$config->save();
}
/**
* Delete dynamic field values
*
* @param AbstractController $controller
* @param Application $application
*
* @return void
*/
public static function delete(AbstractController $controller, Application $application)
{
if ($_POST) {
$uploadFolder = BASE_PATH . CONTENT_PATH . '/files';
$mediaLibrary = $application->module('phire-fields')->config()['media_library'];
foreach ($_POST as $key => $value) {
if (substr($key, 0, 3) == 'rm_' && is_array($value)) {
$fields = Table\Fields::findBy();
$fieldIds = [];
$fieldTypes = [];
$fieldStorage = [];
foreach ($fields->rows() as $field) {
$fieldIds[$field->id] = $field->name;
$fieldTypes[$field->id] = $field->type;
$fieldStorage[$field->id] = $field->storage;
}
foreach ($value as $id) {
foreach ($fieldIds as $fieldId => $fieldName) {
if ($fieldStorage[$fieldId] == 'eav') {
$fv = Table\FieldValues::findBy(['model_id' => (int) $id]);
if ($fv->hasRows()) {
foreach ($fv->rows() as $f) {
$fValue = json_decode($f->value, true);
if (!is_array($fValue)) {
$fValue = [$fValue];
}
foreach ($fValue as $f) {
if (file_exists($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $f)) {
unlink($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $f);
}
if (null !== $mediaLibrary && $application->isRegistered('phire-media')) {
$library = new \Phire\Media\Model\MediaLibrary();
$library->getByFolder($mediaLibrary);
if (file_exists($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . CONTENT_PATH . '/' . $library->folder . '/' . $f)) {
$media = new \Phire\Media\Model\Media();
$media->getByFile($f);
if (isset($media->id)) {
$media->remove(['rm_media' => [$media->id]]);
}
}
}
}
}
}
$fv = new Table\FieldValues();
$fv->delete(['model_id' => (int) $id]);
} else {
$fv = new Record();
$fv->setPrefix(DB_PREFIX)->setPrimaryKeys(['id'])->setTable('field_' . $fieldName);
$fv->findRecordsBy(['model_id' => (int) $id]);
if ($fieldTypes[$fieldId] == 'file' && $fv->hasRows()) {
foreach ($fv->rows() as $f) {
if (file_exists($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $f->value)) {
unlink($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $f->value);
}
if (null !== $mediaLibrary && $application->isRegistered('phire-media')) {
$library = new \Phire\Media\Model\MediaLibrary();
$library->getByFolder($mediaLibrary);
if (file_exists($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . CONTENT_PATH . '/' . $library->folder . '/' . $f->value)) {
$media = new \Phire\Media\Model\Media();
$media->getByFile($f->value);
if (isset($media->id)) {
$media->remove(['rm_media' => [$media->id]]);
}
}
}
}
}
$fv->delete(['model_id' => (int) $id]);
}
}
}
}
}
}
}
/**
* Add dynamic fields to the form configs
*
* @param Application $application
* @return void
*/
public static function addFields(Application $application)
{
$forms = $application->config()['forms'];
$fields = Table\Fields::findBy(['group_id' => null], ['order' => 'order'], Table\FieldGroups::ROW_AS_ARRAYOBJECT);
$groups = Table\FieldGroups::findAll(['order' => 'order'], Table\FieldGroups::ROW_AS_ARRAYOBJECT);
if ($fields->count() > 0) {
foreach ($fields->rows() as $field) {
$field->validators = unserialize($field->validators);
$field->models = unserialize($field->models);
foreach ($field->models as $i => $model) {
if ($model['model'] == 'Phire\\Model\\User') {
$register = $model;
$registerEmail = $model;
$profile = $model;
$profileEmail = $model;
$register['model'] = 'Phire\\Model\\Register';
$registerEmail['model'] = 'Phire\\Model\\RegisterEmail';
$profile['model'] = 'Phire\\Model\\Profile';
$profileEmail['model'] = 'Phire\\Model\\ProfileEmail';
$field->models[] = $register;
$field->models[] = $registerEmail;
$field->models[] = $profile;
$field->models[] = $profileEmail;
}
}
foreach ($field->models as $model) {
$form = str_replace('Model', 'Form', $model['model']);
if (isset($forms[$form]) && self::isAllowed($model, $application)) {
end($forms[$form]);
$key = key($forms[$form]);
reset($forms[$form]);
$fieldConfig = self::createFieldConfig($field);
if ($form == 'Phire\\Form\\Register' || $form == 'Phire\\Form\\RegisterEmail' || $form == 'Phire\\Form\\Profile' || $form == 'Phire\\Form\\ProfileEmail') {
$forms[$form][1]['field_' . $field->id] = $fieldConfig;
} else {
if ($field->dynamic) {
if (isset($fieldConfig['label'])) {
$fieldConfig['label'] = '<a href="#" onclick="return phire.addField(' . $field->id . ');">[+]</a> ' . $fieldConfig['label'];
} else {
$fieldConfig['label'] = '<a href="#" onclick="return phire.addField(' . $field->id . ');">[+]</a>';
}
if (isset($fieldConfig['attributes'])) {
$fieldConfig['attributes']['data-path'] = BASE_PATH . APP_URI;
$fieldConfig['attributes']['data-model'] = $model['model'];
} else {
$fieldConfig['attributes'] = ['data-path' => BASE_PATH . APP_URI, 'data-model' => $model['model']];
}
}
if (is_numeric($key)) {
if ($field->prepend) {
$forms[$form][$key] = array_merge(['field_' . $field->id => $fieldConfig], $forms[$form][$key]);
} else {
$forms[$form][$key]['field_' . $field->id] = $fieldConfig;
}
} else {
if ($field->prepend) {
$forms[$form] = array_merge(['field_' . $field->id => $fieldConfig], $forms[$form]);
} else {
$forms[$form]['field_' . $field->id] = $fieldConfig;
}
}
}
}
}
}
}
$fieldGroups = [];
$groupPrepend = [];
if ($groups->count() > 0) {
$tab = 1001;
foreach ($groups->rows() as $group) {
$groupPrepend[$group->id] = (bool) $group->prepend;
$fields = Table\Fields::findBy(['group_id' => $group->id], ['order' => 'order']);
if ($fields->count() > 0) {
$i = 0;
foreach ($fields->rows() as $field) {
$field->validators = unserialize($field->validators);
$field->models = unserialize($field->models);
foreach ($field->models as $model) {
$form = str_replace('Model', 'Form', $model['model']);
if (isset($forms[$form]) && self::isAllowed($model, $application)) {
$fieldConfig = self::createFieldConfig($field);
if ($field->dynamic) {
if (isset($fieldConfig['label'])) {
$fieldConfig['label'] = '<a href="#" onclick="return phire.addField(' . $field->id . ');">[+]</a> ' . $fieldConfig['label'];
} else {
$fieldConfig['label'] = '<a href="#" onclick="return phire.addField(' . $field->id . ']);">[+]</a>';
}
}
if (isset($fieldConfig['attributes'])) {
$fieldConfig['attributes']['tabindex'] = $tab;
$fieldConfig['attributes']['data-path'] = BASE_PATH . APP_URI;
$fieldConfig['attributes']['data-model'] = $model['model'];
} else {
$fieldConfig['attributes'] = ['tabindex' => $tab, 'data-path' => BASE_PATH . APP_URI, 'data-model' => $model['model']];
}
$tab++;
if (!isset($fieldGroups[$form])) {
$fieldGroups[$form] = [];
}
if (!isset($fieldGroups[$form][$field->group_id])) {
$fieldGroups[$form][$field->group_id] = [];
}
if ($field->prepend) {
$fieldGroups[$form][$field->group_id] = array_merge(['field_' . $field->id => $fieldConfig], $fieldGroups[$form][$field->group_id]);
} else {
$fieldGroups[$form][$field->group_id]['field_' . $field->id] = $fieldConfig;
}
}
}
$i++;
}
}
}
}
foreach ($fieldGroups as $form => $configs) {
$keys = array_keys($forms[$form]);
$numeric = true;
foreach ($keys as $key) {
if (!is_numeric($key)) {
$numeric = false;
}
}
$formConfig = $numeric ? $forms[$form] : [$forms[$form]];
foreach ($configs as $id => $config) {
if ($groupPrepend[$id]) {
$formConfig = array_merge($config, $formConfig);
} else {
$formConfig[] = $config;
}
}
$forms[$form] = $formConfig;
}
$application->mergeConfig(['forms' => $forms], true);
}
