FreenetIS

u.name AS user_name, u.surname, u.phone,

DISTINCT (u.phone),

WHERE su.id = $subnet_id AND m.id <> 1 AND m.locked <> 1;

");

return $this->db->query("SELECT DISTINCT (u.phone)

WHERE su.id = $subnet_id AND m.id <> 1 AND m.locked <> 1;

");

$country_code = $contact->find_phone_country_code($phone_number);

"SELECT id FROM users WHERE phone = ?;",

array(substr($phone_number, mb_strlen($country_code)))

);

if ($query->count() > 0)

{

return $query->current()->id;

}

// type 21 is phone number

$query = $this->db->query(

public $arr_sql = array('id' => 'u.id', 'name' => 'u.name', 'surname' => 'u.surname', 'email' => 'u.email', 'phone' => 'u.phone', 'login' => 'u.login', 'member_name' => 'm.name');

u.id, u.name, u.surname, u.login, u.email, u.phone, u.member_id

/**

* Function searches for items dependent on given user. Used for deleting user.

* @param $user_id

* @return unknown_type

*/

* @return address point object

u.phone, u.email, u.login AS login_name, u.birthday,

'login', 'email', 'users.type', 'phone', 'birthday', 'leaving_date','users.application_password','users.comment as ucomment')

(

SELECT member_id FROM users u WHERE u.phone = ?

) UNION (

)

", array($phone, Contact_Model::TYPE_PHONE, $phone))->current()->id;

* @author Tomas Dulik

(

SELECT m.*

FROM members m

JOIN users u ON m.id = u.member_id

AND u.phone = ?

) UNION (

)

", array($phone, Contact_Model::TYPE_PHONE, $phone))->current();

* Search for phone prefix in country table.

* Search for phone prefix in country table.

* Gets prefix of phone country code

$user->phone = $form_data["phone"];

$user->email = $form_data["email"];

$allowed_order_type = array('id', 'name', 'surname', 'login', 'email', 'member_name');

new Table_Form_Item('text','email','Email'),

new Table_Form_Item('text','phone','Phone'),

"tr",

$grid->order_field('phone')->label(url_lang::lang('texts.Phone'));

$grid->order_field('email')->label('E-mail');

if ($this->acl_check_edit(get_class($this),'phone',$user_model->member_id))

$form->input('phone')

->label(url_lang::lang('texts.phone').':')

->rules('required|length[9,14]|valid_numeric')->callback(array($this, 'valid_phone'))->value($user_model->phone);

if ($this->acl_check_edit(get_class($this),'email',$user_model->member_id))

$form->input('email')->label(url_lang::lang('texts.email').':')

->rules('length[3,50]|valid_email')

->value($user_model->email);

if ($this->acl_check_edit(get_class($this),'phone',$user_model->member_id))

$user_data->phone = $form_data['phone'];

if ($this->acl_check_edit(get_class($this),'email',$user_model->member_id))

$user_data->email = $form_data['email'];

$form->input('phone')->label(url_lang::lang('texts.phone').':')->rules('required|length[9,40]')->callback(array($this, 'valid_phone'));

$form->input('email')->label(url_lang::lang('texts.email').':')->rules('length[3,50]|valid_email')->callback(array($this, 'valid_email'));

$user_data->phone = $form_data['phone'];

$user_data->email = $form_data['email'];

->action(url_lang::lang('texts.Delete'))->class('delete');

function valid_phone($input)

{

$user_model=new User_Model();

if ($user_model->phone_exist($input->value,$this->user_id) || trim($input->value)=='')

{

$input->add_error('required', url_lang::lang('texts.Phone already exists in database.'));

}

}

function valid_email($input)

{ /*

$user_model=new User_Model();

if ($user_model->email_exist($input->value,$this->user_id) || trim($input->value)=='')

{

$input->add_error('required', url_lang::lang('texts.Email already exists in database.'));

}

*/

}

$email = $users_model->email;

$mail->addTo($email, $email); //2. parametr muze byt nickname nebo jmeno a prijmeni spravce oblasti

$email = $users_model->email;

$mail->addTo($email, $email); //2. parametr muze byt nickname nebo jmeno a prijmeni spravce oblasti

$email = $users_model->email;

$mail->addTo($email, $email); //2. parametr muze byt nickname nebo jmeno a prijmeni spravce oblasti

$voicemail->email =$user->email;

/**

* Function checks validity of phone number.

* @param $input

* @return unknown_type

*/

function valid_phone($input)

{

$value = trim($input->value);

//if(!ereg("^[0-9]{9,9}$", $value))

if(!preg_match("/^[0-9]{9,9}$/", $value))

{

$input->add_error('required', url_lang::lang('texts.Bad phone format.'));

}

}

* @author Michal Kliment, Jiri Svitak

$form->group('')->label(url_lang::lang('texts.Contact information'));

$form_data = $form->as_array();

foreach($form_data as $key => $value)

{

$form_data[$key] = htmlspecialchars($value);

}

$member = new Member_Model;

$enum_type = new Enum_type_Model();

