Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 63

Přidáno uživatelem kenod před více než 16 roky(ů)

Zobrazit rozdíly:

freenetis/trunk/kohana/application/models/money_transfer.php
<?
class Money_transfer_Model extends ORM {
public function get_transfers($account_id = null, $limit_from = 0, $limit_results = 50, $order_by = 'mt.id', $order_by_direction = 'DESC')
public function get_transfers($account_id = null, $limit_from = 0, $limit_results = 20, $order_by = 'mt.id', $order_by_direction = 'DESC')
{
if ($order_by=='amount') $order_by = 'IF( mt.destination_id = '.$account_id.', amount, amount*-1 )';
return self::$db->query('SELECT a.name AS aname, a.id AS aid, a.owner_id, mt. * , mt.id AS mtid, bi. * , IF( mt.destination_id = '.$account_id.', FALSE, TRUE ) AS trans_type
freenetis/trunk/kohana/application/controllers/members.php
}
function users($member_id = NULL, $order_by = 'member_id', $order_by_direction = 'ASC')
{
if (isset($member_id))
{
if ($member_id == $_SESSION['member_id'])
{
if (!$this->gacl_class->acl_check('freenetis', 'view_own', 'all', $_SESSION['username'])) Controller::error(1);
}
else
{
if (!$this->gacl_class->acl_check('freenetis', 'view_all', 'all', $_SESSION['username'])) Controller::error(1);
}
$model_users = new User_Model();
$users = $model_users->orderby($order_by,$order_by_direction)->find_all_by_member_id($member_id);
$grid = new Grid(url_lang::base().'members/users/', url_lang::lang('texts.My users'),array(
'separator' => '<br /><br />',
'use_paginator' => false,
'use_selector' => false,
'order_by' => $order_by,
'order_by_direction' => $order_by_direction,
'variables' => $member_id.'/'
));
if ($this->gacl_class->acl_check('freenetis', 'new_own', 'all', $_SESSION['username'])) $grid->add_new_button(url_lang::base().'users/add/'.$member_id, url_lang::lang('texts.Add new user'));
$grid->add_back_button(url_lang::lang('texts.Back'));
$grid->order_field('id','id')->label('ID');
$grid->order_field('name','name')->label(url_lang::lang('texts.Name'));
$grid->order_field('surname','surname')->label(url_lang::lang('texts.Surname'));
$grid->order_field('login','login')->label(url_lang::lang('texts.Username'));
$grid->order_field('email','email')->label('E-mail');
$grid->action_field('id') ->label(url_lang::lang('texts.Show'))->url(url_lang::base().'users/show')->action(url_lang::lang('texts.Show'));
$grid->action_field('id') ->label(url_lang::lang('texts.Edit'))->url(url_lang::base().'users/edit')->action(url_lang::lang('texts.Edit'));
$grid->action_field('id') ->label(url_lang::lang('texts.Delete'))->url(url_lang::base().'users/delete')->action(url_lang::lang('texts.Delete'))->script('onclick="return potvrd(\''.url_lang::lang('texts.delete_user').'\');"');;
$grid->datasource( $users );
$view = new View('template');
$view->header = new View('base/header');
$view->content = $grid;
$view->footer = new View('base/footer');
$view->header->title = url_lang::lang('texts.My users');
$view->header->menu = Controller::render_menu();
$view->render(TRUE);
}
else
{
Controller::error();
}
} // end of users function
function show($member_id = NULL, $order_by = 'member_id', $order_by_direction = 'ASC')
{
//if (!$this->gacl_class->acl_check('freenetis', 'view_own', 'all', $_SESSION['username'],get_class($this),'function_'.__FUNCTION__)) Controller::error(1);
if (isset($member_id))
{
$model_members = new Member_Model();
......
$form->set_attr('class', 'form_class')->set_attr('method', 'post');
$form->group('')->label(url_lang::lang('texts.Basic informations'));
// KONTROLA PRAV PHPGACL if ($this->gacl_class->acl_check('freenetis', 'edit', 'all', 'mara', get_class($this), 'surname'))
$form->input('username')->label(url_lang::lang('texts.username').':')->rules('required|length[3,50]')->callback(array($this, 'valid_username'));
$form->input('pre_title')->label(url_lang::lang('texts.pre title').':')->rules('length[3,40]');
freenetis/trunk/kohana/application/controllers/accounts.php
url::redirect('accounts/transfers');
}
function main_accounts($acc_name = 'master')
{
$model_account= new Account_Model();
$model_account->where('type=\''.$acc_name.'\'')->find();
url::redirect(url_lang::base().'accounts/account_transfers/'.$model_account->id);
}
function account_transfers($acc_id = NULL, $limit_results = 50, $order_by = 'mt.id', $order_by_direction = 'DESC')
{
if (isset($acc_id))
freenetis/trunk/kohana/application/libraries/MY_Controller.php
$myMenu .= ' <li class="account"><h2>'.url_lang::lang('texts.My account').'</h2>
<ul>
<li>'.html::anchor(url_lang::base().$url, url_lang::lang('texts.My account')).'</li>';
if ($this->session->get('member_login')==$this->session->get('username')) $myMenu .= '<li>'.html::anchor(url_lang::base().'members/users/'.$this->session->get('member_id'), url_lang::lang('texts.My users')).'</li>';
if ($this->session->get('member_login')==$this->session->get('username')) $myMenu .= '<li>'.html::anchor(url_lang::base().'accounts/transfers/'.$this->session->get('member_id'), url_lang::lang('texts.My transfers')).'</li>';
$myMenu .= ' <li>'.html::anchor(url_lang::base().'devices/show_my', url_lang::lang('texts.My devices')).'</li>
</ul>
</li>
<li class="transfer"><h2>'.url_lang::lang('texts.Transfers').'</h2>
<ul>
<li>'.html::anchor(url_lang::base().'accounts/unidentified_transfers/', url_lang::lang('texts.Unidentified transfers')).'</li>
<li>'.html::anchor(url_lang::base().'accounts/works/uncorfirmed/', url_lang::lang('texts.Unconfirmed works')).'</li>
<li>'.html::anchor(url_lang::base().'accounts/main_accounts/master', url_lang::lang('texts.Bank account')).'</li>
if ($this->gacl_class->acl_check('menu', 'my_users', 'all', $_SESSION['username'])) $myMenu .= '<li>'.html::anchor(url_lang::base().'members/users/'.$this->session->get('member_id'), url_lang::lang('texts.My users')).'</li>';
if ($this->gacl_class->acl_check('menu', 'my_transfers', 'all', $_SESSION['username'])) $myMenu .= '<li>'.html::anchor(url_lang::base().'accounts/transfers/'.$this->session->get('member_id'), url_lang::lang('texts.My transfers')).'</li>';
if ($this->gacl_class->acl_check('menu', 'my_devices', 'all', $_SESSION['username'])) $myMenu .= ' <li>'.html::anchor(url_lang::base().'devices/show_my', url_lang::lang('texts.My devices')).'</li>';
$myMenu .= ' </ul>
</li>';
$acc_menu = '';
if ($this->gacl_class->acl_check('menu', 'unconfirmed_works', 'all', $_SESSION['username'])) $acc_menu = '<li>'.html::anchor(url_lang::base().'works/uncorfirmed/', url_lang::lang('texts.Unconfirmed works')).'</li>';
if ($this->gacl_class->acl_check('menu', 'unidentified_transfers', 'all', $_SESSION['username'])) $acc_menu .= '<li style="padding-bottom:8px;">'.html::anchor(url_lang::base().'accounts/unidentified_transfers/', url_lang::lang('texts.Unidentified transfers')).'</li>';
if ($this->gacl_class->acl_check('menu', 'accounts', 'all', $_SESSION['username'])) $acc_menu .= '<li>'.html::anchor(url_lang::base().'accounts/main_accounts/master', url_lang::lang('texts.Bank account')).'</li>
<li>'.html::anchor(url_lang::base().'accounts/main_accounts/infrastructure', url_lang::lang('texts.Infrastructure account')).'</li>
<li>'.html::anchor(url_lang::base().'accounts/main_accounts/operating', url_lang::lang('texts.Operating account')).'</li>';
if ($acc_menu != '') $myMenu .= '<li class="transfer"><h2>'.url_lang::lang('texts.Transfers').'</h2>
<ul>
'.$acc_menu.'
</ul>
</li>
<li class="users"><h2>'.url_lang::lang('texts.Users').'</h2>
</li>';
if ($this->gacl_class->acl_check('menu', 'users_members', 'all', $_SESSION['username'])) $myMenu .= '<li class="users"><h2>'.url_lang::lang('texts.Users').'</h2>
<ul>
<li>'.html::anchor(url_lang::base().'members', url_lang::lang('texts.Members')).'</li>
<li>'.html::anchor(url_lang::base().'users', url_lang::lang('texts.Users')).'</li>
<li>'.html::anchor(url_lang::base().'members', url_lang::lang('texts.Members')).'</li>
</ul>
</li>
<li class="networks"><h2>'.url_lang::lang('texts.Networks').'</h2>
</li>';
if ($this->gacl_class->acl_check('menu', 'network', 'all', $_SESSION['username'])) $myMenu .= '<li class="networks"><h2>'.url_lang::lang('texts.Networks').'</h2>
<ul>
<li>'.html::anchor(url_lang::base().'devices', url_lang::lang('texts.Devices')).'</li>
<li>'.html::anchor(url_lang::base().'segments', url_lang::lang('texts.Segments')).'</li>
freenetis/trunk/kohana/application/views/grid_template.php
<?= ($title) ? '<h3>'.$title.'</h3>' : '' ?>
<?= ($title) ? '<h2>'.$title.'</h2><br />' : '' ?>
<? if (isset($add_button)){ echo $add_button.$separator; }?>
<table class="main" cellspacing="0">
freenetis/trunk/freenetis2_done.sql
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Čtvrtek 01. května 2008, 23:14
-- Vygenerováno: Pátek 02. května 2008, 00:51
-- Verze MySQL: 5.0.27
-- Verze PHP: 5.2.4
--
......
(10, 1, 'nějaký další projekt', 'project', NULL, '...'),
(14, 25, 'nejaky projekt', 'project', 0, NULL),
(15, 1, 'Master ucet', 'master', 0, 'Hlavni ucet sdruzeni, nic sem neposilat!'),
(16, 1, 'Infrastrukturka', 'infrastructure', 0, NULL),
(16, 1, 'Infrastruktura', 'infrastructure', 0, NULL),
(17, 1, 'Operating account', 'operating', 0, NULL),
(18, 1, 'Dodavatelé', 'suppliers', 0, 'vsichni kterym neco platime'),
(19, 29, 'Petrik Danku', 'analytic', NULL, NULL),
......
(21, 'user', 1, 1, '', '', 1209655542),
(22, 'user', 1, 1, '', '', 1209673546),
(24, 'user', 1, 1, '', '', 1209657851),
(25, 'user', 1, 1, '', '', 1209652620);
(25, 'user', 1, 1, '', '', 1209652620),
(26, 'user', 1, 1, '', '', 1209678005),
(27, 'user', 1, 1, '', '', 1209680042),
(28, 'user', 1, 1, '', '', 1209678074);
-- --------------------------------------------------------
......
--
INSERT INTO `acl_seq` (`id`) VALUES
(25);
(28);
-- --------------------------------------------------------
......
(18, 'freenetis', 'edit_own', 2, 'Editace vlastnich zaznamu', 0),
(19, 'freenetis', 'new_own', 2, 'Vytvareni novych vlastnich', 0),
(20, 'freenetis', 'delete_all', 1, 'Mazani vsech zaznamu', 0),
(21, 'freenetis', 'delete_own', 2, 'Mazani vlastnich zaznamu', 0);
(21, 'freenetis', 'delete_own', 2, 'Mazani vlastnich zaznamu', 0),
(22, 'menu', 'my_users', 1, 'My users', 0),
(23, 'menu', 'my_transfers', 1, 'My transfers', 0),
(24, 'menu', 'my_devices', 1, 'My devices', 0),
(25, 'menu', 'unidentified_transfers', 2, 'Unidentified transfers', 0),
(26, 'menu', 'unconfirmed_works', 2, 'Unconfirmed works', 0),
(27, 'menu', 'accounts', 2, 'Accounts (master, operating...)', 0),
(28, 'menu', 'users_members', 3, 'Users and members', 0),
(29, 'menu', 'network', 4, 'Network menu', 0);
-- --------------------------------------------------------
......
(25, 'freenetis', 'delete_own'),
(25, 'freenetis', 'edit_own'),
(25, 'freenetis', 'new_own'),
(25, 'freenetis', 'view_own');
(25, 'freenetis', 'view_own'),
(26, 'menu', 'accounts'),
(26, 'menu', 'my_devices'),
(26, 'menu', 'my_transfers'),
(26, 'menu', 'my_users'),
(26, 'menu', 'network'),
(26, 'menu', 'unconfirmed_works'),
(26, 'menu', 'unidentified_transfers'),
(26, 'menu', 'users_members'),
(27, 'menu', 'my_devices'),
(27, 'menu', 'my_transfers'),
(27, 'menu', 'my_users'),
(27, 'menu', 'network'),
(28, 'menu', 'my_devices');
-- --------------------------------------------------------
......
--
INSERT INTO `aco_seq` (`id`) VALUES
(21);
(29);
-- --------------------------------------------------------
......
(21, 22),
(22, 22),
(24, 33),
(25, 33);
(25, 33),
(26, 32),
(27, 22),
(27, 23),
(28, 33);
-- --------------------------------------------------------
......
`value` varchar(255) collate utf8_czech_ci default NULL,
PRIMARY KEY (`id`),
KEY `user_contact` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=52 ;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=56 ;
--
-- Vypisuji data pro tabulku `contacts`
......
(4, 47, 'icq', '104677383'),
(4, 48, 'skype', 'kenod1st'),
(4, 49, 'msn', 'kenod@kenod.net'),
(1, 50, 'icq', '124547845'),
(1, 51, 'msn', 'bubakov');
(1, 52, 'icq', '124547845'),
(1, 53, 'msn', 'bubakov'),
(12, 54, 'msn', 'tedka'),
(6, 55, 'jura', 'jurkov');
-- --------------------------------------------------------
......
KEY `commited_by` (`user_id`),
KEY `transfer_salary` (`transfer_id`),
KEY `confirmed_by` (`confirmed_by_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
--
-- Vypisuji data pro tabulku `jobs`
......
(1, 1, 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tatio', 10, 1, 11282),
(2, 2, 'No, tak skoro nic jsem nedelal, ale to je snad jedno, ne?', 5, 1, 11),
(5, 2, 'novinka', 10, 1, 11283),
(6, 1, 'No, tak celý den jsem vytahoval zaby z potoka.', 24, NULL, NULL);
(6, 1, 'No, tak celý den jsem vytahoval zaby z potoka.', 24, NULL, NULL),
(7, 12, 'Uklidila jsem doma.', 7, NULL, NULL);
-- --------------------------------------------------------
......
(27, 'asd', 'asd', 'asd', 'asd', 'asdasd', NULL, NULL, NULL, NULL, NULL, NULL, 1, 510, '2008-04-20', NULL),
(28, 'asd', 'asd', 'asd', 'asd', 'asdasd', NULL, NULL, NULL, NULL, NULL, NULL, 1, 500, '2008-04-20', NULL),
(29, 'Petrik Danku', '147', 'DOma', 'Domov', '78945', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2008-04-29', NULL),
(30, 'Tom Bobu', '147', 'U reky', 'Roznov', '87521', NULL, '147', '148', 2000, NULL, 2000, 1, 720, '2008-05-01', NULL);
(30, 'Tom Bobu', '147', 'U reky', 'Roznov', '87521', NULL, '147', '148', 2000, NULL, 2000, 1, 710, '2008-05-01', NULL);
-- --------------------------------------------------------
......
KEY `from` (`origin_id`),
KEY `has_bank_info` (`bank_info_id`),
KEY `to` (`destination_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1603 ;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1604 ;
--
-- Vypisuji data pro tabulku `money_transfers`
......
(1599, NULL, 15, 5, 7, '2008-05-01 17:11:54', 'vstupni prispevek+clen.prispevky\n(dub.-cer.)', 2360),
(1600, NULL, 10, 17, 10, '2008-05-01 19:23:52', NULL, 39.9),
(1601, NULL, 15, 10, 10, '2008-05-01 19:23:52', NULL, 3440),
(1602, NULL, 15, 21, 13, '2008-05-01 21:56:44', 'PLATBA ZA INTERNET', 720);
(1602, NULL, 15, 21, 13, '2008-05-01 21:56:44', 'PLATBA ZA INTERNET', 720),
(1603, NULL, 21, 14, NULL, '2008-05-02 00:14:54', NULL, 10);
-- --------------------------------------------------------
......
(22, 4, 'Petr', '', 'Daněk', 'Bc.', '', '1983-06-15', '732253133', 'danek@danek.cz', 'kenod', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea', 'member', NULL, NULL, 'wtf ?', 'all', 0, 0),
(24, 5, 'userovojmeno', NULL, 'userovoprijmenii', NULL, NULL, '1996-04-09', '77745', 'user@userov.net', 'user', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea', 'member', NULL, NULL, NULL, 'all', 0, 0),
(25, 6, 'Jiří', NULL, 'Světlík', NULL, NULL, '1989-04-15', '604332688', 'jirka@svetlik.com', 'jirka', NULL, 'member', NULL, NULL, 'neplatic a hajzl', 'all', 0, 0),
(1, 12, 'Tereza', NULL, 'Daňková', NULL, NULL, '2008-01-18', '123456789', 'asd@asd.lo', 'Terka', 'f10e2821bbbea527ea02200352313bc059445190', 'user', NULL, NULL, NULL, 'all', 0, 0),
(1, 12, 'Tereza', NULL, 'Daňková', NULL, NULL, '2008-01-18', '123456789', 'asd@asd.lol', 'Terka', 'f10e2821bbbea527ea02200352313bc059445190', 'user', NULL, NULL, NULL, 'all', 0, 0),
(22, 13, 'Tomáš', NULL, 'Daněk', NULL, NULL, '1986-04-18', '605968848', 'bboobb@t-zone.cz', 'Tom', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea', 'user', NULL, NULL, 'bracha', 'all', 0, 0),
(26, 14, 'asd', NULL, 'asd', NULL, NULL, '2008-04-20', '756789456', 'asd@asd.lop', 'aaa', '7e240de74fb1ed08fa08d38063f6a6a91462a815', 'member', NULL, NULL, NULL, 'all', 0, 0),
(27, 15, 'asd', NULL, 'asd', NULL, NULL, '2008-04-20', 'asdasdasddd', 'asd@asd.lopd', 'aaaas', '7e240de74fb1ed08fa08d38063f6a6a91462a815', 'member', NULL, NULL, NULL, 'all', 0, 0),

Také k dispozici: Unified diff