-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathtest.php
124 lines (107 loc) · 4.59 KB
/
test.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
require_once __DIR__ . '/app/DB.php';
require_once __DIR__ . '/class/AmazonConnection.php';
$amazon = new AmazonConnection();
$db = DB::init()->getDB();
$query = "SELECT p.ID,m.meta_value FROM wp_pwgb_posts as p
INNER JOIN wp_pwgb_postmeta as m ON p.ID = m.post_id
WHERE m.meta_key = 'asin' LIMIT 0,278";
$pdo = $db->prepare($query);
$pdo->execute();
$response = $pdo->fetchAll(PDO::FETCH_ASSOC);
foreach ($response as $post) {
$precio = $amazon->getPriceAmazonApi($post['meta_value']);
if(!is_numeric($precio)){
$precio="No disponible";
}
// algo hace el scrapping que tira el precio de amazon, debemos quitar la obtencion del precio de amazon en el scraping , esta parte de update no se hara solo es para corregir lo que pide max
echo "UPDATE wp_pwgb_postmeta SET meta_value = '". $precio . "' WHERE post_id = " . $post['ID'] ." AND meta_key = 'price_amazon'"."<br>";
// ESTO SI HAY QUE IMPLEMENTARLO
// actualizar mejor precioe y cambiar lo del mejor precio que se tiene a lo que pondre abajo obvio ahi si se ejcutarian los querys aqui los imprimo
$queryPrecios = "SELECT post_id,meta_key,meta_value FROM wp_pwgb_postmeta WHERE meta_key
in('price_amazon','price_sanborns','price_linio','price_claroshop','price_coppel','price_sears','price_bestbuy','price_walmart','price_liverpool','price_office_max','price_office_depot','price_palacio','price_soriana','price_elektra','price_sony','price_costco','price_radioshack')
AND post_id = :id";
$pdo = $db->prepare($queryPrecios);
$pdo->bindParam(":id",$post['ID']);
$pdo->execute();
$precios = $pdo->fetchAll(PDO::FETCH_ASSOC);
$mejor_precio = 0;
$price_shop = '';
foreach ($precios as $precio) {
$precio['meta_value'] = str_replace(',','',$precio['meta_value']);
$precio['meta_value'] = str_replace('$','',$precio['meta_value']);
$precio['meta_value'] = explode(".", $precio['meta_value'] )[0];
if(is_numeric($precio['meta_value'])){
$mejor_precio = $precio['meta_value'];
break;
}
}
foreach ($precios as $precio) {
$precio['meta_value'] = str_replace(',','',$precio['meta_value']);
$precio['meta_value'] = str_replace('$','',$precio['meta_value']);
$precio['meta_value'] = explode(".", $precio['meta_value'] )[0];
if(is_numeric($precio['meta_value'])){
if($precio['meta_value'] <= $mejor_precio ){
$mejor_precio = $precio['meta_value'];
$price_shop = $precio['meta_key'];
}
}
}
echo "UPDATE wp_pwgb_postmeta SET meta_value = '". $mejor_precio . "' WHERE post_id = " . $post['ID'] ." AND meta_key = 'price_best'"."<br>";
$shop = '';
switch ($price_shop) {
case 'price_amazon':
$shop = "Amazon";
break;
case 'price_sanborns':
$shop = "Sanborns";
break;
case 'price_linio':
$shop = "Linio";
break;
case 'price_claroshop':
$shop = "Claroshop";
break;
case 'price_coppel':
$shop = "Coppel";
break;
case 'price_sears':
$shop = "Sears";
break;
case 'price_bestbuy':
$shop = "Bestbuy";
break;
case 'price_walmart':
$shop = "Walmart";
break;
case 'price_liverpool':
$shop = "Liverpool";
break;
case 'price_office_max':
$shop = "Officemax";
break;
case 'price_office_depot':
$shop = "Officedepot";
break;
case 'price_palacio':
$shop = "Palacio";
break;
case 'price_soriana':
$shop = "Soriana";
break;
case 'price_elektra':
$shop = "Elektra";
break;
case 'price_sony':
$shop = "Sony";
break;
case 'price_costco':
$shop = "Costco";
break;
case 'price_radioshack':
$shop = "Radioshack";
break;
}
echo "UPDATE wp_pwgb_postmeta SET meta_value = '". $shop . "' WHERE post_id = " . $post['ID'] ." AND meta_key = 'best_shop'"."<br><br>";
}
?>