var express = require("express");
var db = require("../models");
const Op = db.Sequelize.Op
var router = express.Router();
// These three lines should be put outside of the fuction
// on top of the file
let configs = {};
//if the process is in development it will refer to secrets
//but if its production then it will refer to heroku's secrets section.
//and the production heroku refers to the tokens acountSid and authToken
if (process.env.NODE_ENV !== 'production') {
	configs = require('../config/secrets.js')
}
const accountSid = process.env.TWILLIO_ACCOUNTSID || configs.twilio_accountSid;
const authToken = process.env.TWILLIO_AUTHTOKEN || configs.twilio_authtoken;
const client = require('twilio')(accountSid, authToken);
var schedule = require('node-schedule');

const phoneBook = {};
// User APIs
// get all users
// get all employees
// get all employers
//TONY I WANT YOU TO UNDERSTAND AND ADD NOTES TO EVERY CODE, AND BRANCH
//FIX THE DAMN STYLING ASAP PLEASE BOY
//first off change the damn style all together, for real fuck vuetify or use its cdn
//  damn it as a dream,, add text bitcoin api payment option to hey earl

//you need to make it way more functional, the name of the user shit needs to look good

//add the links to the heroku add you added named OPBEAT


//adding cron scheduling to the mysql posts
var j = schedule.scheduleJob('30 4 * * *', function(){
	// it should trigger ever day at 4:30 in the morning
	// and check if the the posts are older than 7 days
	const today = new Date();
	// new date() is Js for today's time and date
	//  below is adding miliseconds to seconds to minutes to hours to days, less than todays date
	// and if its a less than the date number seven days ago, then it will delete the post,
	const predicate = new Date(today -  7 * 24 * 60 * 60 * 1000);
	db.JobPost.destroy({
		where: {
			createdAt: {
				//below is a sequalize key thats why its in brakets, that means less than the predicate
				//so it deletes or destroys it from the data base
				[Op.lt]: predicate,
			}
		}
	})

})

router.post('/textit/posts', function (req, res) {
	var phone = req.body.phone;
	var zipCode = req.body.text;

	// Step1: get the first jobPost data with sequelize near the zip code
	db.JobPost.findOne({
		where: {
			locationZip: zipCode
		},
		order: [
			['createdAt', 'DESC']
		]
	}).then(post => {
		console.log(post);
		var text = `Pay Amount: ${post.payAmount}
		Work Description: ${post.description}
		Phone number: ${post.phone}`
		// Step2: send the jobpost back to users
		client.messages.create({
				body: text, // here is your text message
				to: phone, // replace this with user's phone number
				from: '+12544002317',
			})
			.then((message) => {
				//this particular res.json isn't needed for the file as much
				//as it ends the file, and isn't left hangin
				res.json({
					message: 'Text has been sent'
				})
			}).catch(err => {
				console.log(err)
			})
	}).catch(err => {
		console.log(err)
	})
})


