The Code-Bin
Links
Home
Add your code!
All Listings
About
Latest Entry
Featured Scripts
Author's Website
Latest Entries
FFMPEG Thumbnail Scr...
PHP, 0.8KB
Jul. 29, 10:24pm
John
Z80 Assembler, 190 bytes
Feb. 17, 3:36am
John
Z80 Assembler, 176 bytes
Sep. 13, 2:19am
John
Z80 Assembler, 77 bytes
Sep. 13, 2:18am
John
Z80 Assembler, 209 bytes
Sep. 13, 2:17am
untitled PHP Code
Posted by: xxx | February 2, 2010 @ 6:30am
PHP Code
[
Download
]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="sl" lang="sl"> <head> <meta http-equiv="Content-Type" content="text/html; charset=Windows-1250" /> <title>SINHRONIZACIJA</title> </head> <body> <? function csv_row_parser($file){ $data = explode(';',$file); $i=0; foreach($data as $k => $v){ if(trim($v)) $i++; } if($i>=9) return $data; } function make_url($input,$end=''){ $find = array('"','+','/','*',' ','_','&',',','.','�','�','�','�','�','�','�','�','�','�'); $replace = array('','-','-','-','-','-','-','-','-','c','c','s','s','z','z','c','c','d','D'); return mb_strtolower(str_replace(array('--','---'),array('-','-'),str_replace($find,$replace,$input))).$end; } function clear_commas($input){ if(is_array($input)){ foreach($input as $i){ $output[] = str_replace('"','',$i); } return $output; } else { return $input; } } $category_id = array( 5 => 'EL', 9 => 'STI', 10 => 'KRM', 11 => 'KAB', 12 => 'KAN', 13 => 'PRI', 14 => 'OST', 3 => 'RA', 15 => '�AR', 16 => 'SVE', 4 => 'OR', 19 => 'ERO', 20 => 'RO�', 6 => 'GA', 22 => 'BEL', 23 => 'MGA', 24 => 'OGR', 7 => 'AV', 32 => 'AVA', 33 => 'AVD', 34 => 'VID', 35 => 'FOT' ) /* $data[0] => "Ident" $data[1] => "Naziv" $data[2] => $data[3] => "Zaloga" $data[4] => $data[5] => "EM" $data[6] => $data[7] => "Cena MPC" $data[8] => "Dni brez prometa" $data[9] => $data[10] => "Proizvajalec" $data[11] => "Klas1" $data[12] => "Klas.2" $data[13] => */ ?> <form action="" method="post" enctype="multipart/form-data"> Geslo: <input type="password" name="pass" value="sk4p1n.csv" /> <input type="file" name="csv_datoteka" /> <input type="submit" value="Nalo�i" /> </form> <br /><hr size="1" /><br /> <?if($_FILES){?> <?$file = file($_FILES['csv_datoteka']['tmp_name']);?> <table cellpadding="3" cellspacing="1" border="1" style="border-collapse: collapse;"> <tr> <td>�</td> <td><b>store</b></td> <td><b>websites</b></td> <td><b>attribute_set</b></td> <td><b>type</b></td> <td><b>sku</b></td> <td><b>category_ids</b></td> <td><b>has_options</b></td> <td><b>description</b></td> <td><b>short_description</b></td> <td><b>meta_keyword</b></td> <td><b>custom_layout_update</b></td> <td><b>price</b></td> <td><b>weight</b></td> <td><b>name</b></td> <td><b>meta_title</b></td> <td><b>meta_description</b></td> <td><b>image</b></td> <td><b>small_image</b></td> <td><b>thumbnail</b></td> <td><b>url_key</b></td> <td><b>url_path</b></td> <td><b>options_container</b></td> <td><b>gift_message_available</b></td> <td><b>manufacturer</b></td> <td><b>status</b></td> <td><b>tax_class_id</b></td> <td><b>visibility</b></td> <td><b>enable_googlecheckout</b></td> <td><b>home_page_featured</b></td> <td><b>qty</b></td> <td><b>min_qty</b></td> <td><b>use_config_min_qty</b></td> <td><b>is_qty_decimal</b></td> <td><b>backorders</b></td> <td><b>use_config_backorders</b></td> <td><b>min_sale_qty</b></td> <td><b>use_config_min_sale_qty</b></td> <td><b>max_sale_qty</b></td> <td><b>use_config_max_sale_qty</b></td> <td><b>is_in_stock</b></td> <td><b>low_stock_date</b></td> <td><b>notify_stock_qty</b></td> <td><b>use_config_notify_stock_qty</b></td> <td><b>manage_stock</b></td> <td><b>use_config_manage_stock</b></td> <td><b>stock_status_changed_automatically</b></td> <td><b>product_name</b></td> <td><b>store_id</b></td> <td><b>product_type_id</b></td> <td><b>product_status_changed</b></td> <td><b>product_changed_websites</b></td> <td><b>news_from_date</b></td> <td><b>special_price</b></td> <td><b>special_from_date</b></td> </tr> <?$i=0; foreach($file as $row){?> <? $data = csv_row_parser($row); $data = clear_commas($data); $stop = 0; // definiram prvotno vrednost if($data[0] == 'Ident') $stop = 1; // Izlo�im naslovne vrstice // dolo�im kategorije oz. izlo�im �e je ni $category = ''; if($data[11]) $category = $data[11]; if($data[12]) $category = $data[12]; $category = array_search($category, $category_id); if(!$category){ $category = 17; $stop = 1;} ?> <?if($data AND $stop == 0){ $i++;?> <tr style="<?if($i%2) echo 'background: #E8E8E8;'; else echo 'background: #F5F5F5;';?>"> <td><pre><?print_r($data);?></pre></td> <td><?=$csv[$i]['store'] = 'default';?></td> <td><?=$csv[$i]['websites'] = 'base';?></td> <td><?=$csv[$i]['attribute_set'] = 'Default';?></td> <td><?=$csv[$i]['type'] = 'simple';?></td> <td><?=$csv[$i]['sku'] = $data[0];?></td> <td><?=$csv[$i]['category_ids'] = $category;?></td> <!-- KATEGORIJE --> <td><?=$csv[$i]['has_options'] = '0';?></td> <td><?=$csv[$i]['description'] = '';?></td> <!-- OPIS --> <td><?=$csv[$i]['short_description'] = '';?></td> <!-- short OPIS --> <td><?=$csv[$i]['meta_keyword'] = '';?></td> <td><?=$csv[$i]['custom_layout_update'] = '';?></td> <td><?=$csv[$i]['price'] = $data[7];?></td> <!-- CENA --> <td><?=$csv[$i]['weight'] = '1.0000';?></td> <!-- TE�A --> <td><?=$csv[$i]['name'] = $data[1];?></td> <!-- IME --> <td><?=$csv[$i]['meta_title'] = '';?></td> <td><?=$csv[$i]['meta_description'] = '';?></td> <td><?=$csv[$i]['image'] = '';?></td> <td><?=$csv[$i]['small_image'] = '';?></td> <td><?=$csv[$i]['thumbnail'] = '';?></td> <td><?=$csv[$i]['url_key'] = make_url($data[1],'');?></td> <td><?=$csv[$i]['url_path'] = make_url($data[1],'.html');?></td> <td><?=$csv[$i]['options_container'] = 'Block after Info Column';?></td> <!-- ???? --> <td><?=$csv[$i]['gift_message_available'] = 'Use config';?></td> <td><?=$csv[$i]['manufacturer'] = $data[10];;?></td> <!-- PROIZVAJALEC --> <td><?=$csv[$i]['status'] = 'Omogo�eno';?></td> <td><?=$csv[$i]['tax_class_id'] = 'DDV 20%';?></td> <td><?=$csv[$i]['visibility'] = 'Katalog, Iskanje';?></td> <td><?=$csv[$i]['enable_googlecheckout'] = 'Da';?></td> <td><?=$csv[$i]['home_page_featured'] = '1';?></td> <td><?=$csv[$i]['qty'] = $data[3];?></td> <!-- ZALOGA --> <td><?=$csv[$i]['min_qty'] = '0.0000';?></td> <td><?=$csv[$i]['use_config_min_qty'] = '1';?></td> <td><?=$csv[$i]['is_qty_decimal'] = '0';?></td> <td><?=$csv[$i]['backorders'] = '0';?></td> <td><?=$csv[$i]['use_config_backorders'] = '1';?></td> <td><?=$csv[$i]['min_sale_qty'] = '1.0000';?></td> <td><?=$csv[$i]['use_config_min_sale_qty'] = '1';?></td> <td><?=$csv[$i]['max_sale_qty'] = '0.0000';?></td> <td><?=$csv[$i]['use_config_max_sale_qty'] = '1';?></td> <td><?=$csv[$i]['is_in_stock'] = '0';?></td> <td><?=$csv[$i]['low_stock_date'] = '2010-01-21 12:35:55';?></td> <!-- NEK DATUM --> <td><?=$csv[$i]['notify_stock_qty'] = '0.0000';?></td> <td><?=$csv[$i]['use_config_notify_stock_qty'] = '1';?></td> <td><?=$csv[$i]['manage_stock'] = '0';?></td> <td><?=$csv[$i]['use_config_manage_stock'] = '1';?></td> <td><?=$csv[$i]['stock_status_changed_automatically'] = '1';?></td> <td><?=$csv[$i]['product_name'] = $data[1];?></td> <td><?=$csv[$i]['store_id'] = '1';?></td> <td><?=$csv[$i]['product_type_id'] = 'simple';?></td> <td><?=$csv[$i]['product_status_changed'] = '';?></td> <td><?=$csv[$i]['product_changed_websites'] = '';?></td> <td><?=$csv[$i]['news_from_date'] = '';?></td> <td><?=$csv[$i]['special_price'] = '';?></td> <td><?=$csv[$i]['special_from_date'] = '';?></td> </tr> <?}?> <?}?> </table> <?}?> <hr /> <? if(is_array($csv)){?> <? $filename = 'import_'.date('d').date('m').date('Y').'_'.date(G).'h'.date(i).'m'.date(s).'s'; echo $filename; $file = fopen("../var/import/".$filename.".csv", "w+"); $i=0; foreach($csv[1] as $key => $val){ $i++; if($i!=1) $first_line .= ','; $first_line .= '"'.$key.'"'; } fwrite($file,$first_line); fwrite($file,"\n"); foreach($csv as $val){ foreach($val as $k => $v){ $v = '"'.$v.'"'; $tmp[] = $v; } $row = implode(',',$tmp); //$row = str_replace(array('�','�','�','�','�','�','�','�','�','�'),array('�','�','�','�','�','Ŝ','�','�','�','Ð'),$row); fwrite($file,$row); unset($tmp); fwrite($file,"\n"); } fclose($file); ?> <?}?> <br /> </body>
Syntax Highlighting
[
Open in new window
]
Author Comments
none
Rating
4.12 / 8
57 Votes
http://codebin.yi.org/475
page generated in 0.00 seconds