'.$countmaster_petak.' Master Petak
';
$values[$field['field']] .= '
Ada '.$counttx.' transaksi LKP
';
$values[$field['field']] .= '
Ada '.$counttx_foto_lkp.' foto LKP
';
$values[$field['field']] .= '
Ada '.$counttx_foto_morfologi.' foto morfologi
';
$values[$field['field']] .= '
Ada '.$counttx_foto_drone.' foto drone
';
$values[$field['field']] .= '
Ada '.$countpetakpupuk.' petak pupuk
';
$values[$field['field']] .= '
Ada '.$counttx_pica_pi.' transaksi PICA PI
';
if($counttx > 0 || $counttx_foto_lkp > 0 || $counttx_foto_morfologi > 0 || $counttx_foto_drone > 0 || $countmaster_petak > 0 || $countpetakpupuk > 0){
$values[$field['field']] .= '
';
}
$values[$field['field']] .= '
';
}else{
$values[$field['field']] = '
Petak Lama Sama dengan Petak Baru
';
}
}else{
$values[$field['field']] = \SiteHelpers::formatRows($row->{$field['field']}, $field , $row);
}
}
}
$values['action'] = \SiteHelpers::buttonAction($this->module,$this->access ,$row->{$this->info['key']} ,$this->info['setting']) ;
$array[] = $values;
}
$data = array(
'draw' => (!is_null($request->input('draw')) ? intval($request->input('draw') ) : 0),
'recordsTotal' => $results['total'] ,
'recordsFiltered' => $results['total'],
'data' => $array
);
return response()->json($data);
}
public function destroy( Request $request)
{
if(!\Auth::check())
return response()->json(array(
'status'=>'error',
'message'=> 'You are not login'
));
$this->access = $this->model->validAccess($this->info['id'] , session('gid'));
if($this->access['is_remove'] ==0)
return response()->json(array('status'=>'error','message'=> __('core.note_restric')));
// delete multipe rows
if(count($request->input('ids')) >=1)
{
$this->model->destroy($request->input('ids'));
return response()->json(array(
'status'=>'success',
'message'=> __('core.note_success_delete')
));
} else {
return response()->json(array(
'status'=>'error',
'message'=> __('core.note_error')
));
}
}
static function makeInfo2( $id )
{
$row = \DB::table('tb_module')->where('module_name', $id)->get();
$data = array();
foreach($row as $r)
{
$langs = (json_decode($r->module_lang,true));
$data['id'] = $r->module_id;
$data['title'] = \SiteHelpers::infoLang($r->module_title,$langs,'title');
$data['note'] = \SiteHelpers::infoLang($r->module_note,$langs,'note');
$data['table'] = $r->module_db;
$data['key'] = $r->module_db_key;
$data['type'] = $r->module_type;
$data['config'] = \SiteHelpers::CF_decode_json($r->module_config);
$field = array();
foreach($data['config']['grid'] as $fs)
{
foreach($fs as $f)
$field[] = $fs['field'];
}
$data['field'] = $field;
$data['setting'] = array(
'gridtype' => (isset($data['config']['setting']['gridtype']) ? $data['config']['setting']['gridtype'] : 'native' ),
'orderby' => (isset($data['config']['setting']['orderby']) ? $data['config']['setting']['orderby'] : $r->module_db_key),
'ordertype' => (isset($data['config']['setting']['ordertype']) ? $data['config']['setting']['ordertype'] : 'asc' ),
'perpage' => (isset($data['config']['setting']['perpage']) ? $data['config']['setting']['perpage'] : '10' ),
'frozen' => (isset($data['config']['setting']['frozen']) ? $data['config']['setting']['frozen'] : 'false' ),
'form-method' => (isset($data['config']['setting']['form-method']) ? $data['config']['setting']['form-method'] : 'native' ),
'view-method' => (isset($data['config']['setting']['view-method']) ? $data['config']['setting']['view-method'] : 'native' ),
'inline' => (isset($data['config']['setting']['inline']) ? $data['config']['setting']['inline'] : 'false' ),
);
}
return $data;
}
public function cekdatapetak(Request $request)
{
if (!\Auth::check()) {
return response()->json([
'status' => 'error',
'message' => 'You are not logged in'
]);
}
$dataPetak = \DB::table('master_petak')->where('lahan_id', $request->input('petak_lama'))->first();
if ($dataPetak === null) {
return response()->json([
'status' => 'error',
'message' => 'No data found for the given lahan_id'
]);
}
return response()->json([
'status' => 'success',
'data' => $dataPetak
]);
}
public function ubahdatapetak(Request $request)
{
if (!\Auth::check()) {
return response()->json([
'status' => 'error',
'message' => 'You are not logged in'
]);
}
$oldIdLahan = $request->input('idlama');
$newIdLahan = $request->input('idbaru');
if (empty($oldIdLahan) || empty($newIdLahan)) {
return response()->json([
'status' => 'error',
'message' => 'Both old_id_lahan and new_id_lahan are required'
]);
}
try {
\DB::table('TX_TOTAL_KSO')
->where('id_lahan', $oldIdLahan)
->update(['id_lahan' => $newIdLahan]);
\DB::table('master_petak')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_foto_kebun')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_morfologi')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_foto_drone')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('t_distribusi_pupuk_herbisida')
->where('petak', $oldIdLahan)
->update(['petak' => $newIdLahan]);
\DB::table('m_petak_pupuk')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_tebu_berbunga')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_serangan_hpt')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_tebu_roboh')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
\DB::table('tx_pica_pi')
->where('lahan_id', $oldIdLahan)
->update(['lahan_id' => $newIdLahan]);
return response()->json([
'status' => 'success',
'message' => 'Data successfully updated'
]);
} catch (\Exception $e) {
return response()->json([
'status' => 'error',
'message' => 'An error occurred: ' . $e->getMessage()
]);
}
}
}