/**
  * takes an associative array and creates a address
  *
  * @param array  $params (reference ) an assoc array of name/value pairs
  * @param boolean  $fixAddress   true if you need to fix (format) address values
  *                               before inserting in db
  *
  * @return array $blocks array of created address 
  * @access public
  * @static
  */
 static function create(&$params, $fixAddress, $entity = null)
 {
     if (!isset($params['address']) || !is_array($params['address'])) {
         return;
     }
     $addresses = array();
     $contactId = null;
     if (!$entity) {
         $contactId = $params['contact_id'];
         //get all the addresses for this contact
         $addresses = self::allAddress($contactId);
     } else {
         // get all address from location block
         $entityElements = array('entity_table' => $params['entity_table'], 'entity_id' => $params['entity_id']);
         $addresses = self::allEntityAddress($entityElements);
     }
     $isPrimary = $isBilling = true;
     $blocks = array();
     require_once "CRM/Core/BAO/Block.php";
     foreach ($params['address'] as $key => $value) {
         if (!is_array($value)) {
             continue;
         }
         if (!empty($addresses) && array_key_exists($value['location_type_id'], $addresses)) {
             $value['id'] = $addresses[$value['location_type_id']];
         }
         $addressExists = self::dataExists($value);
         if (isset($value['id']) && !$addressExists) {
             //delete the existing record
             CRM_Core_BAO_Block::blockDelete('Address', array('id' => $value['id']));
             continue;
         } else {
             if (!$addressExists) {
                 continue;
             }
         }
         if ($isPrimary && $value['is_primary']) {
             $isPrimary = false;
         } else {
             $value['is_primary'] = 0;
         }
         if ($isBilling && CRM_Utils_Array::value('is_billing', $value)) {
             $isBilling = false;
         } else {
             $value['is_billing'] = 0;
         }
         $value['contact_id'] = $contactId;
         $blocks[] = self::add($value, $fixAddress);
     }
     return $blocks;
 }

 public static function create($params)
 {
     $entityName = 'HRJob';
     $hook = empty($params['id']) ? 'create' : 'edit';
     if (is_numeric(CRM_Utils_Array::value('is_primary', $params)) || empty($params['id'])) {
         CRM_Core_BAO_Block::handlePrimary($params, get_class());
     }
     CRM_Utils_Hook::pre($hook, $entityName, CRM_Utils_Array::value('id', $params), $params);
     $instance = new self();
     $instance->copyValues($params);
     $instance->save();
     $resultRoleGet = civicrm_api3('HRJobRole', 'get', array('job_id' => $instance->id, 'title' => $instance->title));
     $duplicate = CRM_Utils_Array::value('action', $params, $hook);
     if ($hook == 'create' && $resultRoleGet['count'] == 0 && $duplicate != 'duplicate') {
         civicrm_api3('HRJobRole', 'create', array('job_id' => $instance->id, 'title' => $instance->title, 'location' => $instance->location, 'percent_pay_role' => 100));
     }
     CRM_Utils_Hook::post($hook, $entityName, $instance->id, $instance);
     return $instance;
 }

 /**
  * Delete billing address record related contribution.
  *
  * @param int $contributionId
  * @param int $contactId
  */
 public static function deleteAddress($contributionId = NULL, $contactId = NULL)
 {
     $clauses = array();
     $contactJoin = NULL;
     if ($contributionId) {
         $clauses[] = "cc.id = {$contributionId}";
     }
     if ($contactId) {
         $clauses[] = "cco.id = {$contactId}";
         $contactJoin = "INNER JOIN civicrm_contact cco ON cc.contact_id = cco.id";
     }
     if (empty($clauses)) {
         CRM_Core_Error::fatal();
     }
     $condition = implode(' OR ', $clauses);
     $query = "\nSELECT     ca.id\nFROM       civicrm_address ca\nINNER JOIN civicrm_contribution cc ON cc.address_id = ca.id\n           {$contactJoin}\nWHERE      {$condition}\n";
     $dao = CRM_Core_DAO::executeQuery($query);
     while ($dao->fetch()) {
         $params = array('id' => $dao->id);
         CRM_Core_BAO_Block::blockDelete('Address', $params);
     }
 }

 /**
  * Delete all the block associated with the location
  *
  * @param  int  $contactId      contact id
  * @param  int  $locationTypeId id of the location to delete
  *
  * @return void
  * @access public
  * @static
  */
 static function deleteLocationBlocks($contactId, $locationTypeId)
 {
     // ensure that contactId has a value
     if (empty($contactId) || !CRM_Utils_Rule::positiveInteger($contactId)) {
         CRM_Core_Error::fatal();
     }
     if (empty($locationTypeId) || !CRM_Utils_Rule::positiveInteger($locationTypeId)) {
         // so we only delete the blocks which DO NOT have a location type Id
         // CRM-3581
         $locationTypeId = 'null';
     }
     static $blocks = array('Address', 'Phone', 'IM', 'OpenID', 'Email');
     $params = array('contact_id' => $contactId, 'location_type_id' => $locationTypeId);
     foreach ($blocks as $name) {
         CRM_Core_BAO_Block::blockDelete($name, $params);
     }
 }

 /**
  * Takes an associative array and adds address.
  *
  * @param array $params
  *   (reference ) an assoc array of name/value pairs.
  * @param bool $fixAddress
  *   True if you need to fix (format) address values.
  *                               before inserting in db
  *
  * @return CRM_Core_BAO_Address|null
  */
 public static function add(&$params, $fixAddress)
 {
     static $customFields = NULL;
     $address = new CRM_Core_DAO_Address();
     // fixAddress mode to be done
     if ($fixAddress) {
         CRM_Core_BAO_Address::fixAddress($params);
     }
     $hook = empty($params['id']) ? 'create' : 'edit';
     CRM_Utils_Hook::pre($hook, 'Address', CRM_Utils_Array::value('id', $params), $params);
     // if id is set & is_primary isn't we can assume no change
     if (is_numeric(CRM_Utils_Array::value('is_primary', $params)) || empty($params['id'])) {
         CRM_Core_BAO_Block::handlePrimary($params, get_class());
     }
     $config = CRM_Core_Config::singleton();
     $address->copyValues($params);
     $address->save();
     if ($address->id) {
         if (!$customFields) {
             $customFields = CRM_Core_BAO_CustomField::getFields('Address', FALSE, TRUE);
         }
         if (!empty($customFields)) {
             $addressCustom = CRM_Core_BAO_CustomField::postProcess($params, $address->id, 'Address', TRUE);
         }
         if (!empty($addressCustom)) {
             CRM_Core_BAO_CustomValueTable::store($addressCustom, 'civicrm_address', $address->id);
         }
         //call the function to sync shared address
         self::processSharedAddress($address->id, $params);
         // call the function to create shared relationships
         // we only create create relationship if address is shared by Individual
         if (!CRM_Utils_System::isNull($address->master_id)) {
             self::processSharedAddressRelationship($address->master_id, $params);
         }
         // lets call the post hook only after we've done all the follow on processing
         CRM_Utils_Hook::post($hook, 'Address', $address->id, $address);
     }
     return $address;
 }

 /**
  * Given the list of params in the params array, fetch the object
  * and store the values in the values array
  *
  * @param array entityBlock input parameters to find object
  *
  * @return array    array of phone objects
  * @access public
  * @static
  */
 static function &getValues($entityBlock)
 {
     $getValues = CRM_Core_BAO_Block::getValues('phone', $entityBlock);
     return $getValues;
 }

 /**
  * Given the list of params in the params array, fetch the object
  * and store the values in the values array
  *
  * @param array $entityBlock input parameters to find object
  *
  * @return bool
  */
 public static function &getValues($entityBlock)
 {
     return CRM_Core_BAO_Block::getValues('im', $entityBlock);
 }

 /**
  * Process the form.
  */
 public function postProcess()
 {
     $params = $this->exportValues();
     // Process / save openID
     $params['contact_id'] = $this->_contactId;
     $params['updateBlankLocInfo'] = TRUE;
     $params['openid']['isIdSet'] = TRUE;
     foreach ($this->_openids as $count => $value) {
         if (!empty($value['id']) && isset($params['openid'][$count])) {
             $params['openid'][$count]['id'] = $value['id'];
         }
     }
     CRM_Core_BAO_Block::create('openid', $params);
     $this->log();
     $this->response();
 }

 /**
  * takes an associative array and creates a address
  *
  * @param array  $params (reference ) an assoc array of name/value pairs
  * @param boolean  $fixAddress   true if you need to fix (format) address values
  *                               before inserting in db
  *
  * @return array $blocks array of created address 
  * @access public
  * @static
  */
 static function create(&$params, $fixAddress, $entity = null)
 {
     if (!isset($params['address']) || !is_array($params['address'])) {
         return;
     }
     $addresses = array();
     $contactId = null;
     $updateBlankLocInfo = CRM_Utils_Array::value('updateBlankLocInfo', $params, false);
     if (!$entity) {
         $contactId = $params['contact_id'];
         //get all the addresses for this contact
         $addresses = self::allAddress($contactId, $updateBlankLocInfo);
     } else {
         // get all address from location block
         $entityElements = array('entity_table' => $params['entity_table'], 'entity_id' => $params['entity_id']);
         $addresses = self::allEntityAddress($entityElements);
     }
     $isPrimary = $isBilling = true;
     $blocks = array();
     require_once "CRM/Core/BAO/Block.php";
     foreach ($params['address'] as $key => $value) {
         if (!is_array($value)) {
             continue;
         }
         $addressExists = self::dataExists($value);
         if ($updateBlankLocInfo) {
             if ((!empty($addresses) || !$addressExists) && array_key_exists($key, $addresses)) {
                 $value['id'] = $addresses[$key];
             }
         } else {
             if (!empty($addresses) && array_key_exists($value['location_type_id'], $addresses)) {
                 $value['id'] = $addresses[$value['location_type_id']];
             }
         }
         // Note there could be cases when address info already exist ($value[id] is set) for a contact/entity
         // BUT info is not present at this time, and therefore we should be really careful when deleting the block.
         // $updateBlankLocInfo will help take appropriate decision. CRM-5969
         if (isset($value['id']) && !$addressExists && $updateBlankLocInfo) {
             //delete the existing record
             CRM_Core_BAO_Block::blockDelete('Address', array('id' => $value['id']));
             continue;
         } else {
             if (!$addressExists) {
                 continue;
             }
         }
         if ($isPrimary && $value['is_primary']) {
             $isPrimary = false;
         } else {
             $value['is_primary'] = 0;
         }
         if ($isBilling && CRM_Utils_Array::value('is_billing', $value)) {
             $isBilling = false;
         } else {
             $value['is_billing'] = 0;
         }
         $value['contact_id'] = $contactId;
         $blocks[] = self::add($value, $fixAddress);
     }
     return $blocks;
 }

 /**
  * Given the list of params in the params array, fetch the object
  * and store the values in the values array
  *
  * @param array $params        input parameters to find object
  * @param array $values        output values of the object
  * @param array $ids           the array that holds all the db ids
  * @param int   $blockCount    number of blocks to fetch
  *
  * @return array    array of phone objects
  * @access public
  * @static
  */
 function &getValues(&$params, &$values, &$ids, $blockCount = 0)
 {
     $phone =& new CRM_Core_BAO_Phone();
     $getValues =& CRM_Core_BAO_Block::getValues($phone, 'phone', $params, $values, $ids, $blockCount);
     foreach ($values['phone'] as $key => $array) {
         CRM_Core_DAO_Phone::addDisplayEnums($values['phone'][$key]);
     }
     return $getValues;
 }

 /**
  * process the form
  *
  * @return void
  * @access public
  */
 public function postProcess()
 {
     $params = $this->exportValues();
     // need to process / save emails
     $params['contact_id'] = $this->_contactId;
     $params['updateBlankLocInfo'] = TRUE;
     // save email changes
     CRM_Core_BAO_Block::create('email', $params);
     // make entry in log table
     CRM_Core_BAO_Log::register($this->_contactId, 'civicrm_contact', $this->_contactId);
     $response = array('status' => 'save');
     $this->postProcessHook();
     echo json_encode($response);
     CRM_Utils_System::civiExit();
 }

 /**
  * Given the list of params in the params array, fetch the object
  * and store the values in the values array
  *
  * @param array $params        input parameters to find object
  * @param array $values        output values of the object
  * @param array $ids           the array that holds all the db ids
  * @param int   $blockCount    number of blocks to fetch
  *
  * @return boolean
  * @access public
  * @static
  */
 function &getValues(&$params, &$values, &$ids, $blockCount = 0)
 {
     $email =& new CRM_Core_BAO_Email();
     return CRM_Core_BAO_Block::getValues($email, 'email', $params, $values, $ids, $blockCount);
 }

 /**
  * Process the form.
  */
 public function postProcess()
 {
     $params = $this->exportValues();
     // Process / save emails
     $params['contact_id'] = $this->_contactId;
     $params['updateBlankLocInfo'] = TRUE;
     $params['email']['isIdSet'] = TRUE;
     foreach ($this->_emails as $count => $value) {
         if (!empty($value['id']) && isset($params['email'][$count])) {
             $params['email'][$count]['id'] = $value['id'];
         }
     }
     CRM_Core_BAO_Block::create('email', $params);
     // If contact has no name, set primary email as display name
     // TODO: This should be handled in the BAO for the benefit of the api, etc.
     if (!$this->contactHasName) {
         foreach ($params['email'] as $email) {
             if ($email['is_primary']) {
                 CRM_Core_DAO::setFieldValue('CRM_Contact_DAO_Contact', $this->_contactId, 'display_name', $email['email']);
                 CRM_Core_DAO::setFieldValue('CRM_Contact_DAO_Contact', $this->_contactId, 'sort_name', $email['email']);
                 $this->ajaxResponse['reloadBlocks'] = array('#crm-contactname-content');
                 break;
             }
         }
     }
     $this->log();
     $this->response();
 }

 /**
  * Function to cleanup Contact locations
  * Basically we need to delete unwanted location types for a contact in Edit mode
  * create() is also called by createProfileContact(), in that case we should preserve other location type's,
  * This is a special case where we need to delete location types that are not submitted.
  * 
  * @param array $params associated array of formatted params
  * @return void
  * @static
  */
 static function cleanupContactLocations($params)
 {
     //get the contact id from params
     $contactId = CRM_Utils_Array::value('contact_id', $params);
     // get existing locations
     $deleteBlocks = array();
     $dbBlockValues = self::getValues(array('contact_id' => $contactId));
     foreach (self::$blocks as $block) {
         if (!is_array($dbBlockValues[$block])) {
             continue;
         }
         foreach ($dbBlockValues[$block] as $dbCount => $dbValues) {
             if (!is_array($params[$block])) {
                 $deleteBlocks[$block] = $dbBlockValues[$block];
                 continue;
             }
             $valueSubmitted = false;
             foreach ($params[$block] as $submitCount => $submitValues) {
                 if ($submitValues['location_type_id'] == $dbValues['location_type_id']) {
                     //unset from submitted since we map it across db.
                     unset($params[$block][$submitCount]);
                     $valueSubmitted = true;
                     break;
                 }
             }
             //since this value not present in submit params.
             if (!$valueSubmitted) {
                 $deleteBlocks[$block][$dbCount] = $dbValues;
             }
         }
     }
     //finally delete unwanted blocks.
     foreach ($deleteBlocks as $blockName => $blockValues) {
         if (!is_array($blockValues)) {
             continue;
         }
         foreach ($blockValues as $count => $deleteBlock) {
             CRM_Core_BAO_Block::blockDelete($blockName, $deleteBlock);
         }
     }
 }

 /**
  * Process the form.
  *
  * @return void
  */
 public function postProcess()
 {
     $params = $this->exportValues();
     // Process / save openID
     $params['contact_id'] = $this->_contactId;
     $params['updateBlankLocInfo'] = TRUE;
     CRM_Core_BAO_Block::create('openid', $params);
     $this->log();
     $this->response();
 }

 /**
  * Given the list of params in the params array, fetch the object
  * and store the values in the values array
  *
  * @param array $entityBlock   input parameters to find object
  *
  * @return boolean
  * @access public
  * @static
  */
 static function &getValues($entityBlock)
 {
     return CRM_Core_BAO_Block::getValues('email', $entityBlock);
 }

 /**                                                           
  * Delete billing address record related contribution
  * @param int $contact_id contact id 
  * @param int $contribution_id contributionId 
  * @access public 
  * @static 
  */
 static function deleteAddress($contributionId = null, $contactId = null)
 {
     $contributionCond = $contactCond = 'null';
     if ($contributionId) {
         $contributionCond = "cc.id = {$contributionId}";
     }
     if ($contactId) {
         $contactCond = "cco.id = {$contactId}";
     }
     $query = "\nSELECT ca.id FROM \ncivicrm_address ca \nLEFT JOIN civicrm_contribution cc ON cc.address_id = ca.id \nLEFT JOIN civicrm_contact cco ON cc.contact_id = cco.id \nWHERE ( {$contributionCond}  OR {$contactCond} )";
     $dao = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
     while ($dao->fetch()) {
         require_once "CRM/Core/BAO/Block.php";
         $params = array('id' => $dao->id);
         CRM_Core_BAO_Block::blockDelete('Address', $params);
     }
 }

 /**
  * Given the list of params in the params array, fetch the object
  * and store the values in the values array
  *
  * @param array $params        input parameters to find object
  * @param array $values        output values of the object
  * @param array $ids           the array that holds all the db ids
  * @param int   $blockCount    number of blocks to fetch
  *
  * @return boolean
  * @access public
  * @static
  */
 function &getValues(&$params, &$values, &$ids, $blockCount = 0)
 {
     $im =& new CRM_Core_BAO_IM();
     return CRM_Core_BAO_Block::getValues($im, 'im', $params, $values, $ids, $blockCount);
 }