router.post('/sms', function (req, res) {
	// const question = req.params.question;
	const value = req.body.Body.trim().toLowerCase();
	const phone = req.body.From;
	// destructuring of objects
	let { nextStep: currentStep = 0, viewing } = phoneBook[phone] || {};
	currentStep = parseInt(currentStep);

	if (value === 'hello' || value === 'reset' || value === 'hey earl') {
		phoneBook[phone] = { nextStep: 0, viewing: false };
		currentStep = 0;
		viewing = false;
	}
	console.log(value, phone);
	console.log(`The current step is ${currentStep}`);
	if (!value) {
		res.status(400).json({
			message: 'To use Hey Earl List, please type the work HELLO or HEY EARL'
		});
		return;
	}

	switch (currentStep) {
		case 0:
		sendTextMessage(res, currentStep += 1, "Post or View?", phone)();
		break;
		case 1:
		if (value !== 'post' && value !== 'view') {
			sendTextMessage(res, currentStep, "Please type POST or VIEW.", phone)();
			break;
		}
		if (value === 'view') {
			sendTextMessage(res, currentStep += 1, 'What is the zip code?', phone, true)();
			break;
		}
		if (value === 'post') {
			sendTextMessage(res, currentStep += 1, 'If you want a job done text EMPLOYER. If you are offering to work text EMPLOYEE', phone)();
			res.end();
			break;
		}
		case 2:
			if (viewing) {
				const isValidZip = /(^\d{5}$)|(^\d{5}-\d{4}$)/.test(value)
				if (isValidZip) {
					db.JobPost.findAll({
						where: {
							locationZip: value
						}
					})
					.then(posts => {
						const postMsgs = posts
						.map((post, idx) => (
							`Post ${idx + 1}:\n
							  Phone: ${post.phone},\n
							  Description: ${post.description},\n
							  Hourly Pay: ${post.payAmount},\n
							  Has Transportation: ${post.hasCar}\n
							`
						))
						.join('\n')
						sendTextMessage(res, currentStep += 1, postMsgs || 'No post in this area!', phone)()
					})
					break;
				} else {
					sendTextMessage(res, currentStep, 'Invalid zip code', phone)();
					break;
				}
			}
			// Do a checking on the incoming value to see whether the value is waht you are
			// expecting. Else, you DO NOT change the current step, instead, you just keep
			// sending the same message until you get what you ask for! e.g.
			/**
			 * if (value !== 'employer' || value !== 'employee') {
			 * 		1. send a message to tell the user he/she is a dumbass
			 * 		2. end the request by return res.end()
			 * }
			 * ADD JOB DESCRIPTION TO VIEW. with a question asking if they would like to view another zip
			 *  IN THE BRANCH THATS USING TEXTIT
			 *
			 * HOW DO I GET IT TO DELETE EVERY WEEK EACH POSTING, AND MAYBE ONLY OFFER AN EMPTY
			 * LISTING THAT SAYS THERE AREN'T NO LISTINGS
			 *
			 * HOW TO DELETE FROM MY EXISTING DATABASE.  TO SET IT UP FOR FUTURE POSTS.
			 *
			 */
			console.log(value, value === 'employee');
			if (value !== 'employer' && value !== 'employee') {
				sendTextMessage(res, currentStep, "Send only the word 'EMPLOYEE' or 'EMPLOYER'", phone)();
				return res.end()
			}

			db.JobPost.create({
					phone,
					role: value
				})
				.then(post => {
					sendTextMessage(res, currentStep += 1, 'What is your zip code?', phone)()
					res.json({
						hasDone: post.hasFinishedCreation()
					})
				})
				.catch(err => console.log(err.message));
			break
		case 3:
				// if(value  regex  the if statement does doesnt add +1 step			// Using regex to check whether the value is a valid zip code
				// var isValidZip = /(^\d{5}(-\d{4})?$/.test("76652");
				updatePost(phone, res, 'locationZip', value, sendTextMessage(res, currentStep += 1, 'Briefly give a few words about the work you are offering?', phone));
			break;
		case 4:
			updatePost(phone, res, 'description', value, sendTextMessage(res, currentStep += 1, 'Hourly amount offered or desired? Please reply with a number only.', phone));
			break;
		case 5:
			updatePost(phone, res, 'payAmount', value, sendTextMessage(res, currentStep += 1, 'Reply *YES* if you offer transportation for your workers or if you have transportation to get to gig location. Text *NO* if you need transportation.', phone));
			break;
		case 6:
		    if (value !== 'yes' && value !== 'no') {
				sendTextMessage(res, currentStep, "Send only 'YES' or 'NO'", phone)();
				return res.end()
			}
		// Sequelize wants a boolean so this is our way of giving it a boolean ,,  the value will still be a string
			const answer = value === 'yes';
			updatePost(phone, res, 'hasCar', answer, sendTextMessage(res, 0, 'Thank you for using hey earl, your post will be public for a week! You can post again after that.', phone));
			break;
		default:
			res.status(401).json({
				message: 'Not valid'
			});
			break;
	}
});

/**
 * updatePost
 * A helper method to update value of a jobPost through user's phone number.
 * @param {number} phone - User's phone number
 * @param {object} res - res object of express router
 * @param {string} key - which key you want to update for a jobPost
 * @param {any} value - what is the new value of that jobPost's key
 * @returns {Promise.<TResult>}
 */
function updatePost(phone, res, key, value, cb) {
	// If you want to always have only ONE record in the database of a jobpost with that phone
	// number, use findOrCreate instead of findOne. findOne will create a new record in the database
	// each time a 'role' question got answered
	return db.JobPost.findOne({
			where: {
				phone
			},
			order: [
				['createdAt', 'DESC']
			]
		})
		.then(post => {
			if (post) {
				post.updateAttributes({
						[key]: value
					})
					.then(updatedPost => {
						if (cb) {
							cb()
						}
						res.json({
							message: 'You have successfully updated it!'
						})
					})
					.catch(err => console.log(err.message));
			} else {
				const err = new Error('You should have one post for that number');
				res.status(404).json({
					message: err.message
				});
			}
		})
		.catch(err => console.log(err.message));
}

const sendTextMessage = (res, nextStep, message, phone, viewing = false) => () => {
	// const phoneBook= {
	// 	"+1858262332": 1,
	// 	"+11234567123": 3,
	// }
	phoneBook[phone] = { nextStep, viewing: viewing || phoneBook[phone].viewing };
	client.messages.create({
			body: message, // here is your text message
			to: phone, // replace this with user's phone number
			from: '+12544002317',
		})
		.then((message) => {
			console.log(`Yay! Message ${message.toString()} sent to phone ${phone}!`)
			res.end();
		}).catch(err => {
			console.log(err)
		})
}

//!!!Why doesn't the models all require sequalize!!
//first question    ;;;
//create a post using the users phone number
//put reponse to the post
//and for the other qustions    this stuff updates the listings
//step 1;  find a post by their phone number
//
//step2; update the post data according to the response
// understand inlude
// you can filter an unfinished post out, .filter  for an array
//ex  case name  find the user,  update the name for whatever the user replied.
//
// 		router.post('/posts', function (req, res) {
// 	const post = req.body.post;
// 	const userId = req.body.userId;
// 	post.UserId = userId;
// 	db.JobPost.create(post)
// 		.then(post => res.json(post))
// 		.catch(err => res.status(500).json(err))
// });

