2404.sh

cd ~/Projects/sandiego/platform/scripts

mysql -uroot -p12plok reporting_development<<EOFMYSQL
	TRUNCATE TABLE reporting_tool_values;
EOFMYSQL

mysql -uroot -p12plok roswell_development<<EOFMYSQL
	TRUNCATE jobseekers;
	TRUNCATE file_cvs;
EOFMYSQL
php add_jobseeker.php 1 '{"status":"active","email_address":"[email protected]"}' && php add_file_cv.php 1 [email protected]
php add_jobseeker.php 1 '{"status":"active","email_address":"[email protected]"}' && php add_file_cv.php 1 [email protected]

mysql -uroot -p12plok roswell_development<<EOFMYSQL
	UPDATE jobseekers SET 
		created_datetime = DATE_ADD(CURDATE(), INTERVAL -1 DAY ) , 
		vs_createddate	 = DATE_ADD(CURDATE(), INTERVAL -1 DAY ) , 
		vs_startdate	 = DATE_ADD(CURDATE(), INTERVAL -1 DAY ) , 
		updated_datetime = DATE_ADD(CURDATE(), INTERVAL -1 DAY ) ;
	UPDATE form_cvs SET 
		created_datetime = DATE_ADD(CURDATE(), INTERVAL -1 DAY ) , 
		updated_datetime = DATE_ADD(CURDATE(), INTERVAL -1 DAY ) ;
EOFMYSQL
cd ~/Projects/sandiego
php ~/Projects/sandiego/platform/scripts/cron/reporting/reporting_tool.php