$attributeCompareValue = explode(',', $values); $length = 0; foreach ($attributeCompare as $k => $v) { if ($v != '0') { $length++; } } foreach ($attributeList as $k => $v) { $continue = $k < $length - 1 ? 'AND ' : ''; if ($attributeCompare[$k] != '0') { array_push($conditions, array('att' => $v, 'compare' => $attributeCompare[$k], 'value' => '"' . $attributeCompareValue[$k] . '"', 'continue' => $continue)); } } $sqlm->setGeneratorParams($queryType, array($table), $attributeList, $conditions, false, false, false, $distinct); $sql = $sqlm->generateSql(); $r = $sqlm->executeSql(); $i = 0; foreach ($r as $k => $v) { $i++; $r[$k]['action'] = base64_encode("<input type='hidden' name='select_row_{$i}' id='row_pks_{$i}' data-pk='" . join(',', $sqlm->getPrimaryKeys($table)) . "' data-pkvalues='" . join(',', $sqlm->getPrimaryKeyValues($table, $v)) . "' class='tupla_select'><span class='glyphicon glyphicon-edit editarTupla' id='editar_{$table}_{$r[$k][0]}' data-row='{$i}' data-id='{$r[$k][0]}'></span><span class='glyphicon glyphicon-remove removerTupla' id='deletar_{$table}_{$r[$k][0]}' data-row='{$i}' data-id='{$r[$k][0]}'></span>"); } $columns = array(array('mData' => 'action', 'sTitle' => 'Ação', 'sClass' => 'actionColumn')); foreach ($sqlm->getColumns($table) as $k => $v) { array_push($columns, array('mData' => $v['Field'], 'sTitle' => $sqlm->renameColumns($v['Field']), 'sClass' => 'sortCustomColumn ' . $v['Field'])); } $sqlm->setJSON(array('aoColumns' => $columns, 'aaData' => $r)); break; case 'Insert': $attributeList = explode(',', $attributes); $attributeValues = explode(',', $values); $attributeSql = array('att_names' => $attributeList, 'att_values' => $attributeValues);