<?php

$db_name = 'demodash';

$conn = mysqli_connect("localhost","keuser","kn0wl3dg3B@NK");

if(!$conn){
    die('Couls not connect:'.mysqli_error());
}
mysqli_select_db($conn,$db_name) or die("database not connected");
// define('DB_SERVER', 'localhost');
// define('DB_USERNAME', 'surveyli_user3');
// define('DB_PASSWORD', 'sawtooth123');

// mysql_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD);
// mysql_select_db('surveyli_nielsen3');
// $dbhost = "localhost";
// $dbuser = "root";
// $dbpass = "";
// $dbname = "bloosom";

$snaptabs = array("KPI Snapshot","Snapshot by Circle","Snapshot by Shop");
$trendstabs = array("KPI trends","Trends by Shop Category","Trends by Town Class");

$circle = array("MUMBAI"=>"1","GUJARAT"=>"2","MPCG"=>"3","MHG"=>"4","DELHI NCR"=>"5","UPE"=>"6","UPW"=>"7","PUNJAB"=>"8","HARYANA"=>"9","KERALA"=>"10","CHENNAI"=>"11","BANGALORE"=>"12","KOLKATA"=>"13","RoWB"=>"14","RAJASTHAN"=>"15","AP"=>"16");
$townclass = array("M (40 Lac +)"=>"1","LT (10 Lac – 40 Lac)"=>"2","MT (1 Lac – 10 Lac)"=>"3");
$shopcategory = array("Industry A"=>"1","Industry B"=>"2","Industry C"=>"3");
$locality = array("Residential area"=>"1","Commercial area"=>"2");
$location = array("Main road"=>"1","By-lane"=>"2");
$kpi_drop = array("AVAILABILITY","VISIBILITY","NPS");
$availability_drop = array("Brand Penetration (either SIM or Etopup)"=>"BRAND_PENETRATION_SIM_AND_OR_ETOPUP","SIM Availability"=>"SIM_AVAILABILITY_in_SIM_SELLING_OUTLETS_FILTER" ,"eTopUp Availability"=>"ETOPUP_AVAILABILITY_in_ETOPUP_SELLING_OUTLETS","MNP Services Availability"=>"MNP_SERVICES_AVAILABLE","Average Current SIM Stocked"=>"AVERAGE_SIM_STOCKED_CURRENTLY","Average SIM sold Last 1 Month"=>"AVERAGE_SIM_SOLD_LAST_MONTH","Average Current eTopUp Balance"=>"AVERAGE_CURRENT_AVAILABLE_BALANCE","Average eTopUp sold last month"=>"AVERAGE_ETOPUP_SOLD_LAST_MONTH");
$visibility_drop = array("Visibility Penetration ANY SIGNAGE"=>"ANY_SIGNAGE","Visibility Penetration Back Lit Signage (Illuminated with Light)"=>"Back_Lit_Signage_Illuminated_with_Light","Visibility Penetration Box Signage (Box structure without Light)"=>"Box_Signage_Box_structure_without_Light","Visibility Penetration Non-Lit Signage (frame structure- No Light)"=>"Non_Lit_Signage_frame_structure_No_Light","Visibility Penetration Strip Signage – 4x1 / 5x1"=>"Strip_Signage_4x1_5x1","Visibility Penetration Flange – ABS/Plastic material"=>"Flange_ABS_Plastic_material","Visibility Penetration ANY POSTER/RECKONER"=>"ANY_POSTER_RECKONER","Visibility Penetration Prepaid Reckoner Poster"=>"Prepaid_Reckoner_Poster_English","Visibility Penetration Communication Poster (Product / Campaign)"=>"Communication_Poster_Product_Campaign_English","Visibility Penetration ANY SOFT POSM ELEMENTS"=>"ANY_SOFT_POSM_ELEMENTS","Visibility Penetration Dangler"=>"Dangler_English","Visibility Penetration Bunting/ Streamer"=>"Bunting_Streamer_English","Visibility Penetration Shelf Talker"=>"Shelf_Talker","Visibility Penetration Tape Roll / Shelf strip"=>"Tape_Roll_Shelf_strip","Visibility Penetration ANY HARD POSM ELEMENTS"=>"ANY_HARD_POSM_ELEMENTS","Visibility Penetration PVC / Shop front Banner"=>"PVC_Shop_front_Banner","Visibility Penetration Sun-Pack Sheet"=>"Sun_Pack_Sheet","Visibility Penetration ANY OTHER VISIBILITY ELEMENTS"=>"ANY_OTHER_VISIBILITY_ELEMENTS","Visibility Penetration Retail Gate Arch"=>"Retail_Gate_Arch","Visibility Penetration SIM Jacket"=>"SIM_Jacket");

$nps_val = array(0,1,2,3,4,5,6,7,8,9,10);

?>
