haifahrul

public function actionGetData()
    {
        $request = Yii::$app->request;
        Yii::$app->getResponse()->format = 'json';
        $query = (new \yii\db\Query())
            ->select('m_unit.*, m_people.*')
            ->from("m_people")
        ->leftJoin('m_unit', 'm_unit.id = unit_id');
        // searching
        if (($q = $request->post('q'))) {

haifahrul

 <table id="dg" class="" toolbar="#dg-toolbar">
        <thead data-options="frozen:true">
            <th field="ktp" sortable="true" fixed="true" width="120">KTP</th>
            <th field="people_name" sortable="true" fixed="true" width="180">Name</th>
            <th field="people_gender" sortable="true" fixed="true" width="80" align="center">Gender</th>
        </thead>
        <thead>
        <tr>
            <th field="ktp" sortable="true" fixed="true" width="120">KTP</th>
            <th field="people_name" sortable="true" fixed="true" width="180">Name</th>

haifahrul

sudo bucardo install

# ADD DATABASE
sudo bucardo add db kitaon_master dbname=kitaon host=localhost
sudo bucardo add db kitaon_slave dbname=kitaon_replica host=localhost

# ADD TABLES
sudo bucardo add all tables db=kitaon_master -T history --herd=master --verbose
sudo bucardo add all tables db=kitaon_master -t history --herd=slave --verbose

haifahrul

@import "../../../shared/styles/colors";
@import "../../../shared/styles/constants";

/**
  * Ngx-Datatable
  */
:host /deep/ .ngx-datatable.bootstrap {
  margin-bottom: 50px;
  box-shadow: none;
  font-size: 13px;

haifahrul

# Modal In Angular 6

## Component.ts

// Modal
  private id: number;
  public action: string;
  public title: string;
  public modalTitle: string;
  public modalReference: NgbModalRef;