'.$storetext.'
';
}else{
$store = '';
}
if($style->price == 1){
if($style->price_button == 1){
$buttonstyle= 'padding:5px; padding-top:2px; padding-bottom:2px; color:#'.$style->buttontextcolor.'; border:#'.$style->buttonbordercolor.' solid 1px; background:#'.$style->buttoncolor.';';
}else{
$buttonstyle= "";
}
$pricetext = $style->price_before.' '.$product[0]->price;
$price ='
'.$pricetext.'
';
}else{
$price ='';
}
// Create view example with all the details from above
$result .='
'.$product[0]->title.'
'.$programimage.'
'.$store.'
'.$price.'
'.$pricetext.'
';
}else{
$price = '';
}
$result .= '
'.$product[0]->title.'
'.$programimage.'
'.$price.'
'.$style->moreproducts_text.'
';
}
echo $result;
}
if($_GET['action'] == "deleteProduct"){
global $wpdb;
$wpdb->query("DELETE FROM productfeed WHERE program_id = '".$_POST['program']."' AND product_id = '".$_POST['product']."'");
echo "DELETE FROM productfeed WHERE program_id = '".$_POST['program']."' AND product_id = '".$_POST['product']."' ";
}
if($_GET['action'] == "getProductsArray"){
$products = $wpdb->get_results("SELECT product_id FROM productfeed WHERE program_id = '".$_POST['program']."'");
$i = 1;
foreach($products AS $product){
if(count($products) > $i){
$ids .= ''.$product->product_id.', ';
}else{
$ids .= ''.$product->product_id.'';
}
$i++;
}
echo $ids;
}
if ($_GET['action'] == "result"){
$explode = explode(" ", $_POST['word']);
for($i=0; $i'; if (count($Aproducts) > 1500){ // Limit of 1500 products to show in the example view _e('Wees specifieker in je zoekopdracht','DaisyconPlugin'); }else{ // Get all the different style options $aSheet = $wpdb->get_row("SELECT * FROM stylesheets WHERE stylesheet_id = '".$_POST['stylesheet']."'"); if(isset($_POST['size'])){$size = $_POST['size'];}else{$size = $aSheet->size;} if(isset($_POST['view'])){$view = $_POST['view'];}else{$view = $aSheet->view;} if(isset($_POST['border'])){$border = $_POST['border'];}else{$border = $aSheet->bordercolor;} if(isset($_POST['background'])){$background = $_POST['background'];}else{$background = $aSheet->backgroundcolor;} if(isset($_POST['align'])){$align = $_POST['align'];}else{$align = $aSheet->align;} if(isset($_POST['textcolor'])){$textcolor = $_POST['textcolor'];}else{$textcolor = $aSheet->textcolor;} if(isset($_POST['price'])){$price = $_POST['price'];}else{$price = $aSheet->price;} if(isset($_POST['store'])){$store = $_POST['store'];}else{$store = $aSheet->store;} if(isset($_POST['float'])){$float = $_POST['float'];}else{$float = $aSheet->float;} if(isset($_POST['height'])){$height = $_POST['height'];}else{$height = $aSheet->height;} if(isset($_POST['width'])){$width = $_POST['width'];}else{$width = $aSheet->width;} if(isset($_POST['before_price'])){$before_price = $_POST['before_price'];}else{$before_price = $aSheet->price_before;} if(isset($_POST['button_store_'])){$button_store = $_POST['button_store_'];}else{$button_store = $aSheet->button_store;} if(isset($_POST['button_color_'])){$button_color = $_POST['button_color_'];}else{$button_color = $aSheet->buttoncolor;} if(isset($_POST['button_border_color_'])){$button_border_color = $_POST['button_border_color_'];}else{$button_border_color = $aSheet->buttonbordercolor;} if(isset($_POST['button_text_color_'])){$button_text_color = $_POST['button_text_color_'];}else{$button_text_color = $aSheet->buttontextcolor;} if(isset($_POST['store_button_program_'])){$store_button_program = $_POST['store_button_program_'];}else{$store_button_program = $aSheet->store_button_program;} foreach($Aproducts AS $Rproducts){ echo '
'.$Rproducts->title.'
';
$Aprogram = $wpdb->get_row("SELECT * FROM programs
WHERE program_id = '".$Rproducts->program_id."' ");
echo '
€'.$Rproducts->price.'
';
echo ''.$_POST['device'].'
'; if ($products){ foreach($products AS $product){ if($product->price == "0.00"){ $price = "Gratis!"; }else{ $price = '€ '.$product->price; } echo ' '; } }else{ echo '
Helaas zijn er geen producten gevonden!
';
}
}
// Styleresult is for creating a preview of the stylesheet
// Menu: Daisycon -> Stylesheets
if ($_GET['action'] == "styleresult"){
$products = $wpdb->get_results("SELECT productfeed.image,
productfeed.title,
productfeed.price,
programs.name,
programs.image AS program_image,
productfeed.link FROM productfeed INNER JOIN programs ON productfeed.program_id = programs.program_id
ORDER BY RAND() LIMIT 3");
if($products){
foreach($products AS $product){
// Price of the products
if($product->price == "0.00"){
$price = "Gratis!";
}else{
$price = $product->price;
}
// Float of the products, only for view = 1 (tegelweergave)
if($_POST['float'] == 1){
$float = "left";
}else{
$float = "none";
}
// View 1 is tile view (tegelweergave)
if($_POST['view'] == 1){
$programwidth = $_POST['width'] / 4;
if($_POST['store'] == 1){
$programimage = '
'.$storetext.'
';
}else{
$store = '';
}
if($_POST['price'] == 1){
if($_POST['button_price'] == 1){
$buttonstyle = 'padding:5px; padding-top:2px; padding-bottom:2px; color:#'.$_POST['button_text_color'].'; border:#'.$_POST['button_border_color'].' solid 1px; background:#'.$_POST['button_color'].';';
}else{
$buttonstyle = "";
}
$pricetext = $_POST['before_price'].' '.$product->price;
$price = '
'.$pricetext.'
';
}else{
$price = '';
}
echo '
'.$product->title.'
'.$programimage.'
'.$store.'
'.$price.'
'.$pricetext.'
';
}else{
$price = '';
}
echo '
'.$product->title.'
'.$programimage.'
'.$price.'