1376.sh

1376.sh

if [ "$1" = "1" ]
then

	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 employers;
		TRUNCATE folders;
		TRUNCATE folder_items;
EOFMYSQL
	php add_jobseeker.php 1 '{"status":"active","email_address":"[email protected]"}' && php add_cv.php 1 [email protected]
	php add_jobseeker.php 1 '{"status":"active","email_address":"[email protected]"}' && php add_cv.php 1 [email protected]

	php add_employer_with_creditbalance.php 1 [email protected] 12plok company1


	cd ~/Projects/sandiego
	./rebuild-solr.sh
else 

	mysql -uroot -p12plok roswell_development<<EOFMYSQL
		UPDATE jobseekers SET 
			created_datetime = DATE_ADD(created_datetime, INTERVAL -1 DAY ) , 
			vs_createddate	 = DATE_ADD(vs_createddate, INTERVAL -1 DAY ) , 
			vs_startdate	 = DATE_ADD(vs_startdate, INTERVAL -1 DAY ) , 
			updated_datetime = DATE_ADD(updated_datetime, INTERVAL -1 DAY ) ;
		UPDATE employers SET 
			created_datetime = DATE_ADD(created_datetime, INTERVAL -1 DAY ) , 
			updated_datetime = DATE_ADD(updated_datetime, INTERVAL -1 DAY ) ;
		UPDATE folders SET 
			created_datetime = DATE_ADD(created_datetime, INTERVAL -1 DAY ) , 
			updated_datetime = DATE_ADD(updated_datetime, INTERVAL -1 DAY ) ;
		UPDATE folder_items SET 
			created_datetime = DATE_ADD(created_datetime, INTERVAL -1 DAY ) , 
			updated_datetime = DATE_ADD(updated_datetime, INTERVAL -1 DAY ) ;

EOFMYSQL

	php ~/Projects/sandiego/platform/scripts/cron/reporting/reporting_tool.php
fi