PHP FSS_Helper::TableExists方法代码示例

 function display($tpl = null)
 {
     JToolBarHelper::title(JText::_("PRODUCTS"), 'fss_prods');
     JToolBarHelper::deleteList();
     JToolBarHelper::editList();
     JToolBarHelper::addNew();
     JToolBarHelper::divider();
     if (FSS_Helper::TableExists("#__virtuemart_products_en_gb") || FSS_Helper::TableExists("#__vm_product")) {
         JToolBarHelper::custom('import_vm', 'copy', 'copy', 'IMPORT_FROM_VIRTUEMART', false);
     }
     if (FSS_Helper::TableExists("#__hikashop_product")) {
         JToolBarHelper::custom('import_hs', 'copy', 'copy', 'Import From Hika Shop', false);
     }
     JToolBarHelper::cancel('cancellist');
     FSSAdminHelper::DoSubToolbar();
     $this->lists = $this->get('Lists');
     $this->data = $this->get('Data');
     $this->pagination = $this->get('Pagination');
     $categories = array();
     $categories[] = JHTML::_('select.option', '-1', JText::_("IS_PUBLISHED"), 'id', 'title');
     $categories[] = JHTML::_('select.option', '1', JText::_("PUBLISHED"), 'id', 'title');
     $categories[] = JHTML::_('select.option', '0', JText::_("UNPUBLISHED"), 'id', 'title');
     $this->lists['published'] = JHTML::_('select.genericlist', $categories, 'ispublished', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'id', 'title', $this->lists['ispublished']);
     $what = JRequest::getVar('what');
     if ($what == "togglefield") {
         return $this->toggleField();
     }
     parent::display($tpl);
 }

 function CanEnable()
 {
     if (FSS_Helper::TableExists("#__uddeim")) {
         return true;
     }
     return "uddeIM not installed";
 }

 function ImportHikaShop()
 {
     $log = "";
     // check that the vm products table exists and has products in it
     $tablename = "#__hikashop_product";
     $pid = "product_id";
     $ver = 2;
     if (!FSS_Helper::TableExists($tablename)) {
         $log = "No HikaShop installation found\n";
         return $log;
     }
     $db = JFactory::getDBO();
     $qry = "SELECT count(*) FROM {$tablename}";
     $db->setQuery($qry);
     $result = $db->loadResult();
     if ($result == 0) {
         $log = "No HikaShop products found, aborting\n";
         return $log;
     }
     $qry = "SELECT MAX(ordering)+1 as neworder FROM #__fss_prod";
     $db->setQuery($qry);
     $order = $db->loadResult();
     $qry = "SELECT * FROM {$tablename} WHERE product_parent_id = 0 ORDER BY product_name";
     if ($ver == 2) {
         $qry = "SELECT p.*, m.file_path FROM {$tablename} as p \n\n\t\t\t\tLEFT JOIN #__hikashop_file as m \n\t\t\t\tON p.product_id = m.file_ref_id\n\n\t\t\t\tWHERE product_parent_id = 0 \n\t\t\t\t\n\t\t\t\tGROUP BY p.product_id\n\t\t\t\t\n\t\t\t\tORDER BY product_name  \n\n\t\t\t\t";
     }
     $db->setQuery($qry);
     $products = $db->loadObjectList();
     $log .= "Synchroizing " . count($products) . " Hika Shop products\n";
     $pids = array();
     // check for any removed products
     $qry = "SELECT * FROM #__fss_prod WHERE import_id > 0";
     $db->setQuery($qry);
     $existingproducts = $db->loadObjectList('import_id');
     $sourcepath = JPATH_SITE . DS . 'media' . DS . 'com_hikashop' . DS . 'upload';
     $destbase = JPATH_SITE . DS . 'images' . DS . 'fss' . DS . 'products';
     // get existing file list
     $existingfiles = array();
     if (is_dir($destbase)) {
         if ($dh = opendir($destbase)) {
             while (($file = readdir($dh)) !== false) {
                 if ($file == "." || $file == "..") {
                     continue;
                 }
                 $existingfiles[$file] = $file;
             }
             closedir($dh);
         }
     }
     // products:
     /**
      * product_name - title
      * product_s_desc - description
      * product_full_image - image file
      **/
     foreach ($products as $product) {
         // check for existing product
         $existing = null;
         if (array_key_exists($product->{$pid}, $existingproducts)) {
             $existing = $existingproducts[$product->{$pid}];
         }
         // import image
         $pids[$product->{$pid}] = $product->{$pid};
         // check if the image exists or not
         $imagesource = $product->file_path;
         $fin = pathinfo($imagesource);
         $destfile = $fin['basename'];
         $order = 1;
         if ($existing) {
             if ($product->product_name != $existing->title || $product->product_description != $existing->description || $destfile != $existing->image) {
                 $log .= "Product '{$product->product_name}' already exists, updating\n";
                 $qry = "UPDATE #__fss_prod SET title = '" . FSSJ3Helper::getEscaped($db, $product->product_name) . "', description = '" . FSSJ3Helper::getEscaped($db, $product->product_description) . "', image = '" . FSSJ3Helper::getEscaped($db, $destfile) . "' WHERE id = '{$existing->id}'";
                 $db->setQuery($qry);
                 $db->query();
             }
         } else {
             $log .= "Adding product '{$product->product_name}'\n";
             $qry = "INSERT INTO #__fss_prod (import_id, title, description, image, published, ordering, inkb, insupport, intest, access) VALUES (";
             $qry .= $product->{$pid} . ", ";
             $qry .= "'" . FSSJ3Helper::getEscaped($db, $product->product_name) . "', ";
             $qry .= "'" . FSSJ3Helper::getEscaped($db, $product->product_description) . "', ";
             $qry .= "'" . FSSJ3Helper::getEscaped($db, $destfile) . "', ";
             $qry .= "1, {$order}, 1, 1, 1, 1)";
             $order++;
         }
         $db->setQuery($qry);
         $db->Query();
         // not existing, so make a new resized image for this product
         if ($imagesource && !array_key_exists($destfile, $existingfiles)) {
             $log .= "Copying and resizing image {$imagesource} for product '{$product->product_name}'\n";
             if (!$this->image_resize($sourcepath . DS . $imagesource, $destbase . DS . $destfile, 64, 64, 0)) {
                 copy($sourcepath . DS . $imagesource, $destbase . DS . $destfile);
             }
         }
     }
     foreach ($existingproducts as $product) {
         if (!array_key_exists($product->import_id, $pids)) {
             $log .= "Removing product {$product->title}\n";
             $qry = "DELETE FROM #__fss_prod WHERE id = " . FSSJ3Helper::getEscaped($db, $product->id);
             $db->setQuery($qry);
//.........这里部分代码省略.........

 function dropTable($table)
 {
     $db = JFactory::getDBO();
     if (FSS_Helper::TableExists($table)) {
         $db->setQuery("DROP TABLE {$table}");
         $db->query();
         return "Removing {$table}<br>";
     }
     return "";
 }