Questions on UI for PHP Forum

4 answers

356 views

Making a column with dropdown list editor required

I'm just starting a project using PHP, rather than my more familiar ASP.NET MVC.

I'm trying to get a grid with a pop-up editor working, containing a field bound to a drop-down list. I've (finally) got this working, but even though I've added the required validation to the field, and the field in the table is not nullable, the form is still allowing blank entries, which are populated as ''.

The field is defined as:-

$monthField = new \Kendo\Data\DataSourceSchemaModelField('Month');

$monthField->type('string')

->validation(array('required'=>true));

The column is :-

$monthColumn = new \Kendo\UI\GridColumn();

$monthColumn->field('Month')

->editor('monthDropDownEditor');

and the validator is set up as:-

function monthDropDownEditor(container, options) {

$('<input data-text-field="Month" data-value-field="Month" data-bind="value:' + options.field + '"/>')

.appendTo(container)

.kendoDropDownList({

autoBind: false,

dataSource: {

schema: {

data: "data"

},

transport: {

read: {

url: "dataSourceMonths.php?type=read",

type: "POST",

dataType: "json"

}

},

optionLabel: "Select month...",

});

}

What do I need to do to make this a required field, and pop-up a validation message?

Thanks

Grid

answered on 24 Aug 2017

1 answer

64 views

Grid Header Row Multicolumn Alignment

How to create title of Header Row Multicolumn Alignment At of The Middle Merge Rows. See Picture

Grid

answered on 14 Aug 2017

1 answer

185 views

Line height in Excel export

Hi,

We use the Excel export feature of your component.

In the export I have few cells that contains multi-line text.

In the exported file, the line height is set to the default value.

Is it possible to set the line height to some kind of "auto" to fit the content and expand if necessary ?

Best regards

Emmanuel

Grid

answered on 12 Jul 2017

1 answer

111 views

Information not showing in grid

Hi,

I have tried the example of information retrieve from database and show in grid.But failed

json outputs coming properly. See below. but not showing data in grid.Find attached files of code used php.

Thank you.

Grid

answered on 26 Jun 2017

2 answers

130 views

update or create not working

this is the code that I am using for update or create but when starting for edit or create and the bottom name changed to update nothing is working till pressing cancel.

<?php
require_once 'config.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
header('Content-Type: application/json');
}

$inputJSON = file_get_contents('php://input');
$paredData = json_decode($inputJSON, TRUE);

$pn= $paredData["filed1"];
$sc = $paredData["filed2"];

/**
* connect to database and execute sqql command
*/
$tableName = '********' ;

$conn = oci_connect($dbuser, $dbpassword , $dbhost.':'.$dbport.'/'.$dbname);

$sqlStatement = 'insert into '.$tableName.'(pn, SC) VALUES ('.$PN.', '.$sc.'.');';
echo $sqlStatement;
$retrive = oci_parse($conn , $sqlStatement);
$execute = oci_execute($retrive);

if ($execute){
echo 'successful';
oci_commit($conn);
LogerFile($databaseLogEvents,$partNo.' inserted Succesfuly. ');
} else {
echo ' error';
oci_rollback($conn);
LogerFile($errorLogEvents,$partNo.' has been Rolleback something went wrong for inserting. ');
}

Grid

answered on 16 Jun 2017

2 answers

149 views

Mysql, DateTime and DataSourceResult

Hi,

I use the DataSourceResult as the datasource of my grid.

But DateTime are not inserted/updated correctly as they are not correctly formated for MySql.

I had to add the following code to the update method. Same code would also be required for insert I think.

Do you have a better solution than mine ?

$result = date_parse($model->$property);

if($result["error_count"] == 0)

{

$input_parameters [] = date_format(new DateTime($model->$property), 'Y-m-d H:i:s');

}

else

{

$input_parameters [] = $model->$property;

}

Grid

answered on 26 Apr 2017

3 answers

117 views

Boolean datasource binding

By utilizing the PHP wrapper, I have set a grid field as type boolean.

The field however does not bind to the datasource, as the field ends up with value false even when datasource field value is 1 (true).

In MySQL database, the field was first set to TINYINT(1) then to BOOLEAN with same resulting missing binding.

How to bind such a grid field to a boolean datasource field?

And how to let this boolean field come up as a checkbox, not as true & false? I think such boolean fields in general should always end up as checkboxes by default, not as true & false, yes & no etc...

Grid

answered on 20 Apr 2017

1 answer

74 views

Custom field template is not working as expected

Hello,

I'm trying to solve problem with rendering objects, I've found a solution using custom template for field.

My code:

$interprets = new \Kendo\UI\GridColumn();
       $interprets
           ->field('interprets')
           ->template('#
           var template = "<ul>";
   for (var i = 0; i < interprets.length; i++) {
       template = template + "<li>" + interprets[i].contact.name+ "</li>";
   }

   return template + "</ul>";
#')
           ->title('interprets');

But the result is not what I expected, it can be seen on screenshot attached.

Can you please tell me, how to solve this issue?

Thanks a lot

Grid

answered on 13 Apr 2017

1 answer

158 views

How to use mysql query?

Hi!

I'm using Kendo UI for Php for create a grid, I connect it to mysql db and I get the data.

I get the id and some other data, when I update I have to edit also other field that I don't show to the user. I need to use custom query but I cannot get the data from $request->models

Can someone help me?

Thanks

I'm trying

Grid