import_brend.php
3.19 KB
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
<?php
require_once("../application/run.php");
require_once("../modules/admin/model/gallery.class.php");
$db = sdb::getInstance();
$gallery = new Gallery('rus');
$res = $db->getAll("select * from catalogs_products where catalog_id=? and brend_id=?",array(75,15),DB_FETCHMODE_ASSOC);
foreach($res as $row){
$p = $db->getRow('select * from catalogs_gallery where product_id=? order by id limit 1',array($row['id']),DB_FETCHMODE_ASSOC);
$fields_values['pic'] = upload_ImageResize(array('tmp_name'=>"../pics/catalogs_gallery/big/".$p['pic_big'],'name'=>$p['pic_big']),array('width'=>"147",'height'=>"147",'upload_path'=>'../pics/products/'));
$fields_values['pic_big'] = upload_ImageResize(array('tmp_name'=>"../pics/catalogs_gallery/big/".$p['pic_big'],'name'=>$p['pic_big']),array('width'=>"700",'height'=>"700",'upload_path'=>'../pics/products/big/'));
$db->autoExecute("catalogs_products",$fields_values,DB_AUTOQUERY_UPDATE,'id='.$row['id']);
}
/**
$db->query('delete from catalogs_products where catalog_id=? and brend_id=?',array(75,15));
if (($handle = fopen("ep.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
echo $data[0] . "<br />\n";
if(strlen(trim($data[3]))>0){
$table = 'Ïðîèçâîäèòåëü: '.$data[2].'<br />'. 'Öâåò: '.$data[4].'<br />'. 'Äèàïàçîí ÷àñòîò: '.$data[5].'<br />'. 'Ñîïðîòèâëåíèå: '.$data[6].'<br />'. '×óâñòâèòåëüíîñòü: '.$data[7].'<br />'. 'Äëèíà øíóðà: '.$data[8].'<br />'. 'Âåñ: '.$data[9].'<br />';
$fields_values = array(
'catalog_id' => 75,
'brend_id' => 15,
'status' => 1,
'name' => $data[3],
'code' => $data[11],
'translit' => translitIt($data[3]),
'text' => $data[10],
'features' => $table,
//'video_code' => $data['video_code'],
//'cost' => $data['cost'],
//'recommended' => $data['recommended'],
'meta_title' => $data[3],
'meta_description' => $data[3],
'meta_keywords' =>$data[3],
'meta_about' => $data[3]
);
//$fields_values['pic'] = upload_ImageResize($upload[0],array('crop'=>true,'width'=>"147",'height'=>"147",'upload_path'=>'../pics/products/'));
//$fields_values['pic_big'] = upload_ImageResize($upload[0],array('width'=>"700",'height'=>"700",'upload_path'=>'../pics/products/big/'));
print"<pre>";
print_r($data);
$db->autoExecute("catalogs_products",$fields_values,DB_AUTOQUERY_INSERT); $product_id = mysql_insert_id();
$dir = "../files/skullcandy/".$data[16];
// Îòêðûòü èçâåñòíûé êàòàëîã è íà÷àòü ñ÷èòûâàòü åãî ñîäåðæèìîå
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
if( $file == '.' || $file == '..') continue;
//echo "ôàéë: $file <br>";
$data = array("name"=>'',
"product_id"=>$product_id,
"type"=>'img',
"code"=>''
);
$upload['pic']['name'] = $file;
print $upload['pic']['tmp_name'] = $dir . '/' . $file;
$gallery->save($data,$upload);
}
closedir($dh);
}
}
}
}
fclose($handle);
}**/
?>