section  = infographics

table structure
----------------

	CREATE TABLE `tbl_stats_infographics` (
	  `id` int(11) NOT NULL,
	  `post_id` int(11) NOT NULL,
	  `post_title` varchar(255) NOT NULL,
	  `post_content` longtext NOT NULL,
	  `author_id` int(10) NOT NULL,
	  `meta_description` mediumtext NOT NULL,
	  `post_tags` varchar(255) NOT NULL,
	  `post_date` date NOT NULL,
	  `post_time` char(8) NOT NULL,
	  `commodityId` int(5) NOT NULL,
	  `subCommodityId` int(5) NOT NULL,
	  `subSubCommodityID` int(11) NOT NULL,
	  slider_image varchar(255) NOT NULL,
	  listing_image varchar(255) NOT NULL,
	  description_image varchar(255) NOT NULL,
	  `href` varchar(255) NOT NULL,
	  `created_at` datetime NOT NULL,
	  accessibleToPreLogin char(1) NOT NULL default N // value = Y/N
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;

	--
	-- Indexes for dumped tables
	--

	--
	-- Indexes for table `tbl_news_post`
	--
	ALTER TABLE `tbl_stats_infographics`
	  ADD PRIMARY KEY (`id`),
	  ADD KEY `post_id` (`post_id`),
	ALTER TABLE `tbl_news_post` ADD FULLTEXT KEY `post_title` (`post_title`);
	ALTER TABLE `tbl_news_post` ADD FULLTEXT KEY `post_content` (`post_content`);

	--
	-- AUTO_INCREMENT for dumped tables
	--

	--
	-- AUTO_INCREMENT for table `tbl_stats_infographics`
	--
	ALTER TABLE `tbl_news_post`
	  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

API details
-----------
	URL
		GET https://www.theitbooth.com/api/public/v2019/statistics/infographics


	INPUT
	
	{
	  "memid" : 83757, //optional
	  "pageValue" : 1, // for pagination
	  filter{
		  "type" : "related"
		  itemId: // will be useful if "type" : "related"
		}  
	}

	Sample Output Parameters

	 {
	   "status" : {
		 "code" : 10001,
		 "message" : "Success"
	   },
	  "data" : [{
		"itemID" : 12,
		"commodity" : "coal",
		"title" : "Sample",
		"description" : "sample",
		"publishDate" : "2019-05-09 12:00:00",
		"isBookmarked" : "Y/N",
		slider_image ,
		listing_image,
		description_image,
		"authorDetails" : {
		  "name" : "Imndranath",
		  "email" : "itbooth@steelmint.com",
		  "imageUrl" : "url",
		  "socialAccounts" : {
			"fb" : "fb.com",
			"twitter" : "twitter.com"
		  }
		}
	  },

	  {
		"itemID" : 12,
		"commodity" : "coal",
		"title" : "Sample",
		"description" : "sample",
		"publishDate" : "2019-05-09 12:00:00",
		"isBookmarked" : "Y/N",
		"thumbnailUrl" : "url",
		"imageUrl" : "url",
		"authorDetails" : {
		  "name" : "Imndranath",
		  "email" : "itbooth@steelmint.com",
		  "imageUrl" : "url",
		  "socialAccounts" : {
			"fb" : "fb.com",
			"twitter" : "twitter.com"
		  }
		}
	  }]
	}

calls to API
-------------
1) slider + below slider = 8 Nos.
2) listing 
3) related
4) will work for both: 
		pre login 
		---------
		 if "memid" == 0/NULL/blank/not sent in API
			then send list of infographics having (accessibleToPreLogin = Y + order by id desc)
		
		post login
		-----------
		 A) if "memid" = sent in API 
			if (valid memid)
				then send list of latest infographics (order by id desc)
			else
				throw error
				
		B) if "type" : "related"
			itemID is sent
				then send latest 8 infographs for commodity of (itemID) + order by id desc
			else
				throw error			
			
		C) authorDetails
			refer tbl_rel_manager ON tbl_stats_inforgraphs.author_id = tbl_rel_manager.id
			get follwoing pars from tbl_rel_manager
				RM_name, RM_email, imageURL, facebookId, twitterId