public static function list_metas()
{
$context = Context::getContext();
$table = new Cli\Table();
$table->setHeaders(array('id', 'page', 'title', 'description', 'url_rewrite', 'keywords'));
$metas = Meta::getMetasByIdLang($context->lang->id);
foreach ($metas as $meta) {
$table->addRow(array($meta['id_meta'], $meta['page'], $meta['title'], $meta['description'], $meta['url_rewrite'], $meta['keywords']));
}
$table->display();
return;
}
public static function print_available_themes()
{
$installedThemesDirs = array();
$themes = Theme::getAvailable(false);
$installedThemes = Theme::getThemes();
foreach ($installedThemes as $installedTheme) {
$installedThemesDirs[] = $installedTheme->directory;
}
$table = new Cli\Table();
$table->setHeaders(array('Directory', 'Installed'));
foreach ($themes as $theme) {
//check if theme is installed
if (array_search($theme, $installedThemesDirs) === false) {
$isInstalled = 'No';
} else {
$isInstalled = 'Yes';
}
$table->addRow(array($theme, $isInstalled));
}
$table->display();
}
public static function list_pages()
{
$context = Context::getContext();
$table = new Cli\Table();
$table->setHeaders(array('id', 'category', 'position', 'active', 'indexation', 'lang', 'title', 'rewrite', 'keywords'));
//$pages = CMS::listCms($context->language->id);
$pages = CMS::getCMSPages($context->language->id, null, false);
foreach ($pages as $page) {
$table->addRow(array($page['id_cms'], $page['id_cms_category'], $page['position'], $page['active'], $page['indexation'], Language::getIsoById($page['id_lang']), $page['meta_title'], $page['link_rewrite'], $page['meta_keywords']));
}
$table->display();
return true;
}
public static function list_aliases()
{
$table = new Cli\Table();
$table->setHeaders(array('id_alias', 'alias', 'search', 'active'));
$aliases = Db::getInstance()->executeS('
SELECT a.*
FROM `' . _DB_PREFIX_ . 'alias` a');
foreach ($aliases as $alias) {
$table->addRow(array($alias['id_alias'], $alias['alias'], $alias['search'], $alias['active'] ? 'yes' : 'no'));
}
$table->display();
}
public static function list_permissions($profileId)
{
$configuration = PS_CLI_CONFIGURE::getConfigurationInstance();
if (!Validate::isUnsignedInt($profileId)) {
echo "Error, {$profileId} is not a valid profile ID\n";
return false;
}
$profile = new Profile($profileId);
if (!Validate::IsLoadedObject($profile)) {
echo "Error, could not find a profile with ID: {$profileId}\n";
return false;
}
$accesses = Profile::getProfileAccesses($profileId, 'id_tab');
echo "Access rights for profile " . array_pop($profile->name) . " ({$profileId})\n";
$table = new Cli\Table();
$table->setHeaders(array('Tab', 'View', 'Add', 'Edit', 'Delete'));
$allowedStr = 'X';
$deniedStr = '';
foreach ($accesses as $access) {
$tab = new Tab($access['id_tab'], $configuration->lang);
$table->addRow(array($tab->name, $access['view'] == 1 ? $allowedStr : $deniedStr, $access['add'] == 1 ? $allowedStr : $deniedStr, $access['edit'] == 1 ? $allowedStr : $deniedStr, $access['delete'] == 1 ? $allowedStr : $deniedStr));
}
$table->display();
}
public function list_languages()
{
$languages = Language::getLanguages(false, false);
$defaultLang = Configuration::get('PS_LANG_DEFAULT');
$table = new Cli\Table();
$table->setHeaders(array('id', 'name', 'active', 'iso_code', 'language_code', 'date_format_lite', 'date_format_full', 'is_rtl', 'Default'));
foreach ($languages as $lang) {
$table->addRow(array($lang['id_lang'], $lang['name'], $lang['active'], $lang['iso_code'], $lang['language_code'], $lang['date_format_lite'], $lang['date_format_full'], $lang['is_rtl'], $lang['id_lang'] == $defaultLang ? 'X' : ''));
}
$table->display();
}
public static function display_table(Cli\Table $table)
{
$table->display();
}
public static function list_groups()
{
$groups = ShopGroup::getShopGroups(false);
$table = new Cli\Table();
$table->setHeaders(array('id', 'name', 'share customers', 'share orders', 'share stock', 'active', 'deleted'));
foreach ($groups as $group) {
$fields = $group->getFields();
$table->addRow(array($fields['id_shop_group'], $fields['name'], $fields['share_customer'], $fields['share_order'], $fields['share_stock'], $fields['active'], $fields['deleted']));
}
$table->display();
}
public static function list_database_backups()
{
$dh = @opendir(PrestaShopBackup::getBackupPath());
if ($dh === false) {
echo "Error, cannot read database backup directory {$dh}\n";
return false;
}
$table = new Cli\Table();
$table->setHeaders(array('Filename', 'Size', 'Date'));
while ($file = readdir($dh)) {
if (preg_match('/^([_a-zA-Z0-9\\-]*[\\d]+-[a-z\\d]+)\\.sql(\\.gz|\\.bz2)?$/', $file, $matches) == 0) {
continue;
}
$filename = $file;
$size = number_format(filesize(PrestaShopBackup::getBackupPath($file)) / 1000, 2) . ' Kb';
$date = date('Y-m-d H:i:s', (int) $matches[1]);
$table->addRow(array($filename, $size, $date));
}
$table->display();
return true;
}
public static function list_images()
{
$context = Context::getContext();
$images = Image::getAllImages();
$table = new Cli\Table();
$table->setHeaders(array('id_image', 'id_product', 'product name', 'path'));
foreach ($images as $image) {
$product = new Product($image['id_product']);
$img = new Image($image['id_image']);
//print_r($img);
//die();
$table->addRow(array($image['id_image'], $image['id_product'], $product->name[$context->language->id], $img->getImgPath() . '.' . $img->image_format));
}
$table->display();
return;
}
public static function print_server_info()
{
$context = Context::getContext();
$params_optional_results = ConfigurationTest::check(ConfigurationTest::getDefaultTestsOp());
$table = new Cli\Table();
$table->addRow(array('MySQL version', Db::getInstance()->getVersion()));
$table->addRow(array('MySQL server', _DB_SERVER_));
$table->addRow(array('Database name', _DB_NAME_));
$table->addRow(array('User', _DB_USER_));
$table->addRow(array('Prefix', _DB_PREFIX_));
$table->addRow(array('Engine', _MYSQL_ENGINE_));
$table->addRow(array('PrestaShop version', _PS_VERSION_));
$table->addRow(array('Shop base URL', $context->shop->getBaseURL()));
foreach ($params_optional_results as $key => $value) {
$table->addRow(array($key, $value));
}
$table->display();
}
protected function _listModifiedFiles()
{
$upgrader = new Upgrader();
if (!is_object($upgrader)) {
PS_CLI_Interface::error('Could not load upgrader module');
}
$modifiedFiles = $upgrader->getChangedFilesList(NULL, true);
$table = new Cli\Table();
$table->setHeaders(array('Category', 'File'));
foreach ($modifiedFiles as $category => $filesArray) {
foreach ($filesArray as $id => $file) {
$table->addRow(array($category, $file));
}
}
$table->display();
}
