NIDN dengan Status Tidak Tetap

Kepada Yth    :    Pimpinan Perguruan Tinggi (Terlampir)

Bersama ini dengan hormat kami sampaikan bahwa NIDN  adalah identitas nasional bagi seseorang yang telah memenuhi syarat sebagai dosen tetap, sedangkan bagi dosen tidak tetap diberikan Nomor Urut Pengajar (NUPN). Berdasarkan data sementara kami pada laman forlap.dikti.go.id, ada sebanyak ± 1.135 dosen ber-NIDN namun berstatus sebagai dosen tidak tetap (terlampir).  Berkenaan dengan hal itu kami mohon kerjasama Saudara untuk :

  1. Melakukan validasi terhadap dosen sebagaimana dimaksud di atas di perguruan tinggi Saudara, jika benar-benar berstatus sebagai dosen tetap.
  2. Validasi sebagaimana point 1 dilakukan pada laman forlap.dikti.go.id dengan login sebagai akun PT Saudara pada menu Perubahan Data Dosen dengan cara mengubah status dosen yang dimaksud menjadi dosen tetap dengan melampirkan dokumen sebagaimana ajuan NIDN baru yaitu :
  • KTP terbaru.
  • Ijasah lengkap mulai dari S1.
  • SK Dosen Tetap yang memuat substansi tentang hak dan kewajiban antara dosen dengan  yayasan.
  • Surat penyataan sebagai dosen tetap.
  • 5)    SK jabatan akademik (jika ada)

Ajuan validasi dimaksud di atas, akan ditutup pada tanggal 23 Nopember 2013. Jika setelah tanggal tersebut belum diajukan validasi, maka NIDN dengan status tidak tetap tersebut akan segera dihapus dan diganti menjadi NUPN.
Demikian disampaikan atas perhatian dan kerjasamanya diucapkan terima kasih.

Direktur Pendidik dan Tenaga Kependidikan
TTD
Supriadi Rustad
NIP. 19600104 198703 1002

Tembusan:
-    Sesditjen Pendidikan Tinggi
-    Koordinator Kopertis I-XIV

Link Yii Indonesia

y Muhammad Rifki Mockie on Tuesday, March 20, 2012 at 10:24pm

http://sabitlabscode.wordpress.com/

 

http://maleskoding.wordpress.com/2012/05/04/membuat-twitter-update-bot-menggunakan-yii/

 

http://ningrate.wordpress.com/2012/05/09/installasi-yii-di-mac/

 

http://maleskoding.wordpress.com/tag/yii-framework/

Blog : http://dreazrehael.wordpress.com , Ebook : http://sabitlabscode.files.wordpress.com/2012/01/menjelajahyiiframework.pdf , Source Contoh : http://freeebookyii.codeplex.com/

By dtriyanto Posted in Santai

Yii – Executing SQL Statements

Once a database connection is established, SQL statements can be executed using CDbCommand. One creates a CDbCommand instance by calling CDbConnection::createCommand() with the specified SQL statement:

$connection=Yii::app()->db;   // assuming you have configured a "db" connection
// If not, you may explicitly create a connection:
// $connection=new CDbConnection($dsn,$username,$password);
$command=$connection->createCommand($sql);
// if needed, the SQL statement may be updated as follows:
// $command->text=$newSQL;

A SQL statement is executed via CDbCommand in one of the following two ways:

* execute(): performs a non-query SQL statement, such as INSERT, UPDATE and DELETE. If successful, it returns the number of rows that are affected by the execution.
* query(): performs an SQL statement that returns rows of data, such as SELECT. If successful, it returns a CDbDataReader instance from which one can traverse the resulting rows of data. For convenience, a set of queryXXX() methods are also implemented which directly return the query results.

An exception will be raised if an error occurs during the execution of SQL statements.

$rowCount=$command->execute();   // execute the non-query SQL
$dataReader=$command->query();   // execute a query SQL
$rows=$command->queryAll();      // query and return all rows of result
$row=$command->queryRow();       // query and return the first row of result
$column=$command->queryColumn(); // query and return the first column of result
$value=$command->queryScalar();  // query and return the first field in the first row

Share this:

By dtriyanto Posted in Santai

Kamus Yii by sonsonz.wordpress.com

Fungsi Pencarian

// find the first row satisfying the specified condition
$post=Post::model()->find($condition,$params);
// find the row with the specified primary key
$post=Post::model()->findByPk($postID,$condition,$params);
// find the row with the specified attribute values
$post=Post::model()->findByAttributes($attributes,$condition,$params);
// find the first row using the specified SQL statement
$post=Post::model()->findBySql($sql,$params);

Fungsi Filter

- protected (before|after)(Delete|Save|Find)() ?
- $this->isNewRecord ?
- protected afterConstruct()

