$tableColumns['category'] = array( 'display_text' => 'Category', 'perms' => 'EVCTAXQSHOF' ); $tableColumns['priority'] = array( 'display_text' => 'Priority', 'perms' => 'EVCTAXQSHOF', 'input_info' => ' type="number" min="0" max="9" ', ); $tableColumns['notes'] = array( 'display_text' => 'Notes', 'perms' => 'ACEFHOQSTVX', 'textarea' => array('cols' =>24, 'rows' =>3) ); $tableColumns['duetime'] = array( 'display_text' => 'DueDate', 'req' => true, 'perms' => 'EVCTAXQSHOF', 'display_mask' => 'date_format(`duetime`,"%d %M %Y")', 'order_mask' => tblMain.'.duetime', 'range_mask' => tblMain.'.duetime', 'calendar' => array('js_format' => 'dd MM yy', 'options' => array('showButtonPanel' => false)) ); $tableColumns['created_at'] = array( 'display_text' => 'Created_At', 'perms' => 'ADFTHAQSVX', 'display_mask' => 'date_format(`created_at`,"%Y-%m-%d %T")', 'order_mask' => 'date_format(`created_at`,"%Y-%m-%d %T")', 'range_mask' => 'date_format(`created_at`,"%Y-%m-%d %T")', 'calendar' => array( 'js_format' => 'dd MM yy', 'options' => array('showButtonPanel' => true) ), 'mysql_add_fun' => "NOW()", 'hidden_add' => true ); $tableColumns['updated_at'] = array( 'display_text' => 'Updated_At', 'perms' => 'ADFHTAQSVX', 'display_mask' => 'date_format(`updated_at`,"%Y-%m-%d %T")', 'order_mask' => 'date_format(`updated_at`,"%Y-%m-%d %T")', 'range_mask' => 'date_format(`updated_at`,"%Y-%m-%d %T")', 'calendar' => array( 'js_format' => 'dd MM yy', 'options' => array('showButtonPanel' => true) ), 'mysql_add_fun' => "NOW()", 'mysql_edit_fun' => "NOW()", 'hidden_add' => true, 'hidden_edit' => true );