// user.findOrCreate() user.update   name name

// jobPost.findorCreate   jobPost.update  role: {]}

//           router.post('/textit/:question/create', function (req, res) {
// 			var value = req.body.text;
// 	var phone = req.body.phone;
// 	  			const userId = req.body.phone;
// 				post.UserId = userId;
// 				var question = req.params.question;

// 		switch (question) {
// 		case 'role':
// 		//use sequalize to create the user  and add the phone from the text it

//             var ref = db.child('users').child(value).child(phone).push({role: value});
//             contacts[phone].role = value;
// 			contacts[phone].id = ref.key();

// 			//create.user
// 			//
// 			break;
//         case 'name':
//             database.ref().child('users')
//             .child(contacts[phone].role || 'employee').child(phone).child(contacts[phone].id).update({name: value})
//             break;
//         case 'location':
//             database.ref().child('users')
//             .child(contacts[phone].role || 'employee').child(phone).child(contacts[phone].id).update({location: value})
//             break;
//         case 'skills':
//             database.ref().child('users')
//             .child(contacts[phone].role || 'employee').child(phone).child(contacts[phone].id).update({skills: value})
//             break;
//         case 'hourly':
//             database.ref().child('users')
//             .child(contacts[phone].role || 'employee').child(phone).child(contacts[phone].id).update({hourly: value})
//             break;
// 	}
// 		db.JobPost.create(post)
// 					//i believe this is the spot i would put the filter for a complete form before posting
// 					.then(post => res.json(post))
// 					.catch(err => res.status(500).json(err));

//     // Get name
//     // Send it firebase
//     res.end();
// })})

router.get('/user', function (req, res) {
	var role = req.query.role;
	var phone = req.query.phone;
	db.User.findAll({
			where: {
				role: role || {
					$ne: null
				},
				phone: phone || {
					$ne: null
				},
			}
		})
		.then((users) => {
			res.json(users);
		})
})

// id
router.get('/user/:id', function (req, res) {
	var id = req.params.id;
	db.User.findById(id)
		.then((user) => {
			res.json(user);
		})
})

// create a user
router.post("/user", function (req, res) {
	console.log(req.body);
	db.User.create(req.body)
		.then(function (user) {
			res.json(user);
		}).catch(function (err) {
			res.json(err);
		})
})

// update a user
router.put("/user/:id", function (req, res) {
	var id = req.params.id;
	db.User.update(
			req.body, {
				//why a comma after body?
				//the answer is because  req.body, {}   are arguments inside teh function update
				where: {
					id: id
				}
			})
		.then(function (result) {
			// When updating with Sequelize, it will return us an array that only
			// contains one item. This item will only be either 1 or 0.
			// 1 stands for success
			// 0 means fuck off
			if (result[0]) {
				res.json({
					message: `Successfully updated user ${id}`
				});
			} else {
				res.status(403).json({
					message: `There is no such as user ${id}! You liar!`
				});
			}
		})
		.catch((err) => {
			res.status(500).json(err)
		})
})


// delete a user
router.delete("/user/:id", function (req, res) {
	var id = req.params.id;
	db.User.destroy({
			where: {
				id: id
			}
		})
		.then(function (result) {
			console.log(result)
			if (result) {
				res.json({
					message: `Successfully deleted user ${id}`
				});
			} else {
				res.status(403).json({
					message: `There is no such as user ${id}! You fibber!`
				});
			}
		})
		.catch((err) => {
			res.status(500).json(err)
		})
});

// Posts APIs
router.get('/posts', function (req, res) {
	db.JobPost.findAll({
			include: [{
				model: db.User,
				attributes: {
					exclude: ['password']
				}
			}]
		})
		.then((posts) => {
			const filteredPosts = posts.filter(post => post.hasFinishedCreation());
			res.json(filteredPosts);
		})
		.catch(err => res.status(500).json(err))
});

router.post('/posts', function (req, res) {
	const post = req.body.post;
	const userId = req.body.userId;
	post.UserId = userId;
	db.JobPost.create(post)
		.then(post => res.json(post))
		.catch(err => res.status(500).json(err))
});

router.post('/register', function (req, res) {
	const user = req.body.user;
	console.log(req.body);
	db.User.create(user)
		.then(user => {
			delete user.dataValues.password;
			res.json(user)
		})
		.catch(err => res.status(500).json(err))
})

router.post('/login', function (req, res) {
	const email = req.body.email;
	const password = req.body.password;
	db.User.findOne({
			where: {
				email
			}
		})
		.then(user => {
			if (user.password !== password) {
				res.status(401).json({
					message: 'You ain\'t no master'
				})
			}
			delete user.dataValues.password;
			res.json(user);
		})
		.catch(err => res.status(500).json(err))
})


// router.get('/index', function (){
//     res.send('/index.html')
// })
module.exports = router;