Fungsi Relasi Database

'VarName'=>array('RelationType', 'ClassName', 'ForeignKey', ...additional options)
BELONGS_TO? 'author'=>array(self::BELONGS_TO, 'User', 'author_id'),
HAS_MANY?
HAS_ONE?
BELONGS_TO? MANY_MANY: 'relation_a_b' => array(self::MANY_MANY, 'B', A_B('a_id','b_id'),
'relation_b_a' => array(self::MANY_MANY, 'A', A_B('b_id','a_id'), ?
STAT?
load by attribute:$model->relationName?
with()?

CDbCriteria

    $criteria=new CDbCriteria;
    $post=Post::model()->find($criteria);
    select: $criteria->select='title';
    condition: $criteria->condition='postID=:postID';
    params: $criteria->params=array(':postID'=>10); 
    on: 
    order: 
    with: 
    joinType: 
    alias: 
    together: 
    join: 
    group:
    ?
    having: ?
    index: ?
    limit: ?
    offset: ?

Share this:

By dtriyanto Posted in Santai

Yii Examples of Using CDbCriteria

Examples of Using CDbCriteria
Basic Usage

$Criteria = new CDbCriteria();
$Criteria->condition = "price > 30";
$Products = Product::model()->findAll($Criteria);

OR

//An example using the constructor to populate the properties.
$Criteria = new CDbCriteria(array('condition' => 'price > 30'));
$Products = Product::model()->findAll($Criteria);

Personally, I like to go with the first approach. I think it’s generally easier to read, but that’s just my personal preference.
Adding A Limit

$Criteria = new CDbCriteria();
$Criteria->condition = "price > 30";
$Criteria->limit = 1;
$Products = Product::model()->findAll($Criteria);

Limit with Offset

$Criteria = new CDbCriteria();
$Criteria->condition = "price > 30";
$Criteria->limit = 1;
$Criteria->offset = 1;
$Products = Product::model()->findAll($Criteria);

Ordering Results

$Criteria = new CDbCriteria();
$Criteria->condition = "price > 30";
$Criteria->limit = 1;
$Criteria->offset = 1;
$Criteria->order = "name ASC";
$Products = Product::model()->findAll($Criteria);

Limiting Selected Fields

$Criteria = new CDbCriteria();
$Criteria->condition = "price > 30";
$Criteria->limit = 1;
$Criteria->offset = 1;
$Criteria->order = "name ASC";
$Criteria->select = "id, name";
$Products = Product::model()->findAll($Criteria);

Example relation with :

$criteria = new CDbCriteria;
$criteria->with = array('foreign_table1',
                        'foreign_table2', 
                        'foreign_table2.foreign_table3');
$criteria->together = true; // ADDED THIS
$criteria->select = array('id');
$criteria->condition = "foreign_table1.col1=:col_val AND 
                        foreign_table3.col3=:col_val2";
$criteria->params = array(':col_val' => some_val, ':col_val2' => other_val);
$criteria->order = 'foreign_table3.col5 DESC';
$criteria->limit = 10;

Share this:

Like this:

By dtriyanto Posted in Santai

Yii – CSqlDataProvider

 $sql = "SELECT mis_item_uom.* FROM mis_item_uom WHERE item_code='$model->itemCode' ";
$dataProvider=new CSqlDataProvider($sql, array(
'sort'=>array(
'attributes'=>array(
'uom',
'item_code',
'rate',
),
),
'pagination'=>array(
'pageSize'=>10,
),
));
$this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'uom','item_code','rate',
)
));
By dtriyanto Posted in Santai

Yii – Data Provider

Dari pada lupa mendingan tulis disini saja :) sapa tau ada yang butuh juga … hehehe.
Emang kebiasaan developer pasti selalu membuat catatan agar mudah diingat dikemudian hari. betul ??

// attempt 1
$dataProvider = new CActiveDataProvider('Vehicle');

// attempt 2
$dataProvider = new CSqlDataProvider('SELECT id, year FROM vehicle');

// attempt 3
$dataProvider = new CArrayDataProvider(array(array('id'=>1,'year'=>'1998'),array('id'=>2,'year'=>'1999')));

Share this:

By dtriyanto Posted in Santai

Yii – Relation banyak FK

Untuk menghindari lupa, saya posting disini sekalian biar yang lain bisa baca2 juga.
Kondisi yang sering terjadi adalah jika terjadi lebih dari 2 ForeignKey, maka di yii bisa menyelesaikannya dengan contoh dibawah :


'rGlVoucher' => array(self::BELONGS_TO, 'Gl', '','on'=>"rGlVoucher.profile_id=t.profile_id and rGlVoucher.account_no = t.account_no"),

By dtriyanto Posted in Santai