Skip to content

Instantly share code, notes, and snippets.

@mopuriiswaryalakshmi

mopuriiswaryalakshmi/zipcode

Created June 21, 2018 04:04
Show Gist options
  • Save mopuriiswaryalakshmi/7211c6fa85ac0a4f026717debdc850b4 to your computer and use it in GitHub Desktop.
Save mopuriiswaryalakshmi/7211c6fa85ac0a4f026717debdc850b4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
zipcode
<?php get_header();
$domain_name = getDomainData()->name;
?>
<div class="container">
<div class="tab-content">
<div class="tab-pane active" id="carport" role="tabpanel">
<div class="row">
<?php
$product_region_pod=pods('product_region');
$params=array(
"select"=>"*,product.name",
"where"=>"d.product_region='".$_SESSION['state']."'", //eg LA //passing LA state related products(relatonship with product name)
);
$product_region_pod->find($params,$limit=-1);
$product_region_data=$product_region_pod->data();
// var_dump($product_region_data);
$product_names = [];
if($product_region_data){
foreach ($product_region_data as $key => $product_value) {
array_push($product_names,"'".$product_value->{"name"}."'");
}
}
$products = implode(',', $product_names); //Horizontal,Vertical
// var_dump($product_names);
// var_dump($products);
if($products){
$pod = pods('product');
$params = array(
"select" =>"*,product_image.ID",
"where" => "t.name IN ($products) AND (d.product_title LIKE '%".$_GET['productSearch']."%' || d.product_dimension LIKE '%".$_GET['productSearch']."%' || d.product_price LIKE '%".$_GET['productSearch']."%' || d.product_shortdescription LIKE '%".$_GET['productSearch']."%' || d.product_specs LIKE '%".$_GET['productSearch']."%' || d.product_code LIKE '%".$_GET['productSearch']."%' )" ,
"orderby" => "post_date DESC"
);
$product_data=$pod->find($params,$limit=-1);
$product_data = $product_data->data();
// var_dump($product_data);
$product_url=get_page_link( get_page_by_title('productDetail')->ID );
if($product_data){
foreach ($product_data as $key=>$value) {
$product_image=pods_image_url ( $value->ID, $size = null, $default = 0, $force = false ) ;
$product_code=$value->product_code;
$product_id=$value->id;
$item_type=$value->taxonomy
?>
<div class="col-xs-12 col-md-6 col-lg-4 product">
<div class="card">
<div id="requested-searchproduct-message<?php echo $product_id?>"></div>
<a href="<?php echo $product_url."?product_code=".$product_code ?>">
<div class="card-img-top" style="background-image: url('<?php echo $product_image ?>')"></div>
<div class="card-block px-0">
<h4 class="card-title text-capitalize"><?php echo $value->product_title ?></h4>
<p class="card-text" ><?php echo $value->product_dimension ?></p>
<p class="card-description" ><?php echo $value->product_shortdescription ?></p>
<p class="text-danger mb-0 d-inline-flex align-items-end price" >$<?php echo $value->product_price ?></p>
<input type="hidden" id="productItem_type" name="item_type" value="" >
<input type="hidden" id="requested_ItemType_id" name="requested_ItemType_id" value="" >
</div>
</a>
<div class="card-modify-build">
<!-- <a class="btn btn-danger d-inline-flex text-white" onclick="requestedItem(<?php# echo "'".$product_id."','product'" ?>)" data-toggle="modal" data-target="#requestQuoteModal">Request Quote</a> -->
<a class="btn btn-danger d-inline-flex text-white" onclick="requestedItem(<?php echo "'".$product_id."','".$item_type."'" ?>)" data-toggle="modal" data-target="#requestQuoteModal">Request Quote</a>
<a class="btn btn-danger d-inline-flex ml-2" href='<?php echo get_page_link( get_page_by_title( 'Build&Price' )->ID ) ?>'>Modify Build</a>
</div>
</div>
</div>
<?php
}
}
}
?>
<?php
$demoProduct=pods('demo_product');
$params = array(
"select"=>"*,product_image.ID,dealer.display_name as display_name,dealer.ID as user_id",
"where"=>"d.product_title LIKE '%".$_GET['productSearch']."%' || d.product_dimension LIKE '%".$_GET['productSearch']."%' || d.product_price LIKE '%".$_GET['productSearch']."%' || d.product_shortdescription LIKE '%".$_GET['productSearch']."%'",
"orderby"=>"post_date DESC"
);
$demoProduct_data=$demoProduct->find($params,$limit=-1);
$demoProduct_data = $demoProduct_data->data();
// var_dump($demoProduct_data);
if($demoProduct_data){
foreach ($demoProduct_data as $key=>$value) {
$demoProductData_image=pods_image_url ( $value->ID, $size = null, $default = 0, $force = false ) ;
$user_id = $value->user_id;
$demo_id=$value->id;
// var_dump($user_id);
$item_type=$value->taxonomy;
$demoProduct_url=get_page_link( get_page_by_title( 'MySite' )->ID )."?user_id=". $user_id ;
?>
<div class="col-xs-12 col-md-6 col-lg-4 product">
<div class="card">
<div id="requested-searchproduct-message<?php echo $demo_id?>"></div>
<a href="<?php echo $demoProduct_url ?>">
<div class="card-img-top" style="background-image: url('<?php echo $demoProductData_image ?>')"></div>
<div class="card-block px-0">
<h4 class="card-title text-capitalize"><?php echo $value->product_title ?></h4>
<p class="card-text" ><?php echo $value->product_dimension ?></p>
<p class="card-description" ><?php echo $value->product_shortdescription ?></p>
<p class="text-danger mb-0 d-inline-flex align-items-end price" >$<?php echo $value->product_price ?></p>
<input type="hidden" id="productItem_type" name="item_type" value="" >
<input type="hidden" id="requested_ItemType_id" name="requested_ItemType_id" value="" >
</div>
</a>
<div class="card-modify-build">
<!-- <a class="btn btn-danger d-inline-flex text-white" onclick="requestedItem('<?php #echo $demo_id ?>','<?php #echo "Demo Product"?>')" data-toggle="modal" data-target="#requestQuoteModal">Request Quote</a> -->
<a class="btn btn-danger d-inline-flex text-white" onclick="requestedItem(<?php echo "'".$demo_id."','".$item_type."'" ?>)" data-toggle="modal" data-target="#requestQuoteModal">Request Quote</a>
<a class="btn btn-danger d-inline-flex ml-2" href='<?php echo get_page_link( get_page_by_title( 'Build&Price' )->ID ) ?>'>Modify Build</a>
</div>
</div>
</div>
<?php
}
}
// else{
// echo "DemoProducts Are Not Available Related To This Search";
// }
?>
<?php
if(($product_data == null) AND ($demoProduct_data == null)){
echo "Products Are Not Available Related To This Search";
}
?>
</div>
</div>
</div>
</div>
<script type="text/javascript">
function requestedItem(val,item){
// alert(item);
var requested_Item_id = val;
var productItem_type = item;
document.getElementById('requested_ItemType_id').value = requested_Item_id;
document.getElementById('productItem_type').value = productItem_type;
// debugger;
}
</script>
<!-- -->
<?php
// $service_area_pod = pods('service_area');
// $params = array(
// "where" => "d.area_name LIKE '%".$_GET['productSearch']."%' || d.area_description LIKE '%".$_GET['productSearch']."%'" ,
// "select" => "*, image.ID"
// );
// $service_area_pod->find($params,$limit=-1);
// $service_area_data = $service_area_pod->data();
// if($service_area_data){
// foreach ($service_area_data as $key => $service_area_dataValue) {
// $PerticularServiceArea_image=pods_image_url ( $service_area_dataValue->ID, $size = null, $default = 0, $force = false );
// $service_blog_url = get_page_link( get_page_by_title( 'serviceAreaBlog' )->ID);
// $serviceArea_name=$service_area_dataValue->{"area_name"} ;
// $area_description=$service_area_dataValue->{"area_description"};
// $post_date=$service_area_dataValue->{"post_date"};
?>
<!-- <div class="col-md-9 blog-left-panel">
<div style="background-image: url('<?php echo $PerticularServiceArea_image ?>');" class="blog-banner"></div>
<div class="media py-30">
<div class="media-body">
<h5 class="mt-0 mb-1 text-danger font-montserrat-semibold"><?php echo $serviceArea_name ?></h5>
<p class="mb-0"><?php echo date('F j, Y', strtotime($post_date)) ?></p>
</div>
<a href="javascript:fb_shareCurrentPage()" target="_blank" alt="Share on Facebook"><img class="d-inline-flex" src="<?php bloginfo('template_url'); ?>/images/icons/icon_facebook_share.svg" alt="fb" height="28px"></a>
<a class="tweet" href="javascript:tweet_shareCurrentPage()" target="_blank" alt="Tweet this page"><img class="d-inline-flex ml-3" src="<?php bloginfo('template_url'); ?>/images/icons/icon_twitter_share.svg" alt="fb" height="28px"></a>
<a class="" href="javascript:googlePlus_shareCurrentPage()" target="_blank" alt="GooglePlus Share" style="background: no-repeat scroll left center transparent;"><img class="d-inline-flex ml-3" src="<?php bloginfo('template_url'); ?>/images/icons/icon_g+_share.svg" alt="GooglePlus+" height="28px"></a>
</div>
<p class="py-30 mb-0 font-montserrat-medium"><?php echo $area_description ?></p>
</div> -->
<?php
// }
// }
?>
<!-- -->
<!-- -->
<div class="card-columns">
<?php
$service_area_pod = pods('service_area');
$params = array(
"where" => "d.area_name LIKE '%".$_GET['productSearch']."%' || d.area_description LIKE '%".$_GET['productSearch']."%'" ,
"select" => "*, image.ID"
);
$service_area_pod->find($params,$limit=-1);
$service_area_data = $service_area_pod->data();
if($service_area_data){
foreach ($service_area_data as $key => $service_area_dataValue) {
$PerticularServiceArea_image=pods_image_url ( $service_area_dataValue->ID, $size = null, $default = 0, $force = false );
$service_blog_url = get_page_link( get_page_by_title( 'serviceAreaBlog' )->ID);
$serviceArea_name=$service_area_dataValue->{"area_name"} ;
$description=$service_area_dataValue->{"area_description"};
$area_description=substr(strip_tags($description),0,250);
$post_date=$service_area_dataValue->{"post_date"};
// var_dump($serviceArea_name);
$service_blog_url = get_page_link( get_page_by_title( 'serviceAreaBlog' )->ID);
$service_url = $service_blog_url."?area=".urlencode($serviceArea_name);
?>
<div class="card">
<img class="card-img-top img-fluid" src="<?php echo $PerticularServiceArea_image ?>" alt="Card image cap">
<div class="row blog-share-date">
<div class="col-sm-6"><span><?php echo date('F j, Y', strtotime($all_posts->{"post_date"})) ?></span></div>
<!-- <div class="col-sm-6 text-right"><a href="" class=""><img src="<?php bloginfo('template_url'); ?>/images/icons/icon_share.svg" alt="share" height="19px" class="mr-2"></a></div> -->
<a href="javascript:fb_shareCurrentPage()" target="_blank" alt="Share on Facebook"><img class="d-inline-flex" src="<?php bloginfo('template_url'); ?>/images/icons/icon_facebook_share.svg" alt="fb" height="28px"></a>
<a class="tweet" href="javascript:tweet_shareCurrentPage()" target="_blank" alt="Tweet this page"><img class="d-inline-flex ml-3" src="<?php bloginfo('template_url'); ?>/images/icons/icon_twitter_share.svg" alt="fb" height="28px"></a>
<a class="" href="javascript:googlePlus_shareCurrentPage()" target="_blank" alt="GooglePlus Share" style="background: no-repeat scroll left center transparent;"><img class="d-inline-flex ml-3" src="<?php bloginfo('template_url'); ?>/images/icons/icon_g+_share.svg" alt="GooglePlus+" height="28px"></a>
</div>
<div class="card-block">
<h4 class="card-title blog-header"><?php echo $serviceArea_name ?></h4>
<p class="card-text"><?php echo $area_description ?></p>
<a href="<?php echo $service_url ?>" class="btn btn-danger text-white">Read More</a>
</div>
</div>
<?php
}
}?>
</div>
<!-- -->
<!-- -->
<div class="card-columns">
<?php
$categories = post_categories();
$domain_name = getDomainData()->name;
$post_pod = pods('post');
$params = array(
"where" =>"domain_name.name = '$domain_name' and category.name IN ($categories) AND( t.post_title LIKE '%".$_GET['productSearch']."%' || t.post_content LIKE '%".$_GET['productSearch']."%' || t.post_date LIKE '%".$_GET['productSearch']."%' || t.post_content LIKE '%".$_GET['productSearch']."%' || d.shot_description LIKE '%".$_GET['productSearch']."%')",
);
$post_pod->find($params,$limit=-1);
$post_data = $post_pod->data();
if($post_data){
foreach ($post_data as $key => $all_posts) {
$post_id = $all_posts->ID; //This is Post ID
//var_dump($post_ID);
$post_image_id= get_post_meta( $post_id, 'image', true);
$blog_image=pods_image_url( $post_image_id, $size = null, $default = 0, $force = false );
$whats_new_url = get_page_link( get_page_by_title( 'whatsNewBlog' )->ID );
$post_title = $all_posts->{"post_title"};
// $specific_whatsnew_url = $whats_new_url ."?blogType=".urlencode('Most Recent')."&"."postId=".urlencode($post_id);
$specific_whatsnew_url = $whats_new_url ."?postId=".urlencode($post_id)."&"."blogType=".urlencode('Most Recent');
?>
<div class="card">
<img class="card-img-top img-fluid" src="<?php echo $blog_image ?>" alt="Card image cap">
<div class="row blog-share-date">
<div class="col-sm-6"><span><?php echo date('F j, Y', strtotime($all_posts->{"post_date"})) ?></span></div>
<div class="col-sm-6 text-right"><a href="" class=""><img src="<?php bloginfo('template_url'); ?>/images/icons/icon_share.svg" alt="share" height="19px" class="mr-2"></a></div>
</div>
<div class="card-block">
<h4 class="card-title blog-header"><?php echo $post_title ?></h4>
<p class="card-text"><?php echo $all_posts->{"shot_description"} ?></p>
<a href="<?php echo $specific_whatsnew_url ?>" class="btn btn-danger text-white">Read More</a>
</div>
</div>
<?php
}
}?>
</div>
<!-- -->
<!-- -->
<!-- <div class="container">
<div class="row"> -->
<?php
// $feature_products_pod = pods('feature_products');
// $params = array(
// "where" => "domain_name.name = '$domain_name' AND( d.product_title LIKE '%".$_GET['productSearch']."%' || d.short_desciption LIKE '%".$_GET['productSearch']."%' || d.detail_description LIKE '%".$_GET['productSearch']."%' )",
// "select" => "*,back_image.ID as back_image_id"
// );
// $feature_products_pod->find($params,$limit=-1);
// $feature_products_data = $feature_products_pod->data();
// if($feature_products_data){
// foreach ($feature_products_data as $key => $feature_products_value) {
// $back_image_id = $feature_products_value->{"back_image_id"};
// $prod_back_image=pods_image_url( $back_image_id, $size = null, $default = 0, $force = false );
// $feature_product_title = $feature_products_value->{"product_title"};
// $feature_detail_url = get_page_link( get_page_by_title( 'featureDetail' )->ID );
// $specific_feature_url = $feature_detail_url ."?feature=".urlencode($feature_product_title);
// $short_description=$feature_products_value->{"short_desciption"};
?>
<!-- <div class="col-sm-6 col-lg-4 col-xl-4">
<div class="card-tile-wrapper">
<div class="card-tile-inner">
<div class="card-tile-front">
<figure class="card-tile-image-wrap"><img class="card-tile-image" src="<?php echo $prod_back_image ?>" alt="" width="313" height="350">
</figure>
<div class="card-tile-content">
<h6><?php echo $feature_product_title ?></h6>
</div>
</div>
<div class="card-tile-back">
<figure class="card-tile-image-wrap"><img class="card-tile-image" src="<?php echo $prod_back_image ?>" alt="" width="313" height="350">
</figure>
<div class="card-tile-content">
<h6 class="card-tile-content-title"><a href="<?php echo $specific_feature_url ?>"><?php echo $feature_product_title ?></a></h6>
<?php echo $short_description ?>
<p><?php echo $short_description ?></p><a class="button button-link" href="<?php echo $specific_feature_url ?>">Read More</a>
</div>
</div>
</div>
</div>
</div> -->
<?php
// }
// }?>
</div><!-- row -->
</div><!-- container -->
<!-- -->
<!-- -->
<div class="card-columns">
<?php
$feature_products_pod = pods('feature_products');
$params = array(
"where" => "domain_name.name = '$domain_name' AND( d.product_title LIKE '%".$_GET['productSearch']."%' || d.short_desciption LIKE '%".$_GET['productSearch']."%' || d.detail_description LIKE '%".$_GET['productSearch']."%' )",
"select" => "*,back_image.ID as back_image_id"
);
$feature_products_pod->find($params,$limit=-1);
$feature_products_data = $feature_products_pod->data();
// var_dump($feature_products_data);
if($feature_products_data){
foreach ($feature_products_data as $key => $feature_products_value) {
// $front_image_id = $feature_products_value->{"front_image_id"};
$back_image_id = $feature_products_value->{"back_image_id"};
// $prod_front_image=pods_image_url( $front_image_id, $size = null, $default = 0, $force = false );
$prod_back_image=pods_image_url( $back_image_id, $size = null, $default = 0, $force = false );
$feature_product_title = $feature_products_value->{"product_title"};
$feature_detail_url = get_page_link( get_page_by_title( 'featureDetail' )->ID );
$specific_feature_url = $feature_detail_url ."?feature=".urlencode($feature_product_title);
$short_description=$feature_products_value->{"short_desciption"};
// var_dump($feature_products_value->{"short_desciption"} );
// }
// }
?>
<div class="card">
<img class="card-img-top img-fluid" src="<?php echo $prod_back_image ?>" alt="Card image cap">
<div class="row blog-share-date">
<div class="col-sm-6"><span><?php echo date('F j, Y', strtotime($all_posts->{"post_date"})) ?></span></div>
<div class="col-sm-6 text-right"><a href="" class=""><img src="<?php bloginfo('template_url'); ?>/images/icons/icon_share.svg" alt="share" height="19px" class="mr-2"></a></div>
</div>
<div class="card-block">
<h4 class="card-title blog-header"><?php echo $feature_product_title ?></h4>
<p class="card-text"><?php echo $short_description ?></p>
<a href="<?php echo $specific_feature_url ?>" class="btn btn-danger text-white">Read More</a>
</div>
</div>
<?php
}
}?>
</div>
<!-- -->
<!-- -->
<?php
// $officewarehouse_shop_data=officeWarehouseShops();
// $domain_name = getDomainData()->name;
// $officewarehouse_shop_pod = pods('area_shops');
// $params = array(
// "where" => "domain_name.name = '$domain_name'",
// "orderby" => "d.is_headquarters DESC "
// );
// $officewarehouse_shop_pod->find($params,$limit=-1);
// $officewarehouse_shop_data = $officewarehouse_shop_pod->data();
// $contact_url = get_page_link( get_page_by_title('contact')->ID );
?>
<!-- <div class="row shop-location">
<div class="container">
<a href="<?php echo $contact_url ?>"> -->
<?php
// if($officewarehouse_shop_data){
// foreach( $officewarehouse_shop_data as $key => $value){
// if($value->{"is_headquarters"}){
?>
<!-- <div class="col-12">
<div class="d-flex justify-content-center">
<div class="media d-md-inline-flex justify-content-center mb-3 mb-md-5">
<img class="d-flex align-self-center mr-3" src="<?php bloginfo('template_url'); ?>/images/icons/icon_headquarter.svg" height="120px">
<div class="media-body align-self-center">
<h5 class="mt-0 location-title"><?php echo $value->{"name"}?></h5>
<p class="mb-0 location-address"><?php echo $value->{"address"} ?></p>
<p class="mb-0 location-address"><?php echo $value->{"pincode"}?></p>
<p class="mb-0 location-address"><?php echo $value->{"phone_number"}?></p>
</div>
</div>
</div>
</div> -->
<?php
// }else{ ?>
<!-- <div class="col-sm-12 col-md-6 col-lg-3 testing">
<div class="media mb-3 mb-lg-0">
<img class="d-flex mr-3" src="<?php bloginfo('template_url'); ?>/images/icons/icon_location.svg" height="44px">
<div class="media-body">
<h5 class="mt-0 location-title"><?php echo $value->{"name"}?></h5>
<p class="mb-0 location-address"><?php echo $value->{"address"} ?></p>
<p class="mb-0 location-address"><?php echo $value->{"pincode"}?></p>
<p class="mb-0 location-address"><?php echo $value->{"phone_number"}?></p>
</div>
</div>
</div> -->
<?php
// } //else ends
// } //forEach Ends
// } //if end
?>
<!-- </a>
</div>
</div> -->
<!-- -->
<!-- -->
<?php
// $service_page_data = serviceAreaPage(); ?>
<!-- <section class="py-60 container">
<h5 class="dealer-heading text-danger text-center">Our Service Area</h5>
<p><?php echo $service_page_data[0]->{"sa_description"}?></p>
</section>
<hr class="divider my-0">
<section class="py-40 bg-grey">
<div class="container">
<div class="row">
<div class="col-12 col-lg-6 text-center mb-5 mb-lg-0">
<h5 class="dealer-heading text-danger mb-3">Products</h5>
<p class="">Our slogan says its all, Versatile. Strong. Built to Last. Weather your looking to start a new project or needing to add to your existing structure, American Steel Carports will be there every step of the way. No job is too big or too small. Trust, that we've got you COVERED!</p>
<a href="<?php echo get_page_link( get_page_by_title('Products')->ID ); ?>" class="btn btn-danger">View All</a>
</div>
<div class="col-12 col-lg-6 text-center">
<h5 class="dealer-heading text-danger mb-3">Product Features</h5>
<p class="">Aside from the 360 degree bracing, wind and snow warranties, insulation and skylights, we also offer colored screws, heavy-duty double doors, 26 gauge steel sheeting, and many more! Make sure you ask about all additional features. Custom units don’t have to come with the custom price! American Steel Carports will make sure to get you the best price for your ideal building.</p>
<a href="<?php echo get_page_link( get_page_by_title('Features')->ID ); ?>" class="btn btn-danger">See All</a>
</div>
</div>
</div>
</section>
<hr class="divider my-0"> -->
<!-- -->
<?php
$demoProduct=pods('demo_product');
$params = array(
// "select"=>"*,dealer.display_name as display_name",
"select"=>"*,product_image.ID,dealer.display_name as display_name,dealer.ID as user_demo_id",
// "where"=>"d.product_title LIKE '%".$_GET['productSearch']."%' || d.product_dimension LIKE '%".$_GET['productSearch']."%' || d.product_price LIKE '%".$_GET['productSearch']."%' || d.product_shortdescription LIKE '%".$_GET['productSearch']."%'",
// "orderby"=>"post_date DESC"
);
$demoProduct_data=$demoProduct->find($params,$limit=-1);
$demoProduct_data = $demoProduct_data->data();
// var_dump($demoProduct_data);
// var_dump($demoProduct_data);
$count=0;
$demo_countArray=[];
foreach ($demoProduct_data as $key => $value_demo) {
$demo_userId=$value_demo->{"user_demo_id"};
// var_dump($value);
// var_dump($demo_userId);
// var_dump($verified_userIds);
// var_dump(($demo_userId) == "1");
if(($demo_userId) == "23"){
// $hash=array(
// $count++
// );
$count++;
$demo_countArray[$demo_userId]=$count; //for perticular user_id respective user_email and user_name
}
// var_dump($demo_countArray);
// $hash=array(
// "user_email"=>$value["user_email"],
// "user_name"=>$value["user_name"],
// );
// $user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
}
var_dump($count);
var_dump($demo_countArray);
?>
<?php
$demoProduct=pods('demo_product');
$params = array(
// "select"=>"*,dealer.display_name as display_name",
"select"=>"*,product_image.ID,dealer.display_name as display_name,dealer.ID as user_demo_id",
// "where"=>"d.product_title LIKE '%".$_GET['productSearch']."%' || d.product_dimension LIKE '%".$_GET['productSearch']."%' || d.product_price LIKE '%".$_GET['productSearch']."%' || d.product_shortdescription LIKE '%".$_GET['productSearch']."%'",
// "orderby"=>"post_date DESC"
);
$demoProduct_data=$demoProduct->find($params,$limit=-1);
$demoProduct_data = $demoProduct_data->data();
// var_dump($demoProduct_data);
// var_dump($demoProduct_data);
// var_dump($verifieduserIds_array);
// var_dump($verified_userIds);
// $count=0;
$demo_countArray=[];
// $explode_userIds=explode(" ",$verified_userIds);
foreach ($verifieduserIds_array as $key => $value_userData) {
// var_dump($value_userData);
$single_userId=$value_userData;
// var_dump($single_userId);
$count=0;
foreach ($demoProduct_data as $key => $value_demo) {
$demo_userId_value=$value_demo->{"user_demo_id"};
// var_dump($value);
// var_dump("'".$demo_userId."'");
$demo_userId="'".$demo_userId_value."'";
// var_dump($verified_userIds);
// var_dump(($demo_userId) == "1");
// var_dump(($demo_userId) == $single_userId);
if(($demo_userId) == $single_userId){
$hash=array(
$count=$count+1,
"demo_counts"=>$count,
);
// $count++;
$demo_countArray[$demo_userId_value]=$hash; //for perticular user_id respective user_email and user_name
}
}
// var_dump($demo_countArray);
// $hash=array(
// "user_email"=>$value["user_email"],
// "user_name"=>$value["user_name"],
// );
// $user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
}
var_dump($count);
var_dump($demo_countArray);
?>
<?php
$user_data=getAllUserData();
$verifieduserIds_array=[];
$user_dataArray=[];
foreach ($user_data as $key => $value) {
array_push($verifieduserIds_array,"'".$value["user_id"]."'"); //push user_ids
$hash=array(
"user_email"=>$value["user_email"],
"user_name"=>$value["user_name"],
);
$user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
}
$verified_userIds =implode(', ',$verifieduserIds_array); // implode() function returns a string from the elements of an array. //return user_id with string
// var_dump($user_dataArray[16]["user_email"]);
$dealer_pod = pods('dealer');
$domain_name = getDomainData()->name;
if($_GET['zipcode']){
$params = array(
"where" => "domain_name.name = '$domain_name' AND d.user_id IN ($verified_userIds) AND d.zip_postal_code='".$_GET['zipcode']."'",
);
}else{
$params = array(
"where" => "domain_name.name = '$domain_name' AND d.user_id IN ($verified_userIds)",
);
}
$dealer_pod->find($params,$limit=-1);
$dealer_data = $dealer_pod->data();
if($dealer_data){
foreach ($dealer_data as $key => $dealer_value) {
$user_id = $dealer_value->user_id;
$phone_number=$dealer_value->phone;
$zip_code=$dealer_value->zip_postal_code;
$street_address=$dealer_value->street_address;
$user_name=$user_dataArray[$user_id]["user_name"];
$user_email=$user_dataArray[$user_id]["user_email"];
$user_demos=$demo_countArray[$user_id]["demo_counts"];
}
}
?>
<?php get_footer()?>
<?php
$demo_countArray=demoProductsCount();
$user_data=getAllUserData();
$verifieduserIds_array=[];
$user_dataArray=[];
foreach ($user_data as $key => $value) {
array_push($verifieduserIds_array,"'".$value["user_id"]."'"); //push user_ids
$hash=array(
"user_email"=>$value["user_email"],
"user_name"=>$value["user_name"],
);
$user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
}
$verified_userIds =implode(', ',$verifieduserIds_array); // implode() function returns a string from the elements of an array. //return user_id with string
// var_dump($user_dataArray[16]["user_email"]);
$dealer_pod = pods('dealer');
$domain_name = getDomainData()->name;
if($_GET['zipcode']){
$params = array(
"where" => "domain_name.name = '$domain_name' AND d.user_id IN ($verified_userIds) AND d.zip_postal_code='".$_GET['zipcode']."'",
);
}else{
$params = array(
"where" => "domain_name.name = '$domain_name' AND d.user_id IN ($verified_userIds)",
);
}
$dealer_pod->find($params,$limit=-1);
$dealer_data = $dealer_pod->data();
if($dealer_data){
foreach ($dealer_data as $key => $dealer_value) {
$user_id = $dealer_value->user_id;
$phone_number=$dealer_value->phone;
$zip_code=$dealer_value->zip_postal_code;
$street_address=$dealer_value->street_address;
$user_name=$user_dataArray[$user_id]["user_name"];
$user_email=$user_dataArray[$user_id]["user_email"];
$user_demos=$demo_countArray[$user_id]["demo_counts"];
var_dump($user_demos);
}
}
// $demo_product_pod = pods('demo_product');
// $domain_name = getDomainData()->name;
// $params = array(
// "select"=>"dealer.name",
// // "where" => "dealer.ID IN ($verified_userIds)",
// // "where"=>"d.display_name='root root'"
// );
// $demo_product_pod->find($params,$limit=-1);
// $demo_product_data = $demo_product_pod->data();
// var_dump($demo_product_data);
// var_dump($verified_userIds);
// $demo_productArray=[];
// foreach ($demo_product_data as $key => $value) {
// array_push($verifieduserIds_array,"'".$value["user_id"]."'"); //push user_ids
// $hash=array(
// "user_email"=>$value["user_email"],
// "user_name"=>$value["user_name"],
// );
// $user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
// }
// $demoProduct=pods('demo_product');
// $params = array(
// "select"=>"*,dealer.display_name",
// // "where"=>"d.product_title LIKE '%".$_GET['productSearch']."%' || d.product_dimension LIKE '%".$_GET['productSearch']."%' || d.product_price LIKE '%".$_GET['productSearch']."%' || d.product_shortdescription LIKE '%".$_GET['productSearch']."%'",
// // "orderby"=>"post_date DESC"
// );
// $demoProduct_data=$demoProduct->find($params,$limit=-1);
// $demoProduct_data = $demoProduct_data->data();
// var_dump($demo_product_data);
?>
<?php
$demoProduct=pods('demo_product');
$params = array(
// "select"=>"*,dealer.display_name as display_name",
"select"=>"*,product_image.ID,dealer.display_name as display_name,dealer.ID as user_demo_id",
// "where"=>"d.product_title LIKE '%".$_GET['productSearch']."%' || d.product_dimension LIKE '%".$_GET['productSearch']."%' || d.product_price LIKE '%".$_GET['productSearch']."%' || d.product_shortdescription LIKE '%".$_GET['productSearch']."%'",
// "orderby"=>"post_date DESC"
);
$demoProduct_data=$demoProduct->find($params,$limit=-1);
$demoProduct_data = $demoProduct_data->data();
// var_dump($demoProduct_data);
// var_dump($demoProduct_data);
$count=0;
$demo_countArray=[];
foreach ($demoProduct_data as $key => $value_demo) {
$demo_userId=$value_demo->{"user_demo_id"};
// var_dump($value);
// var_dump($demo_userId);
// var_dump($verified_userIds);
// var_dump(($demo_userId) == "1");
if(($demo_userId) == "23"){
// $hash=array(
// $count++
// );
$count++;
$demo_countArray[$demo_userId]=$count; //for perticular user_id respective user_email and user_name
}
// var_dump($demo_countArray);
// $hash=array(
// "user_email"=>$value["user_email"],
// "user_name"=>$value["user_name"],
// );
// $user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
}
// var_dump($count);
// var_dump($demo_countArray);
?>
<?php
$demoProduct=pods('demo_product');
$params = array(
"select"=>"*,product_image.ID,dealer.display_name as display_name,dealer.ID as user_demo_id",
);
$demoProduct_data=$demoProduct->find($params,$limit=-1);
$demoProduct_data = $demoProduct_data->data();
$demo_countArray=[];
foreach ($verifieduserIds_array as $key => $value_userData) {
$single_userId=$value_userData;
$count=0;
foreach ($demoProduct_data as $key => $value_demo) {
$demo_userId_value=$value_demo->{"user_demo_id"};
$demo_userId="'".$demo_userId_value."'";
if(($demo_userId) == $single_userId){
$hash=array(
$count=$count+1,
"demo_counts"=>$count,
);
$demo_countArray[$demo_userId_value]=$hash; //for perticular user_id respective user_email and user_name
}
}
}
// var_dump($count);
// var_dump($demo_countArray);
?>
<?php
$user_data=getAllUserData();
$verifieduserIds_array=[];
$user_dataArray=[];
foreach ($user_data as $key => $value) {
array_push($verifieduserIds_array,"'".$value["user_id"]."'"); //push user_ids
$hash=array(
"user_email"=>$value["user_email"],
"user_name"=>$value["user_name"],
);
$user_dataArray[$value["user_id"]]=$hash; //for perticular user_id respective user_email and user_name
}
$verified_userIds =implode(', ',$verifieduserIds_array); // implode() function returns a string from the elements of an array. //return user_id with string
// var_dump($user_dataArray[16]["user_email"]);
$dealer_pod = pods('dealer');
$domain_name = getDomainData()->name;
if($_GET['zipcode']){
$params = array(
"where" => "domain_name.name = '$domain_name' AND d.user_id IN ($verified_userIds) AND d.zip_postal_code='".$_GET['zipcode']."'",
);
}else{
$params = array(
"where" => "domain_name.name = '$domain_name' AND d.user_id IN ($verified_userIds)",
);
}
$dealer_pod->find($params,$limit=-1);
$dealer_data = $dealer_pod->data();
if($dealer_data){
foreach ($dealer_data as $key => $dealer_value) {
$user_id = $dealer_value->user_id;
$phone_number=$dealer_value->phone;
$zip_code=$dealer_value->zip_postal_code;
$street_address=$dealer_value->street_address;
$user_name=$user_dataArray[$user_id]["user_name"];
$user_email=$user_dataArray[$user_id]["user_email"];
$user_demos=$demo_countArray[$user_id]["demo_counts"];
}
}
?>
---------------------------------------------------------------
<?php
$zipcode_pod = pods('zipcode_sheet_upload');
$params = array(
"where" => "d.id" ,
);
$zipcode_pod=$zipcode_pod->find( $params,$limit=-1);
$zipcode_data = $zipcode_pod->data();
// var_dump($zipcode_data);
// var_dump($zipcode_data[0]->data);
$zipcode_csv=$zipcode_data[0]->data;
// $zipcode_csv = "Zip code,City,County,State\n
// 70501,LAFAYETTE,LAFAYETTE,LA\n
// 70502,LAFAYETTE,LAFAYETTE,LA\n
// 70503,LAFAYETTE,LAFAYETTE,LA";
// var_dump($zipcode_csv);
$csvArray_data=str_getcsv($zipcode_csv,"\n");
// var_dump($csvArray_data); // { [0]=> string(26) "Zip code,City,County,State" [1]=> string(28) "70501,LAFAYETTE,LAFAYETTE,LA"
$zipcode_array=[];
$csv_array=[]; //{ [0]=> array(4) { [0]=> string(8) "Zip code" [1]=> string(4) "City" [2]=> string(6) "County" [3]=> string(5) "State" } [1]=> array(4) { [0]=> string(5) "70501" [1]=> string(9) "LAFAYETTE" [2]=> string(9) "LAFAYETTE" [3]=> string(2) "LA" }
$csv_final=[]; //{ ["Zip code,City,County,State"]=> array(0) { } ["70501,LAFAYETTE,LAFAYETTE,LA"]=> array(0) { } ["70502,LAFAYETTE,LAFAYETTE,LA"]=> array(0) { }
foreach ($csvArray_data as $key => $value) {
array_push($csv_array,str_getcsv($value,","));
// $csv_final[$csv_array[$key][0]]=$csv_array[$key];
// unset($csv_final[$csv_array[$key][0]][0]);
}
var_dump($csv_array);
// var_dump($csv_final);
// print_r(array_chunk($csvArray_data, 4));
foreach ($csv_array as $key => $value) {
var_dump($value);
}
?>
<?php get_footer()?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment