PHP Application Generator

The following code is generating an error

    public function forceFilter($filter, $append=false) {
      if(!append) {
         $this->unsetFilter();
         $this->setFilter($filter);
      } else {
         $fltr=$this->filter;
         $this->unsetFilter();
         $this->setFilter($fltr.' '.$filter);
      }
    }                               

Runtime error: [Use of undefined constant append - assumed ‘append’ (this will throw an Error in a future version of PHP)]

it needs to be changed to if(!$append)

even tho the assigned datatable is filtered, the dbagenda shows all of the table’s content.

Regards

See title

When the database result set has no results then the application gives an error.

the change theme component is not working anymore, this since the last hotfix to the spform component.

while modifying a Tabs componen and selecting a tab to delete, it is deleted from the list, but the save isn’t saved.

when you create a dbgrid and select a column from the available datafields, the field gets set by default as a cDbField, but is lacking many of the cDbField properties such as:

-lookupdatafield
- lookupfilter
- lookupslave
- modaltarget
- formcommand.

which forces you to create a new field for the look up data, for example to display a departments description instead of the id in the table.

Regards

trying to set the upload dir at run time is not working, the following is the example code

function upload_1_onCreate($app)
{

 $this->uploaddir='./mypath/' . $index . '/';

}

where $index is a global variable.

The uploader ignores that setting and uploads in the predefined folder, this has been tried also in the onbeforerender, onafterrender and other methods.

Regards

It is now possible to select a font awesome image when you open up the image selector. This way it is way more easy to add awesome icons into grids for example.

Corrected. Don’t forget to set the cache property to false of the detail dataset.

The database metadata driver does not report views correctly. Sometimes views are reported as a regular table, sometimes ignored…

the dbimage component has an editable property called imagefolder where you are supposed to be able to modify the path where the component looks for the image selected in the property picture. Althoug, when the component is rendered the imagefolder property is ignored and another property called picturefolder is used to render it.

I added a new row and column plus an area object to the column. I moved the row lower on the component tree and it keeps snapping back to the top of the tree. I did a drag and drop of the row lower in the design and still it snaps to the top of the page.

The function removes sections that should be preserved, like localization and global variables

<p></p>

The IDE now detects if a form design is out of sync and protects the original from being overwritten.

The localization module has additional functionality and now detects more fieldtypes.

The list of backupfiles now contains additional date/time information and a longer dropdown for better overview

If you use shared libraries then multilangual files are not found.

<p></p>STEPS To reproduce:

Put a cDBSimpleQuery in any form. Set the SQL property to any query containing a constant string, like this:

select ‘X’ as hilera

Run the form.

Error message
tonguearse error: syntax error, unexpected ‘X’ (T_STRING) in C:PHsPeedxampphtdocsgestionit_libstest2_dbsquery_1.php on line 12

The generated file looks like this:

class test2_dbsquery_1 extends spdbsimplequery {

 public function __construct($app, $form) {
    parent::__construct('test2_dbsquery_1');
    $this->app=$app;
    $this->sql='select 'X' as hilera';

}

This does not happens if I use a cDBQuery, because the assignment to the sql property is enclosed in double quotes:
(taken from another, cDBQuery component generated file)

… $this→selectSQL=”select pkCasa,nombreCasa,’X’ as hilera “.
…

after generating code in the onbeforerender event of the carrusel component, the generated code looks like

class index_carousel_1 extends spcarousel {

public function __construct($app, $form) {
   $this->formid='id_index_carousel_1';
   $this->visible='true';
   $this->formname='index_carousel_1';
   $this->carouseltype='slide';
   $this->interval='4000';
   $this->keyboard='true';
   $this->pause='hover';
   $this->ride='carousel';
   $this->touch='true';
   $this->wrap='true';
   parent::__construct('index_carousel_1', $form);
   if (is_a($form,'spform')) {
     $form->addfield($this);
   }
   $this->addCarouselItem('item_1','_libs/images/interior-shot-of-cafe-with-chairs-near-the-bar-with-wooden-tables.jpg','','filter: blur(1px) brightness(100%);','primary','none');
   if (is_a($form,'spform')) {
       $form->addfield($this);
  }
}

}
?>

function onBeforeRender($app){
  global $mail;
  global $userpicture;
  global $username;
  global $userid;
  global $logeado;
    echo 'onbeforerender';
}    

notice the function onbeforerender appears after the ?> resulting in the code being shown as plain txt in the html response of the server.

Hi, I’m using PHsPeed 1.3.0 B9 - x64, PHP 7.4.5, standard, included, XAMPP server

When viewing or editing any given PHP file (say I open one of the generated objects PHP file, or even a PHP from the PHsPeed runtime files), if I return to the Inspector TAB, select an object, and try to create or edit an existing event, the code for a new event handler is inserted in the open PHP file.

I’m using PHsPeed 1.3.0 B9 - x64, PHP 7.4.5, standard included XAMPP server.

When I set the SQL property of a cDBQuery or a cDBSimpleQuery to a query that contains the “⇐” sign, a space is introduced between the “<” and the “=”. If the query includes some function names like “trim”, a space is added between the function name and the first parenthesis.

STEPS TO REPRODUCE:

Set the sql property of a cDBQuery or a cDBSimpleQuery to any of the following queries:

select if(1 ⇐ 2,’this universe’,’a parallel one’) as valor

select trim( ‘my string’ ) as hilera

Added functionality to transfer SQL statements into a single string and back. It will not recover to the exact original layout as the CRLF pairs are not allowed in properties. So the system will prettify the statement.

So

SELECT concat('This is', 'a sample' ) as mycolumn, emp_no, sum ( salary ) AS sal, from_date, to_date  FROM salaries  GROUP BY emp_no, from_date WITH ROLLUP

Becomes:

SELECT concat ('This is',
      'a sample' ) as mycolumn,
       emp_no,
       sum ( salary ) AS sal,
       from_date,
       to_date
FROM salaries
GROUP BY emp_no,
       from_date
WITH ROLLUP    

And visa versa

sometimes when modifying the “localization/lcuploadstr” property of the uploader the upload button fails to be generated properly.

this is because for some reason while capturing the lcuploadstr property a “line jump” caracter is parsed malforming the javascript code as in the following example.

$(document).ready(function()
{
$(”#fileuploader_editpropertyprfl_upload_1”).uploadFile({
url:”./editpropertyprfl.php”,
fileName:”myfile”,
formData: {”component”:”editpropertyprfl_upload_1”},
multiple:false,
dragDrop:false,
uploadStr:”Encabezado ←——————————————————————– ERROR HERE
“,←—————————————————————————————- DOUBLE QUOTE IN THE NEXT LINE
sequential:true,sequentialCount:1,
maxFileCount:1,
maxFileSize:1000000,
dragdropWidth:100,
statusBarWidth:0,
onSuccess:function(files,data,xhr,pd)
{
var str=’‘;str=’file=’+files[0]+’&cmd=uploadimage&component=editpropertyprfl_dbimage_2’ ;
procbutton(str, ‘true’);
}});
});

