Jump to content

patrocine

Members
  • Content count

    12
  • Joined

  • Last visited

  • Days Won

    1

patrocine last won the day on March 6

patrocine had the most liked content!

1 Follower

About patrocine

  • Rank
    Empresa 3.0
  • Birthday 08/27/1976

Profile Information

  • Real Name
    Antonio Miranda
  • Location
    Spain, Tenerife
  • Interests
    Empresa 3.0
  • Website

Recent Profile Visitors

1,976 profile views
  1. patrocine

    Marketplace features

    Enterprise 3.0 OsCommerce is a billing system integrated into the company that allows the billing (TPV) to synchronize the stock of the entire online store, it is very powerful and very easy to learn to use, it has several systems that enhance advertising "Banner Shop to Shop" and "Shared Stock" this system has no limits. Facebook, google, twitter, youtube, they are not used to advertise, I am a 3.0 company I do not need to pay money to get clients, if the service that my company provides is good and the clients are happy then all the stores want to advertise with me, that's how it works We are Empresa 3.0, the company of Web 3.0 value All those who want an online store Empresa 3.0 OsCommerce I give it to you with domain and hosting included. Send me the name you want and I'll send you the data of your hosting company30com@gmail.com and you can use it 100% You can Play here with a demo. http://demostracion007.enterprise30.es http://admin007.enterprise30.es user: tienda pass: admin tutorial https://www.youtube.com/channel/UCN08DeaxFjPcaEdoZU64ZAQ/playlists OSCOMMERCE HAS TO EVOLVED TO WEB 3.0
  2. patrocine

    Enterprise 3.0 OsCommerce

    You can Play here with a demo. http://demostracion007.enterprise30.es http://admin007.enterprise30.es user: tienda pass: admin tutorial https://www.youtube.com/channel/UCN08DeaxFjPcaEdoZU64ZAQ/playlists
  3. patrocine

    Banner advertising marketing shop-to-shop

    You can Play here with a demo. http://demostracion007.enterprise30.es http://admin007.enterprise30.es user: tienda pass: admin tutorial https://www.youtube.com/channel/UCN08DeaxFjPcaEdoZU64ZAQ/playlists
  4. patrocine

    Banner advertising marketing shop-to-shop

    The Shop-to-shop banner can be easily adapted to all versions and is a very powerful advertising system that consumes a lot of data transfer. I have version 2.3.1 PHP 5.1 I have an old version because I did the program many years ago and I invoice in a physical store with it and I sell online. It has an integrated system that is very easy to use, osc23 is super fast and the current version does not It helps me run my business. https://apps.oscommerce.com/Bs315&enterprise-3-0-oscommerce Enterprise 3.0 is a very advanced system and very easy to use, I cannot change.
  5. This contribution allows you to share shop-to-shop advertising, with an automatic banner that is created with your products. I am looking for help to develop the contribution and we can share advertising with a single click shop to shop https://apps.oscommerce.com/gz8Zp&banner-advertising-marketing-shop-to-sho
  6. patrocine

    Enterprise 3.0 OsCommerce

    Contribution developed for online and offline billing, real stock control of all products only with billing. The system is very large, it began to be created with the first versions of oscommerce 2.2 and over time more than 200 companies have developed it, Empresa 3.0 is a billing system that offers many ways to interact with the customer. Enterprise 3.0 OsCommerce highlights ADVERTISING Banner Shop-to-shop Share Stock between equal stores, create a network of stores Points Program Coupons Discounts BILLING Online billing in POS store Online billing web orders CATALOGS Control product information, Registration, Delete and Modify. Control of products by excel and form simultaneously. Easy to use and understand program contribution tracking https://apps.oscommerce.com/Bs315&enterprise-3-0-oscommerce Tutoriales
  7. Os dejo el vídeo del resultado conseguido. El proveedor se encarga del mantenimiento de los catalogos y configurando la ruta donde esta el archivo las tiendas solo de pulsar un link para sincronizarlos.
  8. Ya encontre la solución. BORRAR EL CODIGO QUE ESTA EN ROJO Cambiar el código que esta en verde por el morado Para que el listado del proveedor ESTE ES EL CODIGO QUE SUBE Y EJECUTA EL ARCHIVO ------------------------------------------------------------------------- <?php $usrfl_name = $HTTP_POST_FILES['usrfl']['name']; $usrfl_size = $HTTP_POST_FILES['usrfl']['size']; $usrfl = $HTTP_POST_FILES['usrfl']['tmp_name']; if ($localfile or (is_uploaded_file($usrfl) && $split==0)) { //******************************* //******************************* // UPLOAD AND INSERT FILE //******************************* //******************************* if ($usrfl){ // move the file to where we can work with it $file = tep_get_uploaded_file('usrfl'); if (is_uploaded_file($file['tmp_name'])) { tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir); } echo "<p class=smallText>"; echo "File uploaded. <br>"; echo "Temporary filename: " . $usrfl . "<br>"; echo "User filename: " . $usrfl_name . "<br>"; echo "Size: " . $usrfl_size . "<br>"; // get the entire file into an array //este codigo $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name); //Cambiar por la ruta donde este el archivo de productos. $readed = file('http://dominio.com/temp/prueba.txt'); } if ($localfile){ // move the file to where we can work with it $file = tep_get_uploaded_file('usrfl'); $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id"; $attribute_options_values = tep_db_query($attribute_options_query); $attribute_options_count = 1; //while ($attribute_options = tep_db_fetch_array($attribute_options_values)){ if (is_uploaded_file($file['tmp_name'])) { tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir); } echo "<p class=smallText>"; echo "Filename: " . $localfile . "<br>"; // get the entire file into an array $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $localfile); } // now we string the entire thing together in case there were carriage returns in the data $newreaded = ""; foreach ($readed as $read){ $newreaded .= $read; } // now newreaded has the entire file together without the carriage returns. // if for some reason excel put qoutes around our EOREOR, remove them then split into rows $newreaded = str_replace('"EOREOR"', 'EOREOR', $newreaded); $readed = explode( $separator . 'EOREOR',$newreaded); // Now we'll populate the filelayout based on the header row. $theheaders_array = explode( $separator, $readed[0] ); // explode the first row, it will be our filelayout $lll = 0; $filelayout = array(); foreach( $theheaders_array as $header ){ $cleanheader = str_replace( '"', '', $header); // echo "Fileheader was $header<br><br><br>"; $filelayout[ $cleanheader ] = $lll++; // } unset($readed[0]); // we don't want to process the headers with the data // now we've got the array broken into parts by the expicit end-of-row marker. array_walk($readed, 'walk'); } if (is_uploaded_file($usrfl) && $split==1) { //******************************* //******************************* // UPLOAD AND SPLIT FILE //******************************* //******************************* // move the file to where we can work with it $file = tep_get_uploaded_file('usrfl'); //echo "Trying to move file..."; if (is_uploaded_file($file['tmp_name'])) { tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir); } $infp = fopen(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name, "r"); //toprow has the field headers $toprow = fgets($infp,32768); $filecount = 1; echo "Creating file EP_Split" . $filecount . ".txt ... "; $tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "EP_Split" . $filecount . ".txt"; $fp = fopen( $tmpfname, "w+"); fwrite($fp, $toprow); $linecount = 0; $line = fgets($infp,32768); while ($line){ // walking the entire file one row at a time // but a line is not necessarily a complete row, we need to split on rows that have "EOREOR" at the end $line = str_replace('"EOREOR"', 'EOREOR', $line); fwrite($fp, $line); if (strpos($line, 'EOREOR')){ // we found the end of a line of data, store it $linecount++; // increment our line counter if ($linecount >= $maxrecs){ echo "Added $linecount records and closing file... <Br>"; $linecount = 0; // reset our line counter // close the existing file and open another; fclose($fp); // increment filecount $filecount++; echo "Creating file EP_Split" . $filecount . ".txt ... "; $tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "EP_Split" . $filecount . ".txt"; //Open next file name $fp = fopen( $tmpfname, "w+"); fwrite($fp, $toprow); } } $line=fgets($infp,32768); } echo "Added $linecount records and closing file...<br><br> "; fclose($fp); fclose($infp); echo "You can download your split files in the Tools/Files under /catalog/temp/"; }
  9. Ejmplo dominio.com/admin/easypopulate.php?url=listadeprecios.txt
  10. ------------------------------------------------------------------------------------------------------------------------------- Actualmente subo la lista de productos en la base de datos con el formulario. La pregunta es ¿que tengo que cambiar en el código para subir los ficheros desde una URL? -------------------------------------------------------------------------------------------------------------------------------- Imaginemos que mi proveedor me facilita el archivo ya preparado con todos los productos, imágenes etc... y es el quien lo tiene sincronizado. Configurando una url, el programa todos los días a la hora que yo quiera lo sube a la base de datos sincronizando con el proveedor.
  11. Actualmente subo la lista de productos en la base de datos con el formulario. La pregunta es ¿que tengo que cambiar en el código para subir los ficheros desde una URL? ESTE ES EL FORMULARIO <table width="75%" border="2"> <tr> <td width="75%"> <FORM ENCTYPE="multipart/form-data" ACTION="easypopulate.php?split=0" METHOD=POST> <p> <div align = "left"> <p><b>Subir Catalogo a la base de datos</b></p> <p> <INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="100000000"> <p></p> <input name="usrfl" type="file" size="50"> <input type="submit" name="buttoninsert" value="Insertar en BD"> <br> </p> </div> </form> ESTE ES EL CODIGO QUE SUBE Y EJECUTA EL ARCHIVO ------------------------------------------------------------------------- <?php $usrfl_name = $HTTP_POST_FILES['usrfl']['name']; $usrfl_size = $HTTP_POST_FILES['usrfl']['size']; $usrfl = $HTTP_POST_FILES['usrfl']['tmp_name']; if ($localfile or (is_uploaded_file($usrfl) && $split==0)) { //******************************* //******************************* // UPLOAD AND INSERT FILE //******************************* //******************************* if ($usrfl){ // move the file to where we can work with it $file = tep_get_uploaded_file('usrfl'); if (is_uploaded_file($file['tmp_name'])) { tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir); } echo "<p class=smallText>"; echo "File uploaded. <br>"; echo "Temporary filename: " . $usrfl . "<br>"; echo "User filename: " . $usrfl_name . "<br>"; echo "Size: " . $usrfl_size . "<br>"; // get the entire file into an array $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name); } if ($localfile){ // move the file to where we can work with it $file = tep_get_uploaded_file('usrfl'); $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id"; $attribute_options_values = tep_db_query($attribute_options_query); $attribute_options_count = 1; //while ($attribute_options = tep_db_fetch_array($attribute_options_values)){ if (is_uploaded_file($file['tmp_name'])) { tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir); } echo "<p class=smallText>"; echo "Filename: " . $localfile . "<br>"; // get the entire file into an array $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $localfile); } // now we string the entire thing together in case there were carriage returns in the data $newreaded = ""; foreach ($readed as $read){ $newreaded .= $read; } // now newreaded has the entire file together without the carriage returns. // if for some reason excel put qoutes around our EOREOR, remove them then split into rows $newreaded = str_replace('"EOREOR"', 'EOREOR', $newreaded); $readed = explode( $separator . 'EOREOR',$newreaded); // Now we'll populate the filelayout based on the header row. $theheaders_array = explode( $separator, $readed[0] ); // explode the first row, it will be our filelayout $lll = 0; $filelayout = array(); foreach( $theheaders_array as $header ){ $cleanheader = str_replace( '"', '', $header); // echo "Fileheader was $header<br><br><br>"; $filelayout[ $cleanheader ] = $lll++; // } unset($readed[0]); // we don't want to process the headers with the data // now we've got the array broken into parts by the expicit end-of-row marker. array_walk($readed, 'walk'); } if (is_uploaded_file($usrfl) && $split==1) { //******************************* //******************************* // UPLOAD AND SPLIT FILE //******************************* //******************************* // move the file to where we can work with it $file = tep_get_uploaded_file('usrfl'); //echo "Trying to move file..."; if (is_uploaded_file($file['tmp_name'])) { tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir); } $infp = fopen(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name, "r"); //toprow has the field headers $toprow = fgets($infp,32768); $filecount = 1; echo "Creating file EP_Split" . $filecount . ".txt ... "; $tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "EP_Split" . $filecount . ".txt"; $fp = fopen( $tmpfname, "w+"); fwrite($fp, $toprow); $linecount = 0; $line = fgets($infp,32768); while ($line){ // walking the entire file one row at a time // but a line is not necessarily a complete row, we need to split on rows that have "EOREOR" at the end $line = str_replace('"EOREOR"', 'EOREOR', $line); fwrite($fp, $line); if (strpos($line, 'EOREOR')){ // we found the end of a line of data, store it $linecount++; // increment our line counter if ($linecount >= $maxrecs){ echo "Added $linecount records and closing file... <Br>"; $linecount = 0; // reset our line counter // close the existing file and open another; fclose($fp); // increment filecount $filecount++; echo "Creating file EP_Split" . $filecount . ".txt ... "; $tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "EP_Split" . $filecount . ".txt"; //Open next file name $fp = fopen( $tmpfname, "w+"); fwrite($fp, $toprow); } } $line=fgets($infp,32768); } echo "Added $linecount records and closing file...<br><br> "; fclose($fp); fclose($infp); echo "You can download your split files in the Tools/Files under /catalog/temp/"; } --------------------------------------------------------------------- Para llegar al archivo easypopulate.php 1º Entra en www.PatroCine.es 2º Descargar OsCommerce Empresa 3.0 La ruta del archivo es /catalog231/admin/easypopulate.php
×