function set_defaults($record = NULL)
{
$data['mode'] = '';
$data['message'] = '';
$data = data_table($this->table_name, $record);
if ($record == NULL) {
$data['app_id'] = $this->nomor_bukti();
}
$data['score'] = '';
$data['cust_name'] = '';
$data['counter_name'] = '';
$data['loan_id'] = '';
if ($record == NULL) {
$data['app_date'] = date("Y-m-d");
$data['create_date'] = date("Y-m-d");
$data['create_by'] = user_id();
}
$data['username'] = user_name();
if (!$record == NULL) {
if ($query = $this->db->select('cust_name')->where('cust_id', $data['cust_id'])->get('ls_cust_master')) {
if ($query->row()) {
$data['cust_name'] = $query->row()->cust_name;
}
}
if ($query = $this->db->select('counter_name')->where('counter_id', $data['counter_id'])->get('ls_counter')) {
if ($query->row()) {
$data['counter_name'] = $query->row()->counter_name;
}
}
} else {
$data['cust_name'] = '';
$data['counter_name'] = '';
}
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['work_exec_no'] = $this->nomor_bukti();
}
if ($data['start_date'] == '') {
$data['start_date'] = date("Y-m-d H:i:s");
}
if ($data['expected_date'] == '') {
$data['expected_date'] = date("Y-m-d H:i:s");
}
$data['wo_customer'] = '';
$data['wo_date_from'] = '';
$data['wo_date_to'] = '';
$data['wo_comment'] = '';
$data['wo_so_number'] = '';
$this->load->model("department_model");
$this->load->model("manuf/person_model");
$data['dept_list'] = $this->department_model->lookup();
$data['person_list'] = $this->person_model->lookup();
return $data;
}
function set_defaults($record = NULL)
{
$data['mode'] = '';
$data['message'] = '';
$data = data_table($this->table_name, $record);
return $data;
}
function set_defaults($record = NULL)
{
$data['mode'] = '';
$data['message'] = '';
$data = data_table($this->table_name, $record);
$data['sales_agent_list'] = $this->sales_agent_model->dropdown();
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table("select * from customers limit 1", $record, true);
$data['mode'] = '';
$data['message'] = '';
$data['termin_list'] = $this->type_of_payment_model->select_list();
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['group_list'] = array("G1", "G2");
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['date_post'] = date("Y-m-d H:i:s");
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['account_number_list'] = $this->bank_accounts_model->account_number_list();
$data['closed'] = 0;
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['date_post'] = date('Y-m-d 00:00:00');
$data['category_list'] = array("Purchasing", "Sales", "Inventory", "Accounting", "Fixed Asset", "Payroll", "Manufacure");
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table('inventory', $record);
$data['mode'] = '';
$data['message'] = '';
$data['akun_list'] = $this->chart_of_accounts_model->select_list();
$data['category_list'] = $this->inventory_model->category_list();
$data['sub_category_list'] = $this->inventory_model->category_list();
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['purchase_order_number'] = $this->nomor_bukti();
$data['po_date'] = date("Y-m-d");
$data['summary_info'] = '';
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['purchase_order_number'] = $this->nomor_bukti();
}
$data['has_receive'] = false;
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = 'add';
$data['message'] = '';
$data['date_received'] = date("Y-m-d H:i:s");
if ($record == NULL) {
$data['shipment_id'] = $this->nomor_bukti();
}
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['nama_pegawai'] = '';
$data['date_loan'] = date("Y-m-d H:i:s");
if ($record == NULL) {
$data['loan_number'] = $this->nomor_bukti();
}
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['item_number_list'] = $this->inventory_model->item_list();
$data['date_received'] = date("Y-m-d H:i:s");
if ($record == NULL) {
$data['shipment_id'] = $this->nomor_bukti();
}
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['akun_list'] = $this->chart_of_accounts_model->select_list();
$data['terms_list'] = $this->type_of_payment_model->select_list();
$data['type_of_vendor_list'] = $this->sysvar_model->value_list('type_of_vendor');
$data['active'] = '1';
$data['saldo'] = 0;
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['mat_rel_no'] = $this->nomor_bukti();
}
if ($data['date_rel'] == '') {
$data['date_rel'] = date("Y-m-d H:i:s");
}
$data['warehouse_list'] = $this->shipping_locations_model->select_list();
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['gender'] = '';
$data['birth_place'] = '';
$data['birth_date'] = '';
$data['marital_status'] = '';
$data['no_of_dependents'] = '';
$data['house_status'] = '';
// $data['lama_thn']='';
$data['salary'] = '0';
$data['spouse_salary'] = '0';
$data['other_income'] = '0';
$data['salary_source'] = '';
$data['spouse_salary_source'] = '';
$data['other_income_source'] = '';
$data['comp_name'] = '';
$data['comp_desc'] = '';
$data['job_status'] = '';
$data['com_kec'] = '';
$data['job_status_etc'] = '';
$data['emp_status'] = '';
$data['bussiness_type'] = '';
$data['emp_status_etc'] = '';
$data['since_year'] = '';
$data['com_city'] = '';
$data['job_level'] = '';
$data['com_zip_pos'] = '';
$data['job_type'] = '';
$data['total_employee'] = '';
$data['job_type_etc'] = '';
$data['com_contact_phone'] = '';
$data['com_street'] = '';
$data['office_status'] = '';
$data['com_rtrw'] = '';
$data['office_status_etc'] = '';
$data['com_kel'] = '';
$data['phone_ext'] = '';
$data['spv_name'] = '';
$data['hrd_name'] = '';
if ($record == NULL) {
$data['create_date'] = date("Y-m-d");
$data['create_by'] = user_id();
}
$data['username'] = user_name();
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['library_src'] = $this->jquery->script();
$data['script_head'] = $this->jquery->_compile();
$data['mode'] = '';
$data['message'] = '';
$data['warehouse_code'] = $this->access->cid;
$data['invoice_date'] = date("Y-m-d H:i:s");
if ($record == NULL) {
$data['invoice_number'] = $this->nomor_bukti();
}
$data['invoice_type'] = 'D';
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['purchase_order_number'] = $this->nomor_bukti();
}
$data['po_date'] = date("Y-m-d");
$data['potype'] = 'R';
$data['closed'] = 0;
$data['posted'] = 0;
$data['warehouse_list'] = $this->shipping_locations_model->select_list();
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['work_exec_no'] = $this->nomor_bukti();
}
if ($data['start_date'] == '') {
$data['start_date'] = date("Y-m-d H:i:s");
}
if ($data['expected_date'] == '') {
$data['expected_date'] = date("Y-m-d H:i:s");
}
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['sales_order_number'] = $this->nomor_bukti();
}
if ($data['sales_date'] == '') {
$data['sales_date'] = date("Y-m-d H:i:s");
}
if ($data['due_date'] == '') {
$data['due_date'] = date("Y-m-d H:i:s");
}
$data['customer_info'] = "";
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
if ($record == NULL) {
$data['work_exec_no'] = $this->nomor_bukti();
}
if ($data['start_date'] == '') {
$data['start_date'] = date("Y-m-d H:i:s");
}
if ($data['expected_date'] == '') {
$data['expected_date'] = date("Y-m-d H:i:s");
}
$data['wo_customer'] = '';
$data['wo_date_from'] = '';
$data['wo_date_to'] = '';
$data['wo_comment'] = '';
$data['wo_so_number'] = '';
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['library_src'] = $this->jquery->script();
$data['script_head'] = $this->jquery->_compile();
$data['mode'] = '';
$data['message'] = '';
$data['warehouse_code'] = $this->access->cid;
if ($record == NULL) {
$data['invoice_date'] = date("Y-m-d");
}
if ($record == NULL) {
$data['invoice_number'] = $this->nomor_bukti();
}
$data['invoice_type'] = 'I';
$data['summary_info'] = '';
$data['customer_info'] = '';
$data['discount_amount'] = 0;
$data['tax_amount'] = 0;
return $data;
}
function data_table()
{
$servername = "localhost";
$username = "******";
$password = "";
$dbname = "mydb";
//create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
//check connection
if (!$conn) {
die("connection failed :" . mysqli_connect_errno() . " " . mysqli_connect_error());
}
$sql = "SELECT id,firstname,lastname from myguest";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo "<br><br><table border=1><tr bgcolor=cyan><th>ID</th><th>NAME</th></tr>";
//output data of each row
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr><td>" . $row["id"] . "</td><td>" . $row["firstname"] . " " . $row["lastname"] . "</td></tr>";
}
echo "</table>";
} else {
echo "0 result";
}
}
data_table();
mysqli_close($conn);
?>
</body>
</html>
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['supplier_info'] = "";
$data['faktur_info'] = "";
$data['supplier_number'] = "";
return $data;
}
function set_defaults($record = NULL)
{
$data = data_table($this->table_name, $record);
$data['mode'] = '';
$data['message'] = '';
$data['supplier_list'] = $this->supplier_model->select_list();
$data['warehouse_list'] = $this->shipping_locations_model->select_list();
if ($record == NULL) {
$data['date_received'] = date("Y-m-d");
$data['receipt_type'] = 'PO';
$data['shipment_id'] = $this->sysvar->autonumber("Receivement Numbering", 0, '!TRM~$00001');
}
return $data;
}