Hi i’ve upgraded my version from 2.6 to 2.6 and grid connnector frpm 0.9 to 1:
Since these changes i’m not able to update record:
Here is my connector code:
<?php require_once("../../includes/config.php"); require_once("../../includes/dhtmlxSuite/dhtmlxConnector/codebase/grid_connector.php"); $db_selected = mysql_select_db($mysql_db_1, $link); function mark_timesheet($row) { if ($row->get_value("in_note") == "Timb. non rilevata" || $row->get_value("out_note") == "Timb. non rilevata") $row->set_row_style("font-weight:bold;color:red;"); } $timesheet_grid = new GridConnector($link); $timesheet_grid->enable_log("Log/employee_timesheet_connector.log",true); $timesheet_grid->set_encoding("ISO-8859-1"); $timesheet_grid->dynamic_loading(100); $timesheet_grid->event->attach("beforeRender","mark_timesheet"); function timesheet_update($data) { $attendance_id=$data->get_value("attendance_id"); $employee_id=$data->get_value("employee_id"); $punchin_time=$data->get_value("punchin_time"); $punchout_time=$data->get_value("punchout_time"); $in_note=$data->get_value("in_note"); $out_note=$data->get_value("out_note"); $status=$data->get_value("status"); //$conn->sql->query("UPDATE hs_hr_attendance SET in_note='{$in_note}' , out_note='{$out_note}' where attendance_id={$attendance_id}"); mysql_query("UPDATE hs_hr_attendance SET in_note='{$in_note}' , out_note='{$out_note}' , punchin_time='{$punchin_time}' , punchout_time='{$punchout_time}' , status='{$status}' where attendance_id={$attendance_id}"); $data->success(); //if you have made custom update - mark operation as finished } $timesheet_grid->event->attach("beforeUpdate","timesheet_update"); $timesheet_grid->render_sql("SELECT " . "hs_hr_attendance.attendance_id, hs_hr_attendance.punchin_time, hs_hr_attendance.in_note, " . "hs_hr_attendance.punchout_time, hs_hr_attendance.out_note, " . "hs_hr_attendance.status, hs_hr_attendance.employee_id from hs_hr_attendance " . "JOIN hs_hr_employee " . "ON hs_hr_attendance.employee_id=hs_hr_employee.emp_number " . "WHERE hs_hr_employee.employee_id LIKE" ."'". $_GET["filter"] ."%" . "'". "AND hs_hr_attendance.status= '1' AND ( hs_hr_attendance.in_note<>'' OR hs_hr_attendance.out_note<>'') " . "ORDER BY punchin_time DESC", "attendance_id","punchin_time,in_note,punchout_time,out_note,status"); require_once("../close.php"); ?>Is there anything difference?
am i doing anything wrong?
Thank u