chuliano Posted April 10, 2015 Share Posted April 10, 2015 Hello, I have a question.A few years ago I developed a list of automatic prodcutos with coin dollars and pesos (currency of my country) to cubecart 4. my question is, how can I transfer it to cubecart 5 ???This is the full code<style> .style_titulos { background-color: #CEDFFF; color: #000; border-color: #FF0000; /*text-transform:uppercase;*/ text-decoration: none; border-width: 0px; background-repeat: repeat-x; font-size: 16px; } .style_activado { background-color: #7C7C7C; color: #FFF; border-color: #000000; border-width: 1px; text-decoration: none; text-indent:10px; font-size: small; } .style_activado a{ text-decoration: none; color: #FFF; } .style_desactivado { background-color: #7C7C7C; color: #B6B6B6; border-color: #000000; border-width: 1px; text-indent:10px; font-size: small; text-decoration: line-through; } .style_desactivado a { text-decoration: line-through; color: #B6B6B6; } a:visited { color: #FFFC; } a:hover { color: #EA9900; } </style> <?php ob_start(); ////////////////////////////////////////////////////// if(!defined('CC_INI_SET')){ die("Access Denied"); } permission("statistics", 'read', true); require($glob['adminFolder'].CC_DS."includes".CC_DS."header.inc.php"); ///////////////////////////////////////// require_once ("ini.inc.php"); // archivo ini, sin zlib.output_compression ini.inc.php propio require_once ("includes".CC_DS."global.inc.php"); require_once ("includes".CC_DS."functions.inc.php"); require_once ("classes".CC_DS."db".CC_DS."db.php"); //////////////////////// // BUILD SUB CATEGORIES //////////////////////// $query = "SELECT productId, ".$glob['dbprefix']."CubeCart_inventory.cat_id, name, cat_name, date_added, price, disabled, sale_price, useStockLevel, stock_level, productCode FROM ".$glob['dbprefix']."CubeCart_inventory INNER JOIN ".$glob['dbprefix']."CubeCart_category ON ".$glob['dbprefix']."CubeCart_inventory.cat_id = ".$glob['dbprefix']."CubeCart_category.cat_id ORDER BY cat_name ASC, price ASC, name ASC"; $db = new db(); $products = $db->select($query); $simbolo = " $"; // pesos $simboloD = " uSs"; // dolares //////////////////////////// // carga monedas require($glob['adminFolder'].CC_DS."includes".CC_DS."cotizacion.inc.php"); // fin moneda //////////////////////////// $coti = $currencies[0]['value']; $PESOS = number_format($coti, 2, ',', ' '); // con solo 2 decimales ///////////////////////////////////////////////////////////// echo "<table width="100%" border="0" cellpadding="3" cellspacing="1" class="mainTable">"; echo "<tr>"; echo "<td colspan="2" class="tdTitle">Estadisticas de productos - precio - stock - valorizado</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan="2">"; echo "<ul>"; echo "<li><a href="http://www.nickhard.com.ar/tienda/admin.php?_g=stats/index" class="txtLink"><< Volver</a></li>"; echo "</ul>"; echo "</td>"; echo "</tr>"; echo "</table>"; ///////////////////////////////////////////////////////////// echo "<table class="style_titulos" style="width: 100%" border="1" id="Exportar_a_Excel">"; echo "<tr>"; echo "<td class="style_activado" width="100%" colspan="6">LISTADO DE PRECIOS USO INTERNO - Cotización: ".$simbolo." ".$PESOS."</td>"; echo "</tr>"; for ($i=0; $i<count($products); $i++){ if($products[$i]['cat_id']!==$products[$i-1]['cat_id']){ echo "<tr bgcolor="#FFFFE1">"; echo "<td class="style_titulos"> :: ".$products[$i]['cat_name']."</td>"; //echo "<td class="style_titulos">Precio".$simbolo." (Pesos)<h style="color:red" >Oferta</h></td>"; echo "<td class="style_titulos">Precio".$simbolo." (Pesos)</td>"; echo "<td class="style_titulos">Stock</td>"; echo "<td class="style_titulos">Valorizado de stock</td>"; echo "</tr>"; echo "<tr>"; } /////////////////////////////// // COMIENZO DEL IF RPINCIPAL // /////////////////////////////// //////////////////////////////////////////////////// // SI EL STOCK ES 0 ENTONCES NO CREA NINGUNA FILA // //////////////////////////////////////////////////// //echo "<td id="6" style="background-color: #FFFFE1; color: #FF0000; font-weight: bold; font-size: small">".substr(strip_tags($products[$i]['name']), 0, 85)."... (NO/FUERA DE STOCK)"."</td>"; ////////////////////////////////////////////////////////// // COMIENZO SI EL STOCK ES 1 O MAYOR A 1 ENTONCES CREA LAS FILAS // ////////////////////////////////////////////////////////// //////////////////////////// // COMIENZO DEL IF OFERTA // //////////////////////////// // if($products[$i]['disabled']){ if($products[$i]['stock_level']<="0"){ ////////////////////////////////////////// // Fin productos desactivados // si el producto esta desactivado // directamente no se muestra en la lista ////////////////////////////////////////// } else if(!$products[$i]['disabled']){ echo "<td class="style_activado" ><a target="_blank" href="http://nickhard.com.ar/tienda/index.php?_a=viewProd&productId=".$products[$i]['productId']."">".substr(strip_tags($products[$i]['name']), 0, 125)."..."."</a></td>"; // FILA PRODUCTO // solo ver un precio, oferta o fijo. ////////////////////////////////////////// //echo "<td class="style_activado">".$simbolo." ".round($products[$i]['price']*$coti)." (".$simbolo." ".round($products[$i]['sale_price']*$coti).")</td>"; // FILA PRECIO if($products[$i]['sale_price']<="0"){ echo "<td class="style_activado">".$simbolo." ".round($products[$i]['price']*$coti)."</td>"; // FILA PRECIO }else{ //echo "<td class="style_activado" style="color:red">".$simbolo." ".round($products[$i]['sale_price']*$coti)."</td>"; // FILA PRECIO echo "<td class="style_activado">".$simbolo." ".round($products[$i]['sale_price']*$coti)." (Oferta)</td>"; // FILA PRECIO } // solo ver un precio, oferta o fijo. ////////////////////////////////////////// echo "<td class="style_activado">".$products[$i]['stock_level']."</td>"; // FILA PRICE // valorizado if($products[$i]['sale_price']<="0"){ echo "<td class="style_activado">".$simbolo." ".round($products[$i]['price']*$coti)*$products[$i]['stock_level']."</td>"; // FILA PRICE }else{ //echo "<td class="style_activado" style="color:red">".$simbolo." ".round($products[$i]['sale_price']*$coti)."</td>"; // FILA PRECIO echo "<td class="style_activado">".$simbolo." ".round($products[$i]['sale_price']*$coti)*$products[$i]['stock_level']."</td>"; // FILA PRICE } // valorizado /*activado desactivados funciona */ } echo "</tr>"; } echo "</table>"; ////////////////////////////////////////////// ?> <style> .navTitle2 { padding: 0px; font-size: 12px; } </style> Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted April 10, 2015 Share Posted April 10, 2015 I would suggest completely redeveloping it using hooks... https://support.cubecart.com/index.php?/Knowledgebase/Article/View/203/46/how-can-i-create-a-plugin-using-the-code-hooks-system-in-cubecart-v5 Quote Link to comment Share on other sites More sharing options...
chuliano Posted April 10, 2015 Author Share Posted April 10, 2015 I would suggest completely redeveloping it using hooks... https://support.cubecart.com/index.php?/Knowledgebase/Article/View/203/46/how-can-i-create-a-plugin-using-the-code-hooks-system-in-cubecart-v5i try, but is very difficult..https://www.youtube.com/watch?v=MG_tHmL2Oug haha Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.