App::uses(‘AppController’, ‘Controller’); App::uses(‘EmployeesController’, ‘Controller’); class ReportingController extends AppController { public function some(){ $Employees = new EmployeesController; $Employees->constructClasses(); $Employees->areasAssigned();//areasAssigned function is in the Employees controller. } }
[sql] CREATE TABLE IF NOT EXISTS `permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(45) NOT NULL, `displayName` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `company_id` int(11) NOT NULL, `dashboard_type` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `company_id` (`company_id`) … Read more
[php] public function getRolePermisions( $roleId ){ $employee = $this->find(‘all’, array( ‘conditions’ => array( ‘RolePermission.role_id’ => $roleId ) )); $list = Set::combine($employee,'{n}.Permission.id’,'{n}.Permission.name’); return $list; } [/php]
How to get data on condition that start time only have current year data: [php] $event = $this->Event->find(‘first’, array( ‘conditions’ => array( ‘Event.id’ => $targetEvent[‘Eventtarget’][‘event_id’], ‘Event.stage’ => ‘created’, ‘year(Event.startTime)’ => date(‘Y’) ), //this is the condition we have to check ‘fields’ => array(‘Event.startTime’, ‘Event.city’, ‘Event.zip’, ‘Event.employee_id’) )); [/php]
[php]$db = ConnectionManager::getDataSource(‘default’); $db->showLog();[/php]
step 1: set path to environment variable. like: C:\xampp\php;C:\xampp\htdocs\yourproject\lib\cake\console\; step 2: open command prompt and type cd C:\xampp\htdocs\yourproject\app and press enter. step 3: now type cake bake now you can see the options there. you can continue accordingly.
convert array to object PHP $obj = json_decode (json_encode ($var), FALSE); where $var is an array. convert object to array PHP $arr = json_decode( json_encode($var), true); where $var is an object
//your core php code function __autoload($name) { require_once($name . ‘.php’); } //in cakephp you can use like this function my_autoloader($name) { require_once($name . ‘.php’); } spl_autoload_register(‘my_autoloader’);
function admin_exceladd(){ if (!empty($this->data)) { if(is_uploaded_file($this->data[‘Webshop’][‘excelfile’][‘tmp_name’])){ move_uploaded_file($this->data[‘Webshop’][‘excelfile’][‘tmp_name’], ‘img/files/’.$this->data[‘Webshop’][‘excelfile’][‘name’]); $file = ‘img/files/’.$this->data[‘Webshop’][‘excelfile’][‘name’]; $handle = fopen($file, “r”); // read the 1st row as headings $header = fgetcsv($handle); // read each data row in the file $i = 0; // for the message while (($row = fgetcsv($handle)) !== FALSE) { $i++; $data = array(); $data1 = array(); // … Read more
CREATE TABLE my_files ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(75) NOT NULL, type VARCHAR(255) NOT NULL, size INT(11) NOT NULL, data MEDIUMBLOB NOT NULL, created DATETIME, modified DATETIME, PRIMARY KEY (id) ); // app/models/my_file.php class MyFile extends AppModel { var $name = ‘MyFile’; } // app/views/my_files/add.ctp (Cake 1.2) echo $form->create(‘MyFile’, array(‘action’ => ‘add’, ‘type’ … Read more