/** * @desc Realiza una búsqueda en el módulo desde EXM */ function pwSearch($queryarray, $andor, $limit, $offset, $userid) { global $myts; include_once XOOPS_ROOT_PATH . "/modules/works/class/pwwork.class.php"; $mc = RMUtilities::module_config('works'); $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT a.* FROM " . $db->prefix('pw_works') . " a INNER JOIN " . $db->prefix('pw_clients') . " b ON (a.public=1 AND a.client=b.id_client AND ("; $sql1 = ''; if (is_array($queryarray)) { foreach ($queryarray as $k) { $sql1 .= ($sql1 == '' ? "" : "{$andor}") . " (a.title LIKE '%{$k}%' OR a.short LIKE '%{$k}%' OR b.name LIKE '%{$k}%' OR b.business_name LIKE '%{$k}%') "; } } $sql1 .= "))"; $sql1 .= " GROUP BY a.id_work ORDER BY a.created DESC LIMIT {$offset}, {$limit}"; $result = $db->queryF($sql . $sql1); $ret = array(); while ($row = $db->fetchArray($result)) { $work = new PWWork(); $work->assignVars($row); $rtn = array(); $rtn['image'] = 'images/works.png'; $rtn['title'] = $work->title(); $rtn['time'] = $work->created(); $rtn['uid'] = ''; $rtn['desc'] = $work->descShort(); $rtn['link'] = $work->link(); $ret[] = $rtn; } return $ret; }
public function get_item($params, $com) { static $works; $params = urldecode($params); parse_str($params); if (!isset($work) || $work <= 0) { return __('Not found', 'works'); } if (isset($works[$work])) { $ret = $works[$work]->title(); return $ret; } include_once XOOPS_ROOT_PATH . '/modules/works/class/pwwork.class.php'; $item = new PWWork($work); if ($item->isNew()) { return __('Unknow', 'works'); } $ret = $item->title(); $works[$work] = $item; return $ret; }
/** * Get works based on given parameters */ public function get_works($limit, $category = null, $public = 1, $object = true, $order = "created DESC") { global $xoopsModule, $xoopsModuleConfig; include_once XOOPS_ROOT_PATH . '/modules/works/class/pwwork.class.php'; include_once XOOPS_ROOT_PATH . '/modules/works/class/pwcategory.class.php'; include_once XOOPS_ROOT_PATH . '/modules/works/class/pwclient.class.php'; $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT * FROM " . $db->prefix('pw_works') . " WHERE public={$public}"; $sql .= $category > 0 ? " AND catego='{$category}'" : ''; $sql .= $order != '' ? " ORDER BY {$order}" : ''; $sql .= " LIMIT 0,{$limit}"; if ($xoopsModule && $xoopsModule->dirname() == 'works') { $mc =& $xoopsModuleConfig; } else { $mc = RMUtilities::module_config('works'); } $result = $db->query($sql); $works = array(); while ($row = $db->fetchArray($result)) { $work = new PWWork(); $work->assignVars($row); $ret = array(); if (!isset($categos[$work->category()])) { $categos[$work->category()] = new PWCategory($work->category()); } if (!isset($clients[$work->client()])) { $clients[$work->client()] = new PWClient($work->client()); } $ret = array('id' => $work->id(), 'title' => $work->title(), 'desc' => $work->descShort(), 'catego' => $categos[$work->category()]->name(), 'client' => $clients[$work->client()]->name(), 'link' => $work->link(), 'created' => formatTimeStamp($work->created(), 's'), 'created_time' => $work->created(), 'image' => XOOPS_UPLOAD_URL . '/works/ths/' . $work->image(), 'rating' => PWFunctions::rating($work->rating()), 'featured' => $work->mark(), 'linkcat' => $categos[$work->category()]->link(), 'metas' => $work->get_metas()); if ($object) { $w = new stdClass(); foreach ($ret as $var => $value) { $w->{$var} = $value; } $works[] = $w; } else { $works[] = $ret; } } return $works; }
//Obtenemos los trabajos recientes $sql = "SELECT * FROM " . $db->prefix('pw_works') . " WHERE public=1 ORDER BY created DESC LIMIT {$start},{$limit}"; $result = $db->query($sql); // Numero de resultados en esta página $t = $db->getRowsNum($result); $tpl->assign('page_total', $t); $tpl->assign('per_col', ceil($t / 2)); $categos = array(); $clients = array(); while ($row = $db->fetchArray($result)) { $recent = new PWWork(); $recent->assignVars($row); if (!isset($categos[$recent->category()])) { $categos[$recent->category()] = new PWCategory($recent->category()); } if (!isset($clients[$recent->client()])) { $clients[$recent->client()] = new PWClient($recent->client()); } $tpl->append('works', array('id' => $recent->id(), 'title' => $recent->title(), 'desc' => $recent->descShort(), 'catego' => $categos[$recent->category()]->name(), 'client' => $clients[$recent->client()]->businessName(), 'link' => $recent->link(), 'created' => formatTimeStamp($recent->created(), 's'), 'image' => XOOPS_UPLOAD_URL . '/works/ths/' . $recent->image(), 'rating' => PWFunctions::rating($recent->rating()), 'featured' => $recent->mark(), 'linkcat' => $categos[$recent->category()]->link(), 'metas' => $recent->get_metas())); } $tpl->assign('lang_works', __('Our Work', 'works')); $tpl->assign('lang_catego', __('Cetegory:', 'works')); $tpl->assign('lang_date', __('Date:', 'works')); $tpl->assign('lang_client', __('Customer:', 'works')); $tpl->assign('lang_allsrecent', __('View all recent works', 'works')); $tpl->assign('link_recent', PW_URL . ($mc['urlmode'] ? '/recent/' : '/recent.php')); $tpl->assign('link_featured', PW_URL . ($mc['urlmode'] ? '/featured/' : '/featured.php')); $thSize = $mc['image_ths']; $tpl->assign('width', $thSize[0] + 10); $tpl->assign('lang_featured', __('Featured', 'works')); include 'footer.php';
/** * @desc Formulario de creación/edición de Imágenes **/ function formImages($edit = 0) { global $xoopsModule, $xoopsModuleConfig; $id = rmc_server_var($_REQUEST, 'id', 0); $work = rmc_server_var($_REQUEST, 'work', 0); $page = rmc_server_var($_REQUEST, 'page', 0); $ruta = "&page={$page}"; //Verificamos que el trabajo sea válido if ($work <= 0) { redirectMsg('./works.php', __('You must specify a work ID!', 'works'), 1); die; } //Verificamos que el trabajo exista $work = new PWWork($work); if ($work->isNew()) { redirectMsg('./works.php', __('Specified work does not exists!', 'works'), 1); die; } if ($edit) { //Verificamos que la imagen sea válida if ($id <= 0) { redirectMsg('./images.php?work=' . $work->id() . $ruta, __('You must specify an image ID!', 'works'), 1); die; } //Verificamos que la imagen exista $img = new PWImage($id); if ($img->isNew()) { redirectMsg('./images.php?work=' . $work->id() . $ruta, __('Specified image does not exists!', 'works'), 1); die; } } PWFunctions::toolbar(); RMTemplate::get()->assign('xoops_pagetitle', $work->title() . ' » ' . __('Work Images', 'works')); xoops_cp_location('<a href="./">' . $xoopsModule->name() . "</a> » <a href='./images.php?work=" . $work->id() . "'>" . __('Work Images', 'works') . "</a> »" . ($edit ? __('Edit Image', 'works') : __('Add Image', 'works'))); xoops_cp_header(); $form = new RMForm($edit ? __('Edit Image', 'works') : __('Add Image', 'works'), 'frmImg', 'images.php'); $form->setExtra("enctype='multipart/form-data'"); $form->addElement(new RMFormText(__('Title', 'works'), 'title', 50, 100, $edit ? $img->title() : ''), true); $form->addElement(new RMFormFile(__('Image file', 'works'), 'image', 45, $xoopsModuleConfig['size_image'] * 1024), $edit ? false : true); if ($edit) { $form->addElement(new RMFormLabel(__('Current image file', 'works'), "<img src='" . XOOPS_UPLOAD_URL . "/works/ths/" . $img->image() . "' />")); } $form->addElement(new RMFormTextArea(__('Description', 'works'), 'desc', 4, 50, $edit ? $img->desc() : '')); $form->addElement(new RMFormHidden('op', $edit ? 'saveedit' : 'save')); $form->addElement(new RMFormHidden('id', $id)); $form->addElement(new RMFormHidden('work', $work->id())); $form->addElement(new RMFormHidden('page', $page)); $form->addElement(new RMFormHidden('limit', $limit)); $ele = new RMFormButtonGroup(); $ele->addButton('sbt', _SUBMIT, 'submit'); $ele->addButton('cancel', _CANCEL, 'button', 'onclick="window.location=\'images.php?work=' . $work->id() . $ruta . '\';"'); $form->addElement($ele); $form->display(); xoops_cp_footer(); }
//Categorías $sql = "SELECT COUNT(*) FROM " . $db->prefix('pw_categos'); list($categories) = $db->fetchRow($db->query($sql)); //Tipos de Cliente $sql = "SELECT COUNT(*) FROM " . $db->prefix('pw_types'); list($types) = $db->fetchRow($db->query($sql)); //Clientes $sql = "SELECT COUNT(*) FROM " . $db->prefix('pw_clients'); list($customers) = $db->fetchRow($db->query($sql)); //Trabajos $sql = "SELECT COUNT(*) FROM " . $db->prefix('pw_works'); list($works) = $db->fetchRow($db->query($sql)); // IMages $sql = "SELECT COUNT(*) FROM " . $db->prefix('pw_images'); list($images) = $db->fetchRow($db->query($sql)); // Works not published $sql = "SELECT * FROM " . $db->prefix('pw_works') . " WHERE public=0 ORDER BY id_work DESC LIMIT 0,5"; $result = $db->query($sql); $works_pending = array(); while ($row = $db->fetchArray($result)) { $work = new PWWork(); $work->assignVars($row); $works_pending[] = array('id' => $work->id(), 'title' => $work->title(), 'desc' => $work->descShort(), 'date' => formatTimestamp($work->created(), 'c')); } xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a>"); RMTemplate::get()->add_style('admin.css', 'works'); RMTemplate::get()->add_style('dashboard.css', 'works'); RMTemplate::get()->set_help('http://redmexico.com.mx/docs/professional-works'); xoops_cp_header(); include RMTemplate::get()->get_template("admin/pw_index.php", 'module', 'works'); xoops_cp_footer();
$sql = "SELECT * FROM " . $db->prefix('pw_works') . " WHERE public=1 AND catego=" . $work->category() . " AND id_work<>'" . $work->id() . "' ORDER BY RAND() LIMIT 0," . $mc['num_otherworks']; } $result = $db->query($sql); $categos = array(); $clients = array(); while ($row = $db->fetchArray($result)) { $wk = new PWWork(); $wk->assignVars($row); if (!isset($categos[$wk->category()])) { $categos[$wk->category()] = new PWCategory($wk->category()); } if (!isset($clients[$wk->client()])) { $clients[$wk->client()] = new PWClient($wk->client()); } echo "1 - "; $tpl->append('other_works', array('id' => $wk->id(), 'title' => $wk->title(), 'desc' => $wk->descShort(), 'linkcat' => $categos[$wk->category()]->link(), 'catego' => $categos[$wk->category()]->name(), 'client' => $clients[$wk->client()]->name(), 'link' => $wk->link(), 'created' => formatTimeStamp($wk->created(), 's'), 'image' => XOOPS_UPLOAD_URL . '/works/ths/' . $wk->image(), 'views' => $wk->views(), 'metas' => $wk->get_metas())); } RMEvents::get()->run_event('works.load.other.works', $work); } $tpl->assign('lang_desc', __('Description', 'works')); $tpl->assign('lang_catego', __('Category', 'works')); $tpl->assign('lang_client', __('Customer', 'admin_works')); $tpl->assign('lang_start', __('Begins', 'works')); $tpl->assign('lang_period', __('Time length', 'works')); $tpl->assign('lang_comment', __('Comment', 'works')); $tpl->assign('lang_cost', __('Price', 'works')); $tpl->assign('lang_others', __('Related Works', 'works')); $tpl->assign('lang_date', __('Date', 'works')); $tpl->assign('lang_images', __('Work Images', 'works')); $tpl->assign('lang_site', __('Web site', 'works')); $tpl->assign('lang_mark', __('Featured', 'works'));
function pw_works_show($options) { global $xoopsModule, $xoopsModuleConfig; include_once XOOPS_ROOT_PATH . '/modules/works/class/pwwork.class.php'; include_once XOOPS_ROOT_PATH . '/modules/works/class/pwclient.class.php'; include_once XOOPS_ROOT_PATH . '/modules/works/class/pwcategory.class.php'; $db = XoopsDatabaseFactory::getDatabaseConnection(); if (isset($xoopsModule) && $xoopsModule->dirname() == 'works') { $mc =& $xoopsModuleConfig; } else { $mc =& RMUtilities::module_config('works'); } $sql = "SELECT * FROM " . $db->prefix('pw_works') . ' WHERE public=1'; $sql1 = $options[1] ? " AND catego='" . $options[1] . "'" : ''; $sql2 = $options[2] ? " AND client='" . $options[2] . "'" : ''; $sql3 = ''; switch ($options[0]) { case 0: $sql3 .= " ORDER BY RAND()"; break; case 1: $sql3 .= ($sql1 || $sql2 ? " AND " : " WHERE ") . " mark=1 ORDER BY RAND()"; break; case 2: $sql3 .= " ORDER BY created DESC "; break; } $sql3 .= " LIMIT 0," . $options[3]; $result = $db->query($sql . $sql1 . $sql2 . $sql3); $clients = array(); $categos = array(); while ($row = $db->fetchArray($result)) { $work = new PWWork(); $work->assignVars($row); if (!isset($clients[$work->client()])) { $clients[$work->client()] = new PWClient($work->client(), 1); } $client =& $clients[$work->client()]; if (!isset($categos[$work->category()])) { $categos[$work->category()] = new PWCategory($work->category(), 1); } $cat =& $categos[$work->category()]; $rtn = array(); $rtn['title'] = $work->title(); if ($options[6]) { $rtn['desc'] = substr($work->descShort(), 0, 50); } $rtn['link'] = $work->link(); $rtn['created'] = formatTimestamp($work->created(), 's'); if ($options[5]) { $rtn['image'] = XOOPS_UPLOAD_URL . '/works/ths/' . $work->image(); } $linkcat = XOOPS_URL . '/modules/works/' . ($mc['urlmode'] ? 'cat/' . $cat->nameId() : 'catego.php?id=' . $cat->nameId()); $rtn['cat'] = sprintf(__('Category: %s', 'works'), '<a href="' . $cat->link() . '">' . $cat->name() . '</a>'); $rtn['client'] = sprintf(__('Customer: %s', 'works'), $client->businessName()); $block['works'][] = $rtn; } $block['cols'] = $options[4]; $block['showdesc'] = $options[6]; $block['showimg'] = $options[5]; return $block; }
/** * @desc Elimina de la base de datos la información del trabajo **/ function deleteWorks() { global $xoopsSecurity, $xoopsModule; $ids = rmc_server_var($_POST, 'ids', 0); $page = rmc_server_var($_POST, 'page', 1); $show = rmc_server_var($_POST, 'show', 1); $ruta = "pag={$page}&show={$show}"; //Verificamos que nos hayan proporcionado un trabajo para eliminar if (!is_array($ids)) { redirectMsg('./works.php?' . $ruta, __('You must select a work at least!', 'works'), 1); die; } if (!$xoopsSecurity->check()) { redirectMsg('./works.php?' . $ruta, __('Session token expired!', 'works'), 1); die; } $errors = ''; foreach ($ids as $k) { //Verificamos si el trabajo es válido if ($k <= 0) { $errors .= sprintf(__('Work ID "%s" is not valid!', 'works'), $k); continue; } //Verificamos si el trabajo existe $work = new PWWork($k); if ($work->isNew()) { $errors .= sprintf(__('Work with ID "%s" does not exists!', 'works'), $k); continue; } if (!$work->delete()) { $errors .= sprintf(__('Work "%s" could not be deleted!', 'works'), $work->title()); } } if ($errors != '') { redirectMsg('./works.php?' . $ruta, __('Errors ocurred while trying to delete works', 'works') . '<br />' . $errors, 1); die; } else { redirectMsg('./works.php?' . $ruta, __('Works deleted successfully!', 'works'), 0); die; } }