follow these steps

- create a form with any number of fields
- select any field in the “fieldfocus” property of the form
- ejecute the application

Note.- no error is generated

I can’t use a sentence using MySQL functions to calculate some column in a DBQuery.

Environment:
PHsPeed V1.3.0 B7 - x64, PHP 7.4.5

Steps to reproduce:
Just add a DBQuery and set the SQL property to

select concat(’This is’,’a sample’) as mycolumn

Then generate code and try to run the form. The field name ignores the alias, and is set to “concat(’This is”. I tried a variety of functions, like “if” or “curdate”, with same results.

Workaround:
Of course I could create a VIEW with the aliased column, but is not always feasible

follow these steps:

- right click on a form
- select the option “add grid” - make it 2 rows, 4 columns each
- since the option “assign the number of elements per column (sum should be 12), or disable” is checked
the generated grid will all have a size of 12 for every column.

- if the above option is not check then the generated columns get the calculated or typed in size.

- being the the case this is a request to set that value as uncheked by default.

follow these steps:

- create a new application
- notice that by default the “canrunstandalone” property is set to true
- execute the application (it will run)
- change the value of the property canrunstandalone to false
- execute the application ( it will redirect to the main application )
- change the value of the property back to true
- from that point on it wont run standalone it will always redirect to the main application

since the generated code creates a statement similar to:

class new extends spapplication {

a syntax error is generated, this potentially be applicable to any other “reserved” word.

in the project creation application, if the name of the default application does not have .php extension the application is generated properly but it wont run.

when using the crud generator to append any type of form (form, grid, grid-modal) the IDE generates a second application with the same name, being this a coppy of the original application whitout adding any new components

If you want Git to maintain your project, then you only have to apply the subdirectory of the project. The project file is now also copied into the project folder for that reason.

The function now keeps track of the last 10 loaded projects for fast access. It also has a new function to store a project in the shortcuts tab. This is handy when you have more projects from different project folders loaded.

The standard load message of the dbgrid has been changed from text to a small rotating icon. There is a new property that disables the message.

The event is not triggered, if you look into javascript there is an error that onselectall procedure is not found.

It looks like that when you define fields as searchfields in the grid that it influences the query that is setup in the query builder component

I cannot add/delete project folders while saving or creating project

- Create a form with dbnavigator
- add 2 field to test
- add a button to the form type button, add code to execute, for example changing the button text.
- run application
- click the button add of the dbnavigator
- once in edit mode, click the custom button.
- notice the code is executed but the dbnavigator state changes… instead of add mode goes to init mode.

The class and the imgclass properties for the dbimage component are not being rendered

<p></p>

The use of $$ is descibed in the wiki. There are now 3 more prefixes that bind the variable to components of other modules:

$$h_ binds to header
$$f_ binds to footer
$$s_ binds to side

to access menu1 on the header you could write $$h_menu1→something
PHsPeed will locate the defined header and replace the $$h_ by the correct reference.

label properties for background, typography, label color, etc not available in controls checkbox, listbox, wysiwyg, multiedit.

Although you create a new block, it generates the error that form_1 already exists (which it doesn’t)

In the wizzard you can add blocks to an application or a building block. In case of a building block you get an error if it contains a form.

The menu component has got an overhaul. Although compatible to the current configuration, the code generation has been changed. It is now possible to add, delete and change menu items dynamically by code.

Calling altermenuitem terminates module. It lacks reference $this→

The list of cDBImage properties is missing height, width, max-height and max-width

insert an image to a form
select the desired picture
set the height and width
as well as maxheight and maxwidth

notice how the html code is generated whitout semicolon making the styling code invalid.

example

<img src=”_libs/images/image.png” style=” width: 200px height: 200px max-width: 200px max-height: 200px” class=” float-none no” alt=”“>

insert an image component,
click in the button […] to the left of the picture property
click the option “select image from deploy” select the image and click ok
save the changes

notice how the picture properties now has a value similar to
image.png(alt=,width=0,height=0)

which is injected in the html code failing to charge the image.

<img src=”_libs/images/image.png(alt=,width=0,height=0)” style=” width: 200px; height: 200px; max-width: 200px; max-height: 200px;” class=” float-none no” alt=”“>