| Server IP : 52.223.31.75 / Your IP : 172.31.6.220 [ Web Server : Apache/2.4.66 () OpenSSL/1.0.2k-fips PHP/7.4.33 System : Linux ip-172-31-14-81.eu-central-1.compute.internal 4.14.281-212.502.amzn2.x86_64 #1 SMP Thu May 26 09:52:17 UTC 2022 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE Domains : 4 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/ripara.co/ |
Upload File : |
<?php
header("Content-type: text/tab-separated-values");
header("Content-Disposition: attachment; filename=inventario.txt");
header("Pragma: no-cache");
header("Expires: 0");
//session_start();
require_once '/var/www/sync.ripara.co/vendor/autoload.php';
define('HOST', 'piattaforma-formazione-apisoft.cqx18uta8i2i.eu-central-1.rds.amazonaws.com');
define('USER', 'root');
define('PASSWORD', 'qwet324vfsdgweDa21');
define('DATABASE', 'ripara');
$GLOBALS['gtotal']=0;
// if (php_sapi_name() != 'cli') {
// throw new Exception('This application must be run on the command line.');
// }
//_jo
try {
$db = new PDO('mysql:host='.HOST.';dbname='.DATABASE, USER, PASSWORD);
$db->query('SET CHARACTER SET utf8');
//return $db;
} catch (PDOException $e) {
print "Errore in fase di connessione al db!<br><br> " . $e->getMessage() . "<br/>";
die();
}
//index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id='.$product->virtuemart_product_id
//CONCAT ("https://www.portobelloemotion.it/shop/it/component/virtuemart/", jo_virtuemart_products_it_it.slug, "-", prod.virtuemart_product_id) as link,
//CONCAT("prod-",idprodotto) as id,
$query = 'SELECT DISTINCT idprodotto,
idprodotto as id,
nome as title,
CONCAT( REPLACE( CAST(ROUND (prezzo,2) AS CHAR),"." , ",") , " EUR") as price,
descrizione as description,
CONCAT ("https://ripara.co/index.php?page=prodottovendita&id=", idprodotto) as link,
CONCAT ("https://ripara.co/admin/", REPLACE(REPLACE(REPLACE(foto, \'\\\\\',""), \'"]\',"") , \'["\',"") ) as image_link,
quantita as quantity_to_sell_on_facebook,
"Ripara.co" as `brand`,
id_category_google as google_product_category,
id_category_facebook as fb_product_category,
sconto
FROM prodottoinvendita
JOIN categoria_prodottovendita on prodottoinvendita.idcategoria = categoria_prodottovendita.idcategoria
WHERE attivo = 1 AND quantita > 0;';
$da_inserire= [];
$da_inserire[] = ['store_code','id','price', 'quantity'];
$in_arr = [];
//ASSISTENZA
$da_inserire[]=["1", "serv-01", "0,99 EUR", "100"];
foreach($db->query($query) as $prodotto){
if (in_array($prodotto['id'], $in_arr)) {
continue;
}
$in_arr[] = $prodotto['id'];
$da_inserire[]=["1", $prodotto['id'], $prodotto['price'], $prodotto['quantity_to_sell_on_facebook']];
}
for ($i=0; $i < count($da_inserire); $i++) {
//echo $da_inserire[$i]['store_code']."\t".$da_inserire[$i]['id']."\t".$da_inserire[$i]['quantity']."\t".$da_inserire[$i]['price'];
echo implode("\t",$da_inserire[$i]);
echo "\n";
}
die;
?>