Jump to content


rudyKipling

Member Since 26 Feb 2018
Offline Last Active Nov 15 2018 09:35 AM
-----

Topics I've Started

Using Grocery CRUD Enterprise With Oracle 12c

19 April 2018 - 09:06 AM

Hello,

 

I have been trying to use Grocery CRUD Enterprise with Oracle12c. Sadly, at first i couldn't make a connection between Oracle Database and PHP. So that i can't use Enterprise edition with Oracle.

 

This is really matters for me because in the  company i work, we are using really old fashioned technologies, such as Delphi, Oracle PL-SQL etc. We even use PL-SQL for making complex web projects and it is really annoying and tiring. Most of our desktop applications are built with Delphi. Years ago Delphi was good, but now, everybody knows that sources on the internet are limited and documentation is not that good.

 

Sorry for long sentences and whining, but i really feel frustrated about myself and the company i work.

 

Our oracle DB is in our local network, i have to make a connection to a server which is in our intranet and i have to connect with IP address from my Computer.

I have installed Oracle Instant Client, I have configured apache on my desktop, i have installed oci8.dll, oci_12g.dll, oci_11g.dll, i tried many things, almost everything.

 

I would be very happy, if anyone can find me a way to achieve a connection between our Oracle DB and PHP.

 

It will be really a revolution for our company if i can make Grocery CRUD Enterprise work with our Oracle DB.

 

The error i got is attached. 

 

Thanks,

Yusuf.

 


Does Grocery Crud Enterprise Include Clone Functionality?

27 March 2018 - 03:01 PM

Does Grocery Crud Enterprise Include Clone Functionality?


How to set a custom config item for a table and use it in edit.php or add.php

04 March 2018 - 09:10 PM

Hello,

 

I have been trying to code tabbed views for grocery crud in edit and add forms. I have did some changes on bootstrap theme's edit.php and add.php, so now i can slice form elements to tabs.

 

In add.php and edit.php files, i have 2 parameters, one of them is $slice_form, if it is true, form elements are sliced to tabs. The other parameter is $field_count_on_each_tab, it is the count of form elements that will be shown on each tab. 

 

 I have replaced this code, in add.php and edit.php:

 

<?php foreach($fields as $field) { ?>
 
<div class="md-form <?php echo $field->field_name; ?>_form_group">
        <label><?php echo $input_fields[$field->field_name]->display_as; ?><?php echo ($input_fields[$field->field_name]->required) ? "<span class='required'>*</span> " : ""; ?></label>
        <?php echo $input_fields[$field->field_name]->input?>
    </div>
                <?php }?>

 

 

 

 

 

To this code:

 

<?php $slice_form = true; ?>
 
   <?php if($slice_form){ ?>
   
   <?php $field_count_on_each_tab = 3;  ?>
 
<ul class="nav nav-tabs" role="tablist">
<?php 
 
$i = 1;
?>
            <?php foreach($fields as $field) { ?>
 
<?php if($i==1 || $i%$field_count_on_each_tab == 1) { ?><li class="nav-item"><?php } ?>
 
<?php if($i==1) { echo '<a class="nav-link active" data-toggle="tab" href="#'.$field->field_name.'" role="tab">'.$input_fields[$field->field_name]->display_as.'</a>';  } else if($i%$field_count_on_each_tab == 1){echo '<a class="nav-link" data-toggle="tab" href="#'.$field->field_name.'" role="tab">'.$input_fields[$field->field_name]->display_as.'</a>';} ?>
 
<?php if($i%$field_count_on_each_tab == 0) echo "</li>";  ?>
 
    <?php $i = $i+1; ?>
</li>
            <?php }?>
</ul>
 
 
<div class="tab-content">
<?php 
 
$i = 1;
?>
            <?php foreach($fields as $field) { ?>
 
<?php if($i==1) { echo '<div class="tab-pane active" id="'.$field->field_name.'" role="tabpanel">';  } else if($i%$field_count_on_each_tab == 1){echo '<div class="tab-pane" id="'.$field->field_name.'" role="tabpanel">';} ?>
 
<div class="md-form <?php echo $field->field_name; ?>_form_group">
        <label <?php if (!preg_match("/chosen-select/", $input_fields[$field->field_name]->input)) echo 'class="active"';?>><?php echo $input_fields[$field->field_name]->display_as; ?><?php echo ($input_fields[$field->field_name]->required) ? "<span class='required'>*</span> " : ""; ?></label>
        <?php echo $input_fields[$field->field_name]->input;?>
    </div>
 
<?php if($i%$field_count_on_each_tab == 0) echo "</div>";  ?>
    <?php $i = $i+1; ?>
 
            <?php }?>
 
</div>
   <?php }else { ?>
   
<?php foreach($fields as $field) { ?>
<div class="md-form <?php echo $field->field_name; ?>_form_group">
        <label <?php if (!preg_match("/chosen-select/", $input_fields[$field->field_name]->input)) echo 'class="active"';?>><?php echo $input_fields[$field->field_name]->display_as; ?><?php echo ($input_fields[$field->field_name]->required) ? "<span class='required'>*</span> " : ""; ?></label>
        <?php echo $input_fields[$field->field_name]->input;?>
    </div>
<?php }?>
 
   <?php } ?>
 
 
 
 
 
So now, i have achieved to view elements in tabs. But i want this option to be selectable for each table. I dont know how to pass values to add.php and edit.php. I just need to change  $field_count_on_each_tab  and  $slice_form values from a specific controller.
 
Plz help. :/
 

 


How to set datepicker and date range on grocery crud listing page

26 February 2018 - 02:37 PM

Hello,

 

How can i filter and set range for each datetime field. I want to get in this but looks hard to get it done.