/**
* Create basic DB data such as civicrm settings and options.
*/
protected function _createDBData()
{
// Creating civicrm settings:
CRM_Core_DAO::executeQuery("INSERT IGNORE INTO `civicrm_setting` (`group_name`, `name`, `value`, `domain_id`, `contact_id`, `is_domain`, `component_id`, `created_date`, `created_id`) VALUES\n ('hrjob', 'work_days_per_month', 'i:22;', 1, NULL, 1, NULL, '2014-12-01 03:01:02', NULL),\n ('hrjob', 'work_days_per_week', 'i:5;', 1, NULL, 1, NULL, '2014-12-01 03:01:02', NULL),\n ('hrjob', 'work_hour_per_day', 'i:8;', 1, NULL, 1, NULL, '2014-12-01 03:01:02', NULL),\n ('hrjob', 'work_months_per_year', 'i:12;', 1, NULL, 1, NULL, '2014-12-01 03:01:02', NULL),\n ('hrjob', 'work_weeks_per_year', 'i:50;', 1, NULL, 1, NULL, '2014-12-01 03:01:02', NULL)");
//Creating civicrm options:
CRM_Core_DAO::executeQuery("INSERT IGNORE INTO `civicrm_option_group` (`id`, `name`, `title`, `description`, `is_reserved`, `is_active`, `is_locked`) VALUES\n (100, 'hrjc_contract_type', 'Contract Type', NULL, 1, 1, NULL),\n (101, 'hrjc_level_type', 'Level', NULL, 1, 1, NULL),\n (102, 'hrjc_department', 'Department', NULL, 1, 1, NULL),\n (103, 'hrjc_hours_type', 'Hours Type', NULL, 1, 1, NULL),\n (104, 'hrjc_pay_scale', 'Pay Scale', NULL, 1, 1, NULL),\n (105, 'hrjc_pay_grade', 'Pay Grade', NULL, 1, 1, NULL),\n (108, 'hrjc_location', 'Work Location', NULL, 1, 1, NULL),\n (109, 'hrjc_pension_type', 'Pension Type', NULL, 1, 1, NULL),\n (110, 'hrjc_region', 'Region', NULL, 1, 1, NULL)");
CRM_CORE_DAO::executeQuery("INSERT IGNORE INTO `civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`) VALUES\n (821, 100, 'Employee - Temporary', 'Employee - Temporary', 'Employee_Temporary', NULL, NULL, 0, 3, NULL, 0, 0, 0, NULL, NULL, NULL),\n (822, 100, 'Employee - Permanent', 'Employee - Permanent', 'Employee_Permanent', NULL, NULL, 0, 4, NULL, 0, 0, 0, NULL, NULL, NULL),\n (823, 100, 'Contractor', 'Contractor', 'Contractor', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL),\n (824, 100, 'Volunteer', 'Volunteer', 'Volunteer', NULL, NULL, 0, 7, NULL, 0, 0, 0, NULL, NULL, NULL),\n (825, 100, 'Trustee', 'Trustee', 'Trustee', NULL, NULL, 0, 6, NULL, 0, 0, 0, NULL, NULL, NULL),\n (826, 100, 'Intern', 'Intern', 'Intern', NULL, NULL, 0, 5, NULL, 0, 0, 0, NULL, NULL, NULL),\n (827, 100, 'Apprentice', 'Apprentice', 'Apprentice', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (828, 101, 'Senior Manager', 'Senior Manager', 'Senior_Manager', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (829, 101, 'Junior Manager', 'Junior Manager', 'Junior_Manager', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL),\n (830, 101, 'Senior Staff', 'Senior Staff', 'Senior_Staff', NULL, NULL, 0, 3, NULL, 0, 0, 0, NULL, NULL, NULL),\n (831, 101, 'Junior Staff', 'Junior Staff', 'Junior_Staff', NULL, NULL, 0, 4, NULL, 0, 0, 0, NULL, NULL, NULL),\n (844, 102, 'Finance', 'Finance', 'Finance', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (845, 102, 'HR', 'HR', 'HR', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL),\n (846, 102, 'IT', 'IT', 'IT', NULL, NULL, 0, 3, NULL, 0, 0, 0, NULL, NULL, NULL),\n (847, 102, 'Fundraising', 'Fundraising', 'Fundraising', NULL, NULL, 0, 4, NULL, 0, 0, 0, NULL, NULL, NULL),\n (848, 102, 'Marketing', 'Marketing', 'Marketing', NULL, NULL, 0, 5, NULL, 0, 0, 0, NULL, NULL, NULL),\n (832, 103, 'Full Time', '8', 'Full_Time', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (833, 103, 'Part Time', '4', 'Part_Time', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL),\n (834, 103, 'Casual', '0', 'Casual', NULL, NULL, 0, 3, NULL, 0, 0, 0, NULL, NULL, NULL),\n (835, 104, 'NJC pay scale', 'NJC pay scale', 'NJC pay scale', NULL, NULL, 1, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (836, 104, 'JNC pay scale', 'JNC pay scale', 'JNC pay scale', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL),\n (837, 104, 'Soulbury Pay Agreement', 'Soulbury Pay Agreement', 'Soulbury Pay Agreement', NULL, NULL, 0, 3, NULL, 0, 0, 0, NULL, NULL, NULL),\n (838, 105, 'Unpaid', '0', 'Unpaid', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (839, 105, 'Paid', '1', 'Paid', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL),\n (840, 106, 'Unknown', 'Unknown', 'Unknown', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (841, 107, 'Unknown', 'Unknown', 'Unknown', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (842, 108, 'Headquarters', 'Headquarters', 'Headquarters', NULL, NULL, 1, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (843, 108, 'Home or Home-Office', 'Home', 'Home', NULL, NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (849, 109, 'Employer Pension', 'Employer Pension', 'Employer Pension ', NULL, NULL, 1, 1, NULL, 0, 0, 0, NULL, NULL, NULL),\n (850, 109, 'Personal Pension', 'Personal Pension', 'Personal Pension', NULL, NULL, 0, 2, NULL, 0, 0, 0, NULL, NULL, NULL)");
// Creating test user:
CRM_Core_DAO::executeQuery("INSERT IGNORE INTO `civicrm_contact` (`id`, `contact_type`, `contact_sub_type`, `do_not_email`, `do_not_phone`, `do_not_mail`, `do_not_sms`, `do_not_trade`, `is_opt_out`, `legal_identifier`, `external_identifier`, `sort_name`, `display_name`, `nick_name`, `legal_name`, `image_URL`, `preferred_communication_method`, `preferred_language`, `preferred_mail_format`, `hash`, `api_key`, `source`, `first_name`, `middle_name`, `last_name`, `prefix_id`, `suffix_id`, `formal_title`, `communication_style_id`, `email_greeting_id`, `email_greeting_custom`, `email_greeting_display`, `postal_greeting_id`, `postal_greeting_custom`, `postal_greeting_display`, `addressee_id`, `addressee_custom`, `addressee_display`, `job_title`, `gender_id`, `birth_date`, `is_deceased`, `deceased_date`, `household_name`, `primary_contact_id`, `organization_name`, `sic_code`, `user_unique_id`, `employer_id`, `is_deleted`, `created_date`, `modified_date`) VALUES\n (229, 'Individual', NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Anderson, Amy', 'Amy Anderson', NULL, NULL, NULL, NULL, NULL, 'Both', NULL, NULL, NULL, 'Amy', 'X', 'Anderson', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2014-12-01 14:01:28', '2014-12-01 14:01:28')");
// Creating test provider:
CRM_Core_DAO::executeQuery("INSERT IGNORE INTO `civicrm_contact` (`id`, `contact_type`, `contact_sub_type`, `do_not_email`, `do_not_phone`, `do_not_mail`, `do_not_sms`, `do_not_trade`, `is_opt_out`, `legal_identifier`, `external_identifier`, `sort_name`, `display_name`, `nick_name`, `legal_name`, `image_URL`, `preferred_communication_method`, `preferred_language`, `preferred_mail_format`, `hash`, `api_key`, `source`, `first_name`, `middle_name`, `last_name`, `prefix_id`, `suffix_id`, `formal_title`, `communication_style_id`, `email_greeting_id`, `email_greeting_custom`, `email_greeting_display`, `postal_greeting_id`, `postal_greeting_custom`, `postal_greeting_display`, `addressee_id`, `addressee_custom`, `addressee_display`, `job_title`, `gender_id`, `birth_date`, `is_deceased`, `deceased_date`, `household_name`, `primary_contact_id`, `organization_name`, `sic_code`, `user_unique_id`, `employer_id`, `is_deleted`, `created_date`, `modified_date`) VALUES\n (158, 'Individual', NULL, 0, 0, 0, 0, 1, 0, NULL, NULL, 'Adams, Angelika', 'Dr. Angelika Adams', NULL, NULL, NULL, NULL, NULL, 'Both', '347992528', NULL, 'Sample Data', 'Angelika', 'O', 'Adams', 4, NULL, NULL, NULL, 1, NULL, 'Dear Angelika', 1, NULL, 'Dear Angelika', 1, NULL, 'Dr. Angelika Adams', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2014-10-07 23:28:02')");
// Creating test provider_life_insurance:
CRM_Core_DAO::executeQuery("INSERT IGNORE INTO `civicrm_contact` (`id`, `contact_type`, `contact_sub_type`, `do_not_email`, `do_not_phone`, `do_not_mail`, `do_not_sms`, `do_not_trade`, `is_opt_out`, `legal_identifier`, `external_identifier`, `sort_name`, `display_name`, `nick_name`, `legal_name`, `image_URL`, `preferred_communication_method`, `preferred_language`, `preferred_mail_format`, `hash`, `api_key`, `source`, `first_name`, `middle_name`, `last_name`, `prefix_id`, `suffix_id`, `formal_title`, `communication_style_id`, `email_greeting_id`, `email_greeting_custom`, `email_greeting_display`, `postal_greeting_id`, `postal_greeting_custom`, `postal_greeting_display`, `addressee_id`, `addressee_custom`, `addressee_display`, `job_title`, `gender_id`, `birth_date`, `is_deceased`, `deceased_date`, `household_name`, `primary_contact_id`, `organization_name`, `sic_code`, `user_unique_id`, `employer_id`, `is_deleted`, `created_date`, `modified_date`) VALUES\n (284, 'Individual', NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Anderson, Cristina', 'Cristina Anderson', NULL, NULL, NULL, NULL, NULL, 'Both', NULL, NULL, NULL, 'Cristina', '', 'Anderson', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2014-12-01 14:02:19', '2014-12-01 14:02:19')");
}
/**
* Class constructor
*
* @access private
*/
function __construct()
{
global $civicrm_root;
$config = CRM_Core_Config::singleton();
$localfile = $civicrm_root . DIRECTORY_SEPARATOR . self::LOCALFILE_NAME;
$cachefile = $config->uploadDir . self::CACHEFILE_NAME;
if (file_exists($localfile)) {
require_once $localfile;
if (function_exists('civicrmVersion')) {
$info = civicrmVersion();
$this->localVersion = trim($info['version']);
}
}
if ($config->versionCheck) {
$expiryTime = time() - self::CACHEFILE_EXPIRE;
// if there's a cachefile and it's not stale use it to
// read the latestVersion, else read it from the Internet
if (file_exists($cachefile) && filemtime($cachefile) > $expiryTime) {
$this->latestVersion = trim(file_get_contents($cachefile));
} else {
$siteKey = md5(defined('CIVICRM_SITE_KEY') ? CIVICRM_SITE_KEY : '');
$this->stats = array('hash' => md5($siteKey . $config->userFrameworkBaseURL), 'version' => $this->localVersion, 'uf' => $config->userFramework, 'lang' => $config->lcMessages, 'co' => $config->defaultContactCountry, 'ufv' => $config->userFrameworkVersion, 'PHP' => phpversion(), 'MySQL' => CRM_CORE_DAO::singleValueQuery('SELECT VERSION()'), 'communityMessagesUrl' => CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME, 'communityMessagesUrl', NULL, '*default*'));
// Add usage stats
$this->payProcStats();
$this->entityStats();
$this->extensionStats();
// Get the latest version and send site info
$this->pingBack();
// Update cache file
if ($this->latestVersion) {
$fp = @fopen($cachefile, 'w');
if (!$fp) {
if (CRM_Core_Permission::check('administer CiviCRM')) {
CRM_Core_Session::setStatus(ts('Unable to write file') . ":{$cachefile}<br />" . ts('Please check your system file permissions.'), ts('File Error'), 'error');
}
return;
}
fwrite($fp, $this->latestVersion);
fclose($fp);
}
}
}
}
/**
* Collect info about the site to be sent as pingback data.
*/
private function getSiteStats()
{
$config = CRM_Core_Config::singleton();
$siteKey = md5(defined('CIVICRM_SITE_KEY') ? CIVICRM_SITE_KEY : '');
// Calorie-free pingback for alphas
$this->stats = array('version' => $this->localVersion);
// Non-alpha versions get the full treatment
if ($this->localVersion && !strpos($this->localVersion, 'alpha')) {
$this->stats += array('hash' => md5($siteKey . $config->userFrameworkBaseURL), 'uf' => $config->userFramework, 'lang' => $config->lcMessages, 'co' => $config->defaultContactCountry, 'ufv' => $config->userSystem->getVersion(), 'PHP' => phpversion(), 'MySQL' => CRM_CORE_DAO::singleValueQuery('SELECT VERSION()'), 'communityMessagesUrl' => Civi::settings()->get('communityMessagesUrl'));
$this->getPayProcStats();
$this->getEntityStats();
$this->getExtensionStats();
}
}