$user->login = $form_data['login'];

$user->password = sha1($form_data['passwd']);

$user->name = $form_data['name'];

$user->middle_name = $form_data['middle_name'];

$user->surname = $form_data['surname'];

$user->pre_title = $form_data['title1'];

$user->post_title = $form_data['title2'];

$user->birthday = date("Y-m-d",$form_data['birthday']);

$user->phone = $form_data['phone'];

$user->email = $form_data['email'];

$user->type = User_Model::$member;

// entrance fee

$fee_model = new Fee_Model();

$fee = $fee_model->get_by_date_type(date('Y-m-d'), 'entrance fee');

if (is_object($fee) && $fee->id)

$entrance_fee = $fee->fee;

else

$entrance_fee = 0;

$address_point_model = new Address_point_Model();

$address_point = $address_point_model->get_address_point($form_data['town_id'],$form_data['street_id'],$form_data['street_number']);

// address point doesn't exist exist, create it

if (!$address_point || !$address_point->id)

{

$address_point->clear();

$address_point->country_id = $form_data['country_id'];

$address_point->town_id = $form_data['town_id'];

$address_point->street_id = $form_data['street_id'];

$address_point->street_number = $form_data['street_number'];

$address_point->gps = '';

$address_point->save();

$member->name = ($form_data['membername'] != '') ? $form_data['membername'] : $user->name.' '.$user->surname;

$member->address_point_id = $address_point->id;

$member->type = $enum_type->get_type_id('Applicant');

$member->organization_identifier = $form_data['organization_identifier'];

$member->entrance_fee = $entrance_fee;

$member_saved = $member->save();

$user->member_id = $member->id;

$user_saved = $user->save();

$account = new Account_Model();

$account->member_id = $member->id;

$account->account_attribute_id = Account_attribute_Model::$credit;

if ($form_data['membername'] == '')

$account->name = $form_data['surname'].' '.$form_data['name'];

else

$account->name = $form_data['membername'];

$account->save();

// access rights of expectant for membership (wannabe - aro group 23)

Controller::insert_phpgacl($user->id, $user->surname.' '.$user->name, $user->type, 'wannabe');

url::redirect(url_lang::base().'login');

if ($user->email == $form_data['email'] && $user->email != '')

$user_grid->order_field('email','email')->label('E-mail');

$member = new Member_Model();

$user->phone = $form_data['phone'];

$user->email = $form_data['email'];

if (!$member->save())

throw new Exception();

if (!$user->save())

throw new Exception();

if (!$account->save())

throw new Exception();

$email = $user->email;

"DROP VIEW `account_balances` ,

`account_inbounds` ,

`account_outbounds` ;",

"ALTER TABLE `accounts` ADD `balance` DOUBLE NULL DEFAULT '0' COMMENT 'Account balance, value is updated with respect to transfers of account' AFTER `account_attribute_id` "

<td>E-mail</td>

<?php if ($this->acl_check_2D('freenetis', 'write_email'))

if (valid::email($member_data->email))

{

echo form::open(url_lang::base().'email') ;

echo form::hidden('email_member_id', $member_data->member_id );

echo form::hidden('address', $member_data->email );

echo form::imagebutton('submit', url::base().'media/images/email.png', array('title' => url_lang::lang('texts.Send e-mail'), 'style' => 'width:22px; height:22px; border-width: 0px 0px 0px 0px; border-spacing: 0px;'));

echo form::close();

}

</td>

</tr>

<td><?php echo $member_data->email ?></td>

</tr>

<tr>

<th>

<table class="picturebox"><tr>

<td><?php echo url_lang::lang('texts.Phone') ?></td>

<td>

<?php if ($this->acl_check_2D('freenetis', 'write_email'))

if (valid::phone_cs_CZ($member_data->phone))

{

echo html::anchor(url_lang::base().'sms/send/'.$member_data->phone, html::image(array('src' => resource::sms('send-small'), 'alt' => url_lang::lang('texts.Send SMS'), 'title' => url_lang::lang('texts.Send SMS'))), array('title' => url_lang::lang('texts.Send SMS')));

}

?>

</td>

</tr>

</table>

</th>

<td><?php echo $member_data->phone ?></td>

</tr>

<?php if ($this->acl_check_view('Users_Controller', 'application_password', $member_data->member_id)) { ?>

<tr>

<th><?php echo url_lang::lang('texts.Application password').'&nbsp;'.help::hint('application_password') ?></th>

<td><?php echo $member_data->application_password ?></td>

</tr>

<?php } ?>

<?php foreach ($contacts as $i => $contact):?>

<tr>

<script type="text/javascript">

$(document).ready(function() {

$('a.delete').click(function () {

return window.confirm('<?php echo url_lang::lang('texts.Do you really want to delete this record') ?>?');

});

});

</script>

<?php if (! empty($grid_private_contacts)): ?><br /><br />

<tr>

<th>E-mail</th>

<td><?php echo $user_data->email ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.Phone') ?></th>

<td><?php echo $user_data->phone ?></td>

</tr>