/trunk/manage/controllers/people/controller.php
PHP | 1499 lines | 1238 code | 148 blank | 113 comment | 219 complexity | a35f827ed0fd860c907f60affd84327f MD5 | raw file
Possible License(s): LGPL-2.1
Large files files are truncated, but you can click here to view the full file
- <?php
-
- class Peoplecontroller{
-
- private $registry;
-
- public function __construct( PeacockCarterFrameworkRegistry $registry, $directCall )
- {
- $this->registry = $registry;
- if( $this->registry->getObject('authenticate')->isAuthorised('users') == true )
- {
- $this->registry->getObject('adminmenubuilder')->buildMenu( 'people' );
- if( $this->registry->getURLBit(1) != '' )
- {
- switch( $this->registry->getURLBit(1) )
- {
- case 'toggle-admin':
- $this->toggleAdministrator( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'toggle-active':
- $this->toggleActive( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'create':
- $this->createUser();
- break;
- case 'create-member':
- $this->createMember();
- break;
- case 'delete':
- $this->deleteUser( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'delete-group':
- $this->deleteGroup( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'edit':
- $this->editUser( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'edit-member':
- $this->editMember( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'edit-group':
- $this->editGroup( intval( $this->registry->getURLBit(2) ) );
- break;
- case 'create-group':
- $this->createGroup();
- break;
- case 'groups':
- $this->listGroups();
- break;
- default:
- break;
- }
- }
- else
- {
- $this->listPeople();
- }
- }
- else
- {
- $this->registry->getObject('authenticate')->redirectToAuthorised('primary');
- }
-
- }
-
- private function listGroups()
- {
- $sql = "SELECT * FROM groups WHERE deleted = 0";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'groups', array( 'SQL', $cache ) );
- $this->registry->getObject('template')->buildFromTemplates( 'header.tpl.php', 'people/listgroups.tpl.php', 'footer.tpl.php' );
- }
-
- private function createGroup()
- {
- if( isset( $_POST['create_group'] ) )
- {
- $insert = array();
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['name'] );
- $insert['deleted'] = 0;
- $this->registry->getObject('db')->insertRecords( 'groups', $insert );
- $id = $this->registry->getObject('db')->lastInsertID();
-
- if( isset( $_POST['permission'] ) && is_array( $_POST['permission'] ) && count( $_POST['permission'] ) > 0 )
- {
- $sql = "INSERT INTO permission_group_associations (`permission`, `group` ) VALUES ";
- foreach( $_POST['permission'] as $pid )
- {
- $sql .= " ({$pid}, {$id} ),";
- }
- // remove last char from sql
- $sql = substr_replace($sql ,"",-1);
- $this->registry->getObject('db')->executeQuery( $sql );
- }
-
- $this->registry->redirectUser( array('people', 'groups'), 'Group created', 'The group has been saved.', true );
-
- }
- else
- {
- $sql = "SELECT code as outer_code, description as area FROM permissions WHERE code REGEXP '^[A-Za-z0-9]+$'";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'areas', array( 'SQL', $cache ) );
-
- $sql = "SELECT p.ID as inner_perm_id, p.description as perm_description, p.code FROM permissions p ORDER BY p.code ASC";
- $this->registry->getObject('db')->executeQuery( $sql );
- $inner = array();
- while ( $row = $this->registry->getObject('db')->getRows() )
- {
- $code = explode( '_', $row['code'] );
- if( isset( $inner[ $code[0] ] ) )
- {
- $inner[ $code[0] ][] = $row;
- }
- else
- {
- $inner[ $code[0] ] = array();
- $inner[ $code[0] ][] = $row;
- }
- }
- foreach( $inner as $code => $data )
- {
- $cache = $this->registry->getObject('db')->cacheData( $data );
- $this->registry->getObject('template')->getPage()->addTag( 'permissions-' . $code , array( 'DATA', $cache ) );
- }
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/creategroup.tpl.php', 'footer.tpl.php');
-
-
- }
- }
-
- private function editGroup( $id )
- {
- if( isset( $_POST['edit_group'] ) )
- {
- $insert = array();
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['name'] );
- $this->registry->getObject('db')->updateRecords( 'groups', $insert, 'ID=' . $id );
-
- if( isset( $_POST['permission'] ) && is_array( $_POST['permission'] ) && count( $_POST['permission'] ) > 0 )
- {
- $sql = "DELETE FROM permission_group_associations WHERE `group`=" .$id;
- $this->registry->getObject('db')->executeQuery( $sql );
-
- $sql = "INSERT INTO permission_group_associations (`permission`, `group` ) VALUES ";
- foreach( $_POST['permission'] as $pid )
- {
- $sql .= " ({$pid}, {$id} ),";
- }
- // remove last char from sql
- $sql = substr_replace($sql ,"",-1);
- $this->registry->getObject('db')->executeQuery( $sql );
- }
-
- $this->registry->redirectUser( array('people', 'groups'), 'Group edited', 'Changes to the group have been saved', true );
-
- }
- else
- {
- $sql = "SELECT * FROM groups WHERE ID=" . $id;
- $this->registry->getObject('db')->executeQuery( $sql );
- $data = $this->registry->getObject('db')->getRows();
- $this->registry->getObject('template')->dataToTags( $data, 'group_' );
-
- $sql = "SELECT code as outer_code, description as area FROM permissions WHERE code REGEXP '^[A-Za-z0-9]+$'";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'areas', array( 'SQL', $cache ) );
-
- $sql = "SELECT IF( (SELECT COUNT(*) FROM permission_group_associations a WHERE a.group={$id} AND a.permission=p.ID)>0 ,'checked=\'checked\'','' ) as checker, p.ID as inner_perm_id, p.description as perm_description, p.code FROM permissions p ORDER BY p.code ASC";
- $this->registry->getObject('db')->executeQuery( $sql );
- $inner = array();
- while ( $row = $this->registry->getObject('db')->getRows() )
- {
- $code = explode( '_', $row['code'] );
- if( isset( $inner[ $code[0] ] ) )
- {
- $inner[ $code[0] ][] = $row;
- }
- else
- {
- $inner[ $code[0] ] = array();
- $inner[ $code[0] ][] = $row;
- }
- }
- foreach( $inner as $code => $data )
- {
- $cache = $this->registry->getObject('db')->cacheData( $data );
- $this->registry->getObject('template')->getPage()->addTag( 'permissions-' . $code , array( 'DATA', $cache ) );
- }
-
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/editgroup.tpl.php', 'footer.tpl.php');
-
- }
- }
-
- private function deleteGroup( $id )
- {
- $sql = "UPDATE groups SET deleted=1 WHERE ID={$id}";
- $this->registry->getObject('db')->executeQuery( $sql );
- $this->registry->redirectUser( array('people', 'groups'), 'Group deleted', 'The user group has been removed from the system', true );
- }
-
- private function listPeople()
- {
- $sql = "SELECT ID as uid, IF( admin > 0, 'N/A', IF( member > 0, 'Yes', 'No' ) ) as member, ABS(admin-1) as newadmin, ABS(active-1) as newactive, ( SELECT GROUP_CONCAT(g.name SEPARATOR ', ' ) FROM groups g, group_memberships m WHERE g.ID=m.group AND m.user=u.ID AND g.deleted = 0) as groups, username, name, email, active, admin FROM users u WHERE deleted=0 ORDER BY name";
- $this->registry->getObject('db')->executeQuery( $sql );
- $peeps = array();
- $k = 0;
- while( $person = $this->registry->getObject('db')->getRows() )
- {
- $person['style'] = ( $k % 2) ? 'alt' : 'norm';
- $peeps[] = $person;
- }
- $cache = $this->registry->getObject('db')->cacheData( $peeps );
- $this->registry->getObject('template')->getPage()->addTag( 'people', array( 'DATA', $cache ) );
- $this->registry->getObject('template')->getPage()->setTitle( 'People ');
-
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/list.tpl.php', 'footer.tpl.php');
-
- }
-
- private function toggleActive( $id )
- {
- $sql = "UPDATE users SET active=1-active WHERE ID=" . $id ;
- $this->registry->getObject('db')->executeQuery( $sql );
- header('Location: ' . $this->registry->buildURL(array('people'), '', true ) );
- exit();
- }
-
- private function toggleAdministrator( $id )
- {
- $sql = "UPDATE users SET admin=1-admin WHERE ID=" . $id ;
- $this->registry->getObject('db')->executeQuery( $sql );
- header('Location: ' . $this->registry->buildURL(array('people'), '', true ) );
- exit();
- }
-
- private function createUser()
- {
- if( isset( $_POST['create_user'] ) )
- {
- $insert = array();
- $insert['username'] = $this->registry->getObject('db')->sanitizeData( $_POST['username'] );
- $insert['email'] = $this->registry->getObject('db')->sanitizeData( $_POST['email'] );
- $insert['firstName'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] );
- $insert['lastName'] = $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] ) . ' ' . $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- $insert['password_hash'] = md5( $_POST['password_hash'] );
- $insert['active'] = 1;
- $insert['banned'] = 0;
- $insert['admin'] = 1;
- $insert['deleted'] = 0;
- $this->registry->getObject('db')->insertRecords( 'users', $insert );
- $id = $this->registry->getObject('db')->lastInsertID();
-
- if( isset( $_POST['group'] ) && is_array( $_POST['group'] ) && count( $_POST['group'] ) > 0 )
- {
- $sql = "INSERT INTO group_memberships (`user`, `group` ) VALUES ";
- foreach( $_POST['group'] as $gid )
- {
- $sql .= " ({$id}, {$gid} ),";
- }
- // remove last char from sql
- $sql = substr_replace($sql ,"",-1);
- $this->registry->getObject('db')->executeQuery( $sql );
- }
-
- $this->registry->redirectUser( array('people'), 'User created', 'The user account has been saved', true );
-
- }
- else
- {
- $sql = "SELECT * FROM groups WHERE deleted = 0 ORDER BY name";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'groups', array( 'SQL', $cache ) );
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/create.tpl.php', 'footer.tpl.php');
- }
- }
-
- private function createMember()
- {
- $sql = "SELECT * FROM groups WHERE deleted = 0 ORDER BY name";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'groups', array( 'SQL', $cache ) );
-
- if( isset( $_POST['create_user'] ) )
- {
- // create the account
- $required = array( 'username' => 'Username', 'password' => 'Password', 'confirm_password' => 'Confirm password', 'first_name' => 'First Name', 'last_name' => 'Last Name', 'organisation' => 'Organisation', 'address' => 'Address', 'city' => 'City', 'county' =>'County', 'postcode' =>'Postcode', 'email' => 'Email address', 'phone' => 'Telephone number' );
- $required = array();
- //$required = array( 'username' => 'Username', 'first_name' => 'First Name', 'last_name' => 'Last Name' );
- $errors = array();
- foreach( array_keys( $required ) as $r )
- {
- if( ! isset( $_POST[ $r ]) || $_POST[ $r ] == '' )
- {
- $processable = false;
- $error = array();
- $error['errora'] = $required[ $r ] . " is a required field";
- $errors[] = $error;
- }
-
- if( isset( $_POST['email'] ) && $r == 'email' )
- {
- if( !preg_match( "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})^", $_POST['email'] ) )
- {
- $error['errora'] = $required[ $r ] . " is an invalid email address. Please try again.";
- $errors[] = $error;
- }
- }
-
- if( isset( $_POST['username'] ) && $r == 'username' )
- {
- $username = $this->registry->getObject('db')->sanitizeData( $_POST['username'] );
- $sql = "SELECT * FROM users WHERE username = '{$username}'";
- $this->registry->getObject('db')->executeQuery($sql);
- if( $this->registry->getObject('db')->numRows() > 0 )
- {
- $error['errora'] = $required[ $r ] . " is already taken. Please try again.";
- $errors[] = $error;
- }
- }
-
- if( isset( $_POST['confirm_password'] ) && $r == 'confirm_password' )
- {
- if( $_POST['password'] != $_POST['confirm_password'] )
- {
- $error['errora'] = $required[ $r ] . " does not match your password. Please try again.";
- $errors[] = $error;
- }
- }
-
- if( isset( $_POST['password'] ) && $r == 'password' )
- {
- if( strlen( $_POST['password'] ) < 6 )
- {
- $error['errora'] = $required[ $r ] . " is too short, it must be at least 6 characters.";
- $errors[] = $error;
- }
- }
- }
-
- if( empty( $errors ) )
- {
- $insert = array();
- $insert['username'] = $this->registry->getObject('db')->sanitizeData( $_POST['username'] );
- $insert['email'] = $this->registry->getObject('db')->sanitizeData( $_POST['email'] );
- $insert['title'] = $this->registry->getObject('db')->sanitizeData( $_POST['title'] );
- $insert['firstName'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] );
- $insert['lastName'] = $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] ) . ' ' . $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- $insert['password_hash'] = md5( $_POST['password'] );
- $insert['active'] = 1;
- $insert['banned'] = 0;
- $insert['admin'] = 0;
- $insert['deleted'] = 0;
- if( isset( $_POST['confirm_member'] ) && $_POST['confirm_member'] == 1 )
- {
- $insert['member'] = 1;
- }
- else
- {
- $insert['member'] = 0;
- }
- $this->registry->getObject('db')->insertRecords( 'users', $insert );
- $id = $this->registry->getObject('db')->lastInsertID();
-
- $insert = array();
- $insert['user_id'] = $id;
- $insert['organisation'] = $this->registry->getObject('db')->sanitizeData( $_POST['organisation'] );
- $insert['organisation_type'] = $this->registry->getObject('db')->sanitizeData( $_POST['organisation_type'] );
- $insert['job_title'] = $this->registry->getObject('db')->sanitizeData( $_POST['job_title'] );
- $insert['phone'] = $this->registry->getObject('db')->sanitizeData( $_POST['phone'] );
- $insert['address'] = $this->registry->getObject('db')->sanitizeData( $_POST['address'] );
- $insert['address_linetwo'] = $this->registry->getObject('db')->sanitizeData( $_POST['address_linetwo'] );
- $insert['city'] = $this->registry->getObject('db')->sanitizeData( $_POST['city'] );
- $insert['county'] = $this->registry->getObject('db')->sanitizeData( $_POST['county'] );
- $insert['postcode'] = $this->registry->getObject('db')->sanitizeData( $_POST['postcode'] );
- //$insert['nature'] = $this->registry->getObject('db')->sanitizeData( $_POST['nature'] );
- //$insert['employees'] = $this->registry->getObject('db')->sanitizeData( $_POST['employees'] );
- $insert['website'] = $this->registry->getObject('db')->sanitizeData( $_POST['website'] );
- $insert['mobile'] = $this->registry->getObject('db')->sanitizeData( $_POST['mobile'] );
-
- if( isset( $_POST['kind'] ) && is_array($_POST['kind']) && count( $_POST['kind'] ) > 0 )
- {
- $insert['kind'] = serialize( $_POST['kind'] );
- }
-
- if( isset( $_POST['interests'] ) && is_array($_POST['interests']) && count( $_POST['interests'] ) > 0 )
- {
- $insert['interests'] = serialize( $_POST['interests'] );
- }
-
- if( isset( $_POST['networks'] ) && is_array($_POST['networks']) && count( $_POST['networks'] ) > 0 )
- {
- $insert['networks'] = serialize( $_POST['networks'] );
- }
-
- if( isset( $_POST['voluntary'] ) )
- {
- $insert['voluntary'] = $this->registry->getObject('db')->sanitizeData( $_POST['voluntary'] );
- }
-
- if( isset( $_POST['areas'] ) && is_array($_POST['areas']) && count( $_POST['areas'] ) > 0 )
- {
- $insert['areas'] = serialize( $_POST['areas'] );
- }
-
- if( isset( $_POST['declaration'] ) )
- {
- $insert['declaration'] = $this->registry->getObject('db')->sanitizeData( $_POST['declaration'] );
- }
-
- $this->registry->getObject('db')->insertRecords( 'users_extra', $insert );
-
- if( isset( $_POST['group'] ) && is_array( $_POST['group'] ) && count( $_POST['group'] ) > 0 )
- {
- $sql = "INSERT INTO group_memberships (`user`, `group` ) VALUES ";
- foreach( $_POST['group'] as $gid )
- {
- $sql .= " ({$id}, {$gid} ),";
- }
- // remove last char from sql
- $sql = substr_replace($sql ,"",-1);
- $this->registry->getObject('db')->executeQuery( $sql );
- }
-
- require_once( ACP_PATH . 'controllers/goldvision/controller.php');
- $controller = new GoldVisionController();
-
- $summary = str_replace( '&', '&', $_POST['organisation'] ) ;
- $phone_number = str_replace( '&', '&', $_POST['phone'] );
- $address_1 = str_replace( '&', '&', $_POST['address'] );
- $address_2 = str_replace( '&', '&', $_POST['address_linetwo'] );
- $town = str_replace( '&', '&', $_POST['city'] );
- $county = str_replace( '&', '&', $_POST['county'] );
- $postcode = str_replace( '&', '&', $_POST['postcode'] );
- $website = str_replace( '&', '&', $_POST['website'] );
-
- $interests = array();
- if( isset( $_POST['interests'] ) && is_array($_POST['interests']) && count( $_POST['interests'] ) > 0 )
- {
- if( $_POST['organisation_type'] == 'individual' || $_POST['organisation_type'] == 'voluntary' || $_POST['organisation_type'] == 'social' )
- {
- foreach( $_POST['interests'] as $interest => $details )
- {
- switch( $interest )
- {
- case 'age':
- $interests[] = '2';
- break;
- case 'asylum':
- $interests[] = '21';
- break;
- case 'disability':
- $interests[] = '58';
- break;
- case 'gender':
- $interests[] = '63';
- break;
- case 'gypsies':
- $interests[] = '47';
- break;
- case 'rights':
- $interests[] = '25';
- break;
- case 'migrants':
- $interests[] = '49';
- break;
- case 'race':
- $interests[] = '114';
- break;
- case 'religon':
- $interests[] = '64';
- break;
- case 'sexual':
- $interests[] = '115';
- break;
- case 'transgender':
- $interests[] = '61';
- break;
- }
- }
- }
- else
- {
- foreach( $_POST['interests'] as $interest => $details )
- {
- switch( $interest )
- {
- case 'age':
- $interests[] = '137';
- break;
- case 'asylum':
- $interests[] = '21';
- break;
- case 'disability':
- $interests[] = '59';
- break;
- case 'gender':
- $interests[] = '138';
- break;
- case 'gypsies':
- $interests[] = '47';
- break;
- case 'rights':
- $interests[] = '25';
- break;
- case 'migrants':
- $interests[] = '49';
- break;
- case 'race':
- $interests[] = '139';
- break;
- case 'religon':
- $interests[] = '144';
- break;
- case 'sexual':
- $interests[] = '140';
- break;
- case 'transgender':
- $interests[] = '61';
- break;
- }
- }
- }
- }
-
- if( isset( $_POST['areas'] ) && is_array($_POST['areas']) && count( $_POST['areas'] ) > 0 )
- {
- foreach( $_POST['areas'] as $area => $details )
- {
- switch( $area )
- {
- case 'bath':
- $interests[] = '101';
- break;
- case 'bristol':
- $interests[] = '96';
- break;
- case 'bournemouth':
- $interests[] = '102';
- break;
- case 'cornwall':
- $interests[] = '99';
- break;
- case 'devon':
- $interests[] = '106';
- break;
- case 'dorset':
- $interests[] = '108';
- break;
- case 'gloucestershire':
- $interests[] = '110';
- break;
- case 'north_somerset':
- $interests[] = '103';
- break;
- case 'plymouth':
- $interests[] = '104';
- break;
- case 'poole':
- $interests[] = '105';
- break;
- case 'somerset':
- $interests[] = '95';
- break;
- case 'south_gloucestershire':
- $interests[] = '107';
- break;
- case 'swindon':
- $interests[] = '109';
- break;
- case 'torbay':
- $interests[] = '111';
- break;
- case 'wiltshire':
- $interests[] = '100';
- break;
- case 'west_of_england':
- $interests[] = '98';
- break;
- case 'sw_region':
- $interests[] = '94';
- break;
- case 'outside_region':
- $interests[] = '97';
- break;
- }
- }
- }
-
- switch( $_POST['organisation_type'] )
- {
- case 'individual':
- $type = "df33cd86-6861-4e0f-93b3-d4c6bcf3a0f3";
- break;
- case 'private':
- $type = "c62b0abd-ddb7-4d4a-ad4a-599fd5af215b";
- break;
- case 'public':
- $type = "29490b9f-8873-44a8-ac7e-bcbec693af3b";
- break;
- case 'voluntary':
- $type = "3506df8e-3192-40ef-bc64-8b03e1e80445";
- break;
- case 'social':
- $type = "b4ea47d6-714f-4555-b134-e7e6de53916a";
- break;
- default:
- $type = "df33cd86-6861-4e0f-93b3-d4c6bcf3a0f3";
- break;
- }
-
- // ind data
- $firstName = str_replace( '&', '&', $_POST['first_name'] ) ;
- $lastName = str_replace( '&', '&', $_POST['last_name'] ) ;
- $title = str_replace( '&', '&', $_POST['title'] ) ;
- $jobTitle = str_replace( '&', '&', $_POST['job_title'] ) ;
- $mobile = str_replace( '&', '&', $_POST['mobile'] ) ;
- $email = str_replace( '&', '&', $_POST['email'] ) ;
- $events = '';
- $newsletter = 0;
- $volun = '';
- $share = 0;
- if( isset( $_POST['kind'] ) && is_array($_POST['kind']) && count( $_POST['kind'] ) > 0 )
- {
- //echo '<pre>' . print_r( $_POST['kind'], true ) . '</pre>'; exit();
- foreach( $_POST['kind'] as $k => $v )
- {
- if( $k == 'events' )
- {
- $events = "1a26da8a-90f5-4527-a8eb-551df1970e49";
- }
-
- if( $k == 'newsletter' )
- {
- $newsletter = 1;
- }
- }
- }
-
- if( isset($_POST['voluntary']) && $_POST['voluntary'] == 'yes' )
- {
- $volun = "edfd31f5-170d-4a72-a820-6c2591a84ef8";
- }
- else
- {
- $volun = "065b7934-5313-4656-857a-7e382fc312fe";
- }
-
- if( isset($_POST['declaration']) && $_POST['declaration'] == 'yes' )
- {
- $share = 1;
- }
- else
- {
- $share = 0;
- }
-
- if( $controller->isOrganisationInGoldVision( $_POST['organisation'] ) )
- {
- // organisation exists
- $orgID = $controller->getOrgID();
- // update it
- $controller->updateOrganisationInGV( $orgID, $summary, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website, $type );
-
- if( ! $controller->isContactInGoldVision( $_POST['email'], $orgID ) )
- {
- // contact not exist: create it
- $indID = $controller->createContact( $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share );
-
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
-
- $controller->createInterest( $interests, $indID );
- /*
- foreach( $interests as $interest => $tag )
- {
- $controller->createInterest( $tag, $indID );
- }*/
- }
-
- }
- else
- {
- // contact exists; update it
- $contactID = $controller->getContactID();
- $controller->updateContact( $contactID, $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website );
-
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
- $controller->createInterest( $interests, $contactID );
- /*
- foreach( $interests as $interest => $tag )
- {
- $controller->createInterest( $tag, $indID );
- }*/
- }
- }
-
- }
- else
- {
- // create new organisation
- $orgID = $controller->createOrganisationInGV( $summary, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website, $type );
-
- if( ! $controller->isContactInGoldVision( $_POST['email'], $orgID ) )
- {
- // create new contact
- $indID = $controller->createContact( $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share );
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
- $controller->createInterest( $interests, $indID );
- }
-
- }
- else
- {
- // update existing contact
- $contactID = $controller->getContactID();
- $controller->updateContact( $contactID, $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website );
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
- $controller->createInterest( $interests, $contactID );
- }
- }
-
- }
-
- $this->registry->redirectUser( array('people'), 'Member created', 'The member account has been saved', true );
-
- }
- else
- {
- $this->registry->getObject('template')->getPage()->addTag( 'message', 'Sorry, there were some errors with your attempt to create an account. Please correct the errors below and try again.' );
- $this->registry->getObject('template')->addTemplateBit( 'form_errors', 'people/errors.tpl.php' );
-
- $this->registry->getObject('template')->getPage()->addTag( 'form_username', $_POST['username'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_password', $_POST['password'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_confirm_password', $_POST['confirm_password'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_first_name', $_POST['first_name'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_last_name', $_POST['last_name'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_title', $_POST['title'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_organisation', $_POST['organisation'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_website', $_POST['website'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_job_title', $_POST['job_title'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_address', $_POST['address'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_address_linetwo', $_POST['address_linetwo'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_city', $_POST['city'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_county', $_POST['county'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_postcode', $_POST['postcode'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_email', $_POST['email'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_phone', $_POST['phone'] );
- $this->registry->getObject('template')->getPage()->addTag( 'form_mobile', $_POST['mobile'] );
-
- if( isset( $_POST['group'] ) && is_array($_POST['group']) && count( $_POST['group'] ) > 0 )
- {
- foreach( $_POST['group'] as $k => $v )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'nbd_opt_' . $v, 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['kind'] ) && is_array($_POST['kind']) && count( $_POST['kind'] ) > 0 )
- {
- foreach( $_POST['kind'] as $k => $v )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_kind_' . $k, 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['interests'] ) && is_array($_POST['interests']) && count( $_POST['interests'] ) > 0 )
- {
- foreach( $_POST['interests'] as $k => $v )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_interests_' . $k, 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['networks'] ) && is_array($_POST['networks']) && count( $_POST['networks'] ) > 0 )
- {
- foreach( $_POST['networks'] as $k => $v )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_networks_' . $k, 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['voluntary'] ) )
- {
- if( $_POST['voluntary'] == 'yes' )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_voluntary_yes', 'checked="checked"' );
- }
- else
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_voluntary_no', 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['areas'] ) && is_array($_POST['areas']) && count( $_POST['areas'] ) > 0 )
- {
- foreach( $_POST['areas'] as $k => $v )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_areas_' . $k, 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['declaration'] ) )
- {
- if( $_POST['declaration'] == 'yes' )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_declaration_yes', 'checked="checked"' );
- }
- else
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_declaration_no', 'checked="checked"' );
- }
- }
-
- if( isset( $_POST['organisation_type'] ) )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'nbd_' . $_POST['organisation_type'], 'selected="selected"' );
- }
-
- if( isset( $_POST['confirm_member'] ) )
- {
- $this->registry->getObject('template')->getPage()->addTag( 'form_confirm_member', 'checked="checked"' );
- }
-
- $cache = $this->registry->getObject('db')->cacheData( $errors );
- $this->registry->getObject('template')->getPage()->addTag( 'errors', array( 'DATA', $cache ) );
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/create-member.tpl.php', 'footer.tpl.php');
- }
-
- }
- else
- {
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/create-member.tpl.php', 'footer.tpl.php');
- }
- }
- /*
- private function createMember()
- {
- if( isset( $_POST['create_user'] ) )
- {
- $insert = array();
- $insert['username'] = $this->registry->getObject('db')->sanitizeData( $_POST['username'] );
- $insert['email'] = $this->registry->getObject('db')->sanitizeData( $_POST['email'] );
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['name'] );
- $insert['password_hash'] = md5( $_POST['password_hash'] );
- $insert['active'] = 1;
- $insert['banned'] = 0;
- $insert['admin'] = 0;
- $insert['deleted'] = 0;
- if( isset( $_POST['confirm_member'] ) && $_POST['confirm_member'] == 1 )
- {
- $insert['member'] = 1;
- }
- else
- {
- $insert['member'] = 0;
- }
- $this->registry->getObject('db')->insertRecords( 'users', $insert );
- $id = $this->registry->getObject('db')->lastInsertID();
-
- $insert = array();
- $insert['user_id'] = $id;
- $insert['organisation'] = $this->registry->getObject('db')->sanitizeData( $_POST['organisation'] );
- $insert['job_title'] = $this->registry->getObject('db')->sanitizeData( $_POST['job_title'] );
- $insert['phone'] = $this->registry->getObject('db')->sanitizeData( $_POST['phone'] );
- $insert['organisation_type'] = $this->registry->getObject('db')->sanitizeData( $_POST['organisation_type'] );
- $insert['address'] = $this->registry->getObject('db')->sanitizeData( $_POST['address'] );
- $insert['address_linetwo'] = $this->registry->getObject('db')->sanitizeData( $_POST['address_linetwo'] );
- $insert['city'] = $this->registry->getObject('db')->sanitizeData( $_POST['city'] );
- $insert['county'] = $this->registry->getObject('db')->sanitizeData( $_POST['county'] );
- $insert['postcode'] = $this->registry->getObject('db')->sanitizeData( $_POST['postcode'] );
- $insert['nature'] = $this->registry->getObject('db')->sanitizeData( $_POST['nature'] );
- $insert['employees'] = $this->registry->getObject('db')->sanitizeData( $_POST['employees'] );
- $this->registry->getObject('db')->insertRecords( 'users_extra', $insert );
-
- if( isset( $_POST['group'] ) && is_array( $_POST['group'] ) && count( $_POST['group'] ) > 0 )
- {
- $sql = "INSERT INTO group_memberships (`user`, `group` ) VALUES ";
- foreach( $_POST['group'] as $gid )
- {
- $sql .= " ({$id}, {$gid} ),";
- }
- // remove last char from sql
- $sql = substr_replace($sql ,"",-1);
- $this->registry->getObject('db')->executeQuery( $sql );
- }
-
- $this->registry->redirectUser( array('people'), 'Member created', 'The member account has been saved', true );
-
- }
- else
- {
- $sql = "SELECT * FROM groups WHERE deleted = 0 ORDER BY name";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'groups', array( 'SQL', $cache ) );
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/create-member.tpl.php', 'footer.tpl.php');
- }
- }*/
-
- private function deleteUser( $user )
- {
- $changes = array();
- $changes['deleted'] = 1;
- $changes['active'] =0;
- $changes['banned'] = 1;
- $changes['admin'] = 0;
- $this->registry->getObject('db')->updateRecords( 'users', $changes, 'ID=' . $user );
-
- $this->registry->redirectUser( array('people'), 'User deleted', 'The user account has been removed from the system', true );
-
- }
-
- private function editUser( $id )
- {
- $sql = "SELECT * FROM users WHERE admin = 1 AND ID=" . $id;
- $this->registry->getObject('db')->executeQuery( $sql );
- if( $this->registry->getObject('db')->numRows() > 0 )
- {
- if( isset( $_POST['edit_user'] ) )
- {
- $insert = array();
- $insert['username'] = $this->registry->getObject('db')->sanitizeData( $_POST['username'] );
- $insert['email'] = $this->registry->getObject('db')->sanitizeData( $_POST['email'] );
- $insert['firstName'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] );
- $insert['lastName'] = $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] ) . ' ' . $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- if( $_POST['password_hash'] != '' )
- {
- $insert['password_hash'] = md5( $_POST['password_hash'] );
- }
- $this->registry->getObject('db')->updateRecords( 'users', $insert, 'ID=' . $id );
-
- if( isset( $_POST['group'] ) && is_array( $_POST['group'] ) && count( $_POST['group'] ) > 0 )
- {
- $sql = "DELETE FROM group_memberships WHERE user=" .$id;
- $this->registry->getObject('db')->executeQuery( $sql );
-
- $sql = "INSERT INTO group_memberships (`user`, `group` ) VALUES ";
- foreach( $_POST['group'] as $gid )
- {
- $sql .= " ({$id}, {$gid} ),";
- }
- // remove last char from sql
- $sql = substr_replace($sql ,"",-1);
- $this->registry->getObject('db')->executeQuery( $sql );
- }
-
- $this->registry->redirectUser( array('people'), 'User edited', 'Changes to the user account have been saved', true );
-
- }
- else
- {
- $sql = "SELECT * FROM users WHERE ID=" . $id;
- $this->registry->getObject('db')->executeQuery( $sql );
- $data = $this->registry->getObject('db')->getRows();
- $this->registry->getObject('template')->dataToTags( $data, 'user_' );
-
- $sql = "SELECT * FROM groups WHERE deleted = 0 ORDER BY name";
- $cache = $this->registry->getObject('db')->cacheQuery( $sql );
- $this->registry->getObject('template')->getPage()->addTag( 'groups', array( 'SQL', $cache ) );
-
- $sql = "SELECT `group` FROM group_memberships WHERE user=" . $id;
- $this->registry->getObject('db')->executeQuery($sql);
- while ( $row = $this->registry->getObject('db')->getRows() )
- {
- $this->registry->getObject('template')->getPage()->addPPTag( 'nbd_opt_' . $row['group'], "checked='checked'");
- }
-
- $this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'people/edit.tpl.php', 'footer.tpl.php');
-
-
- }
- }
- else
- {
- $this->editMember( $id );
- }
-
-
- }
-
-
-
- private function editMember( $id )
- {
- $sql = "SELECT u.*, e.* FROM users u, users_extra e WHERE e.user_id=u.ID AND u.ID={$id}";
- $this->registry->getObject('db')->executeQuery( $sql );
- if( $this->registry->getObject('db')->numRows() == 1 )
- {
- $data = $this->registry->getObject('db')->getRows();
- }
- else
- {
- echo 'Error editing member';
- exit();
- }
-
- if( isset( $_POST['edit_user'] ) )
- {
-
- require_once( ACP_PATH . 'controllers/goldvision/controller.php');
- $controller = new GoldVisionController();
-
- $summary = str_replace( '&', '&', $_POST['organisation'] ) ;
- $phone_number = str_replace( '&', '&', $_POST['phone'] );
- $address_1 = str_replace( '&', '&', $_POST['address'] );
- $address_2 = str_replace( '&', '&', $_POST['address_linetwo'] );
- $town = str_replace( '&', '&', $_POST['city'] );
- $county = str_replace( '&', '&', $_POST['county'] );
- $postcode = str_replace( '&', '&', $_POST['postcode'] );
- $website = str_replace( '&', '&', $_POST['website'] );
-
- $interests = array();
- if( isset( $_POST['interests'] ) && is_array($_POST['interests']) && count( $_POST['interests'] ) > 0 )
- {
- if( $_POST['organisation_type'] == 'individual' || $_POST['organisation_type'] == 'voluntary' || $_POST['organisation_type'] == 'social' )
- {
- foreach( $_POST['interests'] as $interest => $details )
- {
- switch( $interest )
- {
- case 'age':
- $interests[] = '2';
- break;
- case 'asylum':
- $interests[] = '21';
- break;
- case 'disability':
- $interests[] = '58';
- break;
- case 'gender':
- $interests[] = '63';
- break;
- case 'gypsies':
- $interests[] = '47';
- break;
- case 'rights':
- $interests[] = '25';
- break;
- case 'migrants':
- $interests[] = '49';
- break;
- case 'race':
- $interests[] = '114';
- break;
- case 'religon':
- $interests[] = '64';
- break;
- case 'sexual':
- $interests[] = '115';
- break;
- case 'transgender':
- $interests[] = '61';
- break;
- }
- }
- }
- else
- {
- foreach( $_POST['interests'] as $interest => $details )
- {
- switch( $interest )
- {
- case 'age':
- $interests[] = '137';
- break;
- case 'asylum':
- $interests[] = '21';
- break;
- case 'disability':
- $interests[] = '59';
- break;
- case 'gender':
- $interests[] = '138';
- break;
- case 'gypsies':
- $interests[] = '47';
- break;
- case 'rights':
- $interests[] = '25';
- break;
- case 'migrants':
- $interests[] = '49';
- break;
- case 'race':
- $interests[] = '139';
- break;
- case 'religon':
- $interests[] = '144';
- break;
- case 'sexual':
- $interests[] = '140';
- break;
- case 'transgender':
- $interests[] = '61';
- break;
- }
- }
- }
- }
-
- if( isset( $_POST['areas'] ) && is_array($_POST['areas']) && count( $_POST['areas'] ) > 0 )
- {
- foreach( $_POST['areas'] as $area => $details )
- {
- switch( $area )
- {
- case 'bath':
- $interests[] = '101';
- break;
- case 'bristol':
- $interests[] = '96';
- break;
- case 'bournemouth':
- $interests[] = '102';
- break;
- case 'cornwall':
- $interests[] = '99';
- break;
- case 'devon':
- $interests[] = '106';
- break;
- case 'dorset':
- $interests[] = '108';
- break;
- case 'gloucestershire':
- $interests[] = '110';
- break;
- case 'north_somerset':
- $interests[] = '103';
- break;
- case 'plymouth':
- $interests[] = '104';
- break;
- case 'poole':
- $interests[] = '105';
- break;
- case 'somerset':
- $interests[] = '95';
- break;
- case 'south_gloucestershire':
- $interests[] = '107';
- break;
- case 'swindon':
- $interests[] = '109';
- break;
- case 'torbay':
- $interests[] = '111';
- break;
- case 'wiltshire':
- $interests[] = '100';
- break;
- case 'west_of_england':
- $interests[] = '98';
- break;
- case 'sw_region':
- $interests[] = '94';
- break;
- case 'outside_region':
- $interests[] = '97';
- break;
- }
- }
- }
-
- switch( $_POST['organisation_type'] )
- {
- case 'individual':
- $type = "df33cd86-6861-4e0f-93b3-d4c6bcf3a0f3";
- break;
- case 'private':
- $type = "c62b0abd-ddb7-4d4a-ad4a-599fd5af215b";
- break;
- case 'public':
- $type = "29490b9f-8873-44a8-ac7e-bcbec693af3b";
- break;
- case 'voluntary':
- $type = "3506df8e-3192-40ef-bc64-8b03e1e80445";
- break;
- case 'social':
- $type = "b4ea47d6-714f-4555-b134-e7e6de53916a";
- break;
- default:
- $type = "df33cd86-6861-4e0f-93b3-d4c6bcf3a0f3";
- break;
- }
-
- // ind data
- $firstName = str_replace( '&', '&', $_POST['first_name'] ) ;
- $lastName = str_replace( '&', '&', $_POST['last_name'] ) ;
- $title = str_replace( '&', '&', $_POST['title'] ) ;
- $jobTitle = str_replace( '&', '&', $_POST['job_title'] ) ;
- $mobile = str_replace( '&', '&', $_POST['mobile'] ) ;
- $email = str_replace( '&', '&', $_POST['email'] ) ;
- $events = '';
- $newsletter = 0;
- $volun = '';
- $share = 0;
- if( isset( $_POST['kind'] ) && is_array($_POST['kind']) && count( $_POST['kind'] ) > 0 )
- {
- //echo '<pre>' . print_r( $_POST['kind'], true ) . '</pre>'; exit();
- foreach( $_POST['kind'] as $k => $v )
- {
- if( $k == 'events' )
- {
- $events = "1a26da8a-90f5-4527-a8eb-551df1970e49";
- }
-
- if( $k == 'newsletter' )
- {
- $newsletter = 1;
- }
- }
- }
-
- if( isset($_POST['voluntary']) && $_POST['voluntary'] == 'yes' )
- {
- $volun = "edfd31f5-170d-4a72-a820-6c2591a84ef8";
- }
- else
- {
- $volun = "065b7934-5313-4656-857a-7e382fc312fe";
- }
-
- if( isset($_POST['declaration']) && $_POST['declaration'] == 'yes' )
- {
- $share = 1;
- }
- else
- {
- $share = 0;
- }
-
- if( $controller->isOrganisationInGoldVision( $_POST['organisation'] ) )
- {
- // organisation exists
- $orgID = $controller->getOrgID();
- // update it
- $controller->updateOrganisationInGV( $orgID, $summary, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website, $type );
-
- if( ! $controller->isContactInGoldVision( $_POST['email'], $orgID ) )
- {
- // contact not exist: create it
- $indID = $controller->createContact( $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share );
-
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
-
- $controller->createInterest( $interests, $indID );
- /*
- foreach( $interests as $interest => $tag )
- {
- $controller->createInterest( $tag, $indID );
- }*/
- }
-
- }
- else
- {
- // contact exists; update it
- $contactID = $controller->getContactID();
- $controller->updateContact( $contactID, $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website );
-
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
- $controller->createInterest( $interests, $contactID );
- /*
- foreach( $interests as $interest => $tag )
- {
- $controller->createInterest( $tag, $indID );
- }*/
- }
- }
-
- }
- else
- {
- // create new organisation
- $orgID = $controller->createOrganisationInGV( $summary, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website, $type );
-
- if( ! $controller->isContactInGoldVision( $_POST['email'], $orgID ) )
- {
- // create new contact
- $indID = $controller->createContact( $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share );
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
- $controller->createInterest( $interests, $indID );
- }
-
- }
- else
- {
- // update existing contact
- $contactID = $controller->getContactID();
- $controller->updateContact( $contactID, $firstName, $lastName, $orgID, $title, $jobTitle, $mobile, $email, $events, $volun, $newsletter, $share, $address_1, $address_2, $town, $county, $postcode, $phone_number, $website );
- if( isset( $interests ) && is_array($interests) && count( $interests ) > 0 )
- {
- $controller->createInterest( $interests, $contactID );
- }
- }
-
- }
-
-
- $insert = array();
- $insert['username'] = $this->registry->getObject('db')->sanitizeData( $_POST['username'] );
- $insert['email'] = $this->registry->getObject('db')->sanitizeData( $_POST['email'] );
- $insert['title'] = $this->registry->getObject('db')->sanitizeData( $_POST['title'] );
- $insert['firstName'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] );
- $insert['lastName'] = $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- $insert['name'] = $this->registry->getObject('db')->sanitizeData( $_POST['first_name'] ) . ' ' . $this->registry->getObject('db')->sanitizeData( $_POST['last_name'] );
- if( $_POST['password_hash'] != '' )
- {
- $insert['password_hash'] = md5($_POST['password_hash'] );
- }
- $insert['active'] = 1;
- $insert['banned'] = 0;
- $insert['admin'] = 0;
- $insert['deleted'] = 0;
- if( isset( $_POST['confirm_member'] ) && $_POST['confirm_member'] == 1 )
- {
- $insert['member'] = 1;
- }
- else
- {
- $insert['member'] = 0;
- }
- $this->registry->getObject('db')->updateRecords( 'users', $insert, 'ID=' . $id );
-
- $insert = array();
- $insert['user_id'] = $id;
- $insert['organisation'] = $this->registry->getObject('db')->sanitizeData( $_POST['organisation'] );
- $insert['organisation_type'] = $this->registry->getObject('db')->sanitizeData( $_POST['organisation_type'] );
- $insert['job_title'] = $this->registry->getObject('db')->sanitizeData( $_POST['job_title'] );
- $insert['phone'] = $this->registry->getObject('db')->sanitizeData( $_POST['phone'] );
- $insert['address'] = $this->registry->getObject('db')->sanitizeData( $_POST['address'] );
- $insert['address_linetwo'] = $this->registry->getObject('db')->sanitizeData( $_POST['address_linetwo'] );
- $insert['city'] = $this->registry->getObject('db')->sanitizeData( $_POST['city'] );
- $insert['county'] = $this->registry->getObject('db')->sanitizeData( $_POST['county'] );
- $insert['postcode'] = $this->registry->getObject('db')->sanitizeData( $_POST['postcode'] );
- //$insert['nature'] = $this->registry->getObject('db')->sanitizeData( $_POST['nature'] );
- //$insert['employees'] = $this->registry->getObject('db')->sanitizeData( $_POST['employees'] );
- $insert['website'] = $this->registry->getObject('db')->sanitizeData( $_POST['website'] );
- $insert['mobile'] = $this->registry->…
Large files files are truncated, but you can click here to view the full file