EllisLab Community Forums

Datamapper: Something like where_in_related, but including all

2013-05-23T13:18:30-05:00

Ok, I’m working on a realestate website and I have few tables (of importance here) such as:

properties: id, title, desc, price,
amenities: id, name
amenities_properties: id, amenity_id, property_id

Now, within a search there are checkboxes that are used to select amenities that must be present in a property. So, in my controller I had something like:

$results = new Property();
$results->distinct();
//other search queries go here...
$results->where_in_related_amenity('id', (array)$amenities_ids);
//other search queries go here...
$results->get(); 

This gets all properties that have at least one of the selected amenities, but I need only the properties that have them all!

So I thought something like this will solve my problems:

$results = new Property();
$results->distinct();
//other search queries go here...
$results->group_start();
foreach ($amenities_ids as $am_id)
{
   $results->where_related_amenity('id', (int)$am_id);
}
$results->group_end();
//other search queries go here...
$results->get(); 

Unfortunately, this returns no properties in my $results, although I’m sure at least one of them had amenities I tested with. The generated query has no errors but retrieves nothing. Here it is:

SELECT DISTINCT `properties`.*
FROM (`properties`)
...
LEFT OUTER
 JOIN `amenities_properties` amenities_properties ON `properties`.`id` =
 `amenities_properties`.`property_id`
WHERE
...
AND  (
`amenities_properties`.`amenity_id` = 24
AND
 `amenities_properties`.`amenity_id` = 9
) 

Any other ideas how to get properties that have ALL selected amenities related to them?

Code Igniter - Datamapper ORM 1.8.2 - Table Generation

2013-05-23T04:51:31-05:00

Hi, First of all I would like to thank CodeIgniter for a great framework, planning and reasearch lead me to decide to use CI an Datamapper ORM for my project.

Many post is about the CI - DataMapper ORM rises with how to generate Model From Database which in my point of view is much complicated as the application will have to know your conventions in table which would be very .... but possible maybe :D

My question is much much possible as Can DataMapper Generate Table in the Database from your define Model or is there any Datamapper extension or helper that would do this:

ex : generateTable(‘modelName’)

now i know this is possible as the plugin knows what it needs. is there any such so I would never have to code them my self.

Thanks
Nick Ace

How to make QR Code in codeigniter

2013-05-23T06:08:00-05:00

hi all, is there anything that can help me to make qr code generator program in codeigniter ..?
please help ...
Thank you.

DataMapper ORM v1.8.2

2011-11-30T16:43:26-05:00

DataMapper ORM 1.8.2

Download the Latest Version Here

View the change log and the upgrade process
Having issues? Please look through the Troubleshooting Guide & FAQs
View the Complete Manual
Search the Manual
(Due to the server’s caching configuration, you may need to forcibly refresh your browser to see the changes in the manual.)

DataMapper (DM) is an Object-Relational Mapper that builds on ActiveRecord. Data is loaded from database tables into objects, and relationships can be managed through simple, easy-to-read functions.

To install DataMapper ORM, the (fairly simple) upgrade process is described here.

DataMapper offers these features:
• Everything is an object!
• Easy to setup, easy to use.
• Custom Validation on object properties.
• Lazy Loading (related objects are only loaded upon access).
• Relations and their integrity are automatically managed for you.
• One to One, One to Many, and Many to Many relations fully supported.
• Select data in the style of Active Record (with or without Method Chaining).

You can learn much more from the manual.

———————————————————————————————————

Version 1.8.2:
* New Features
o Backported the DataMapper 2.0 bootstrap to get access to core classes in CodeIgniter version 2.0.3 and above.
o Changed the way watched methods are processed. This allows extensions to replace core methods.
o Add support for an absolute path for “extensions_path”.
o Added a all_to_single_array() method to the array extension.
* Bug Fixes
o Added a default for nestedsets root field name as described in the documentation.
o Fixed ignoring model configuration properties with a NULL or FALSE value.
o Fixed broken trans_status() method.
* Other Changes
o Improved the way the available model paths are determined.
o Several corrections to the documentation.

This version introduces a bootstrap loader that needs to be installed in your index.php file, and will allow DataMapper to access CodeIgniters protected core methods and properties, while keeping CodeIgniters core extension mechanism operational (DataMapper does not introduce MY_ versions of libraries).

Make sure to check out the changelog — you won’t want to skip this update!

————————————————————————————————————————

Bug reports and feature requests:

DataMapper has moved to Github for the development of version 2.0. Please use the issue register / bug tracker on github to report new bugs or for new feature requests. If you do, please include in your description is link to the thread on this forum discussing the issue (if possible), so I have a link between the two and can keep track of all issues.

————————————————————————————————————————

Older Discussions: Version 1.8.1, Version 1.8.0, Version 1.7.1, Version 1.6.2, Version 1.5.4, Version 1.5.3 and older.

Thanks goes to Overzealous, for all he has achieved with DMZ. And to stensi, for providing such an amazing code base to work on.

zip library CRC32 error

2013-05-23T02:58:29-05:00

I am getting an error with my zip files when I try to zip following code

Controller

//gets the zipname and the projectDir to send to the downloadZip function
    public function downloadZip() {


        $zipName = $this->project_model->getProjectTitle($this->uri->segment(3));
        $projectDir = $this->project_model->getProjectPath($this->uri->segment(3));


        $this->doDownload($projectDir, $zipName);
    }

    //Does sends all projects to the downloadZip function
    public function downloadAllProjects() {

        if ($_SESSION['isAdmin'] != true) {
            redirect('user');
        }
        $projectDir = '/projects/';

        $zipName = 'project.zip';
        $this->doDownload($projectDir, $zipName);
    }

    /**
     * Reads the projectdir and then returns a zip , which you download with the zipname
     * @param type $projectDir
     * @param type $zipName
     */
    private function doDownload($projectDir, $zipName) {
        $this->load->library('zip');
        $this->zip->read_dir($projectDir, FALSE);

        // Download the file to your desktop. Name it "after the name given"
        $this->zip->download($zipName);
    } 

Module

/**
     * Gets the project's path and returns it as a string
     * @param type $id
     * @return string
     */
    public function getProjectPath($id) {
        $record = $this->getDetails($id);

        foreach ($record->result() as $row) {

            $projectDir = '/projects/' . $row->location . '/' . $row->fase . '/' . $row->title . '/';
        }

        return $projectDir;
    }

    public function getProjectTitle($id) {
        $record = $this->getDetails($id);

        foreach ($record->result() as $row) {

            $projectTitle = $row->title;
        }

        return $projectTitle;
    } 

The download all projects works like a charm. The real problem comes when I zip a specific project. I get the files in the zip but the crc is 00000000 with every file. This is problem occurs when I run it on my ubuntu server but not on my local machine.

Any idea how I can fix this?

Install Cjax Framework

2013-05-22T15:08:15-05:00

Hello,

Im trying to install the Cjax Framework, but are unsuccessful to manage it. I have read both this http://cjax.sourceforge.net/docs/installing.php and this https://github.com/EllisLab/CodeIgniter/wiki/Ajax-Framework-For-CodeIgniter

Still unsuccessful to manage the installation. My dir/file structure looks like this:

/
/.htaccess

/application/
/application/ajax.php
/application/ajaxfw.php
/application/cache/
/application/cjax/
/application/config/
/application/controllers/
/application/controllers/AjaxController.php
/application/core/
/application/errors/
/application/helpers/
/application/hooks/
/application/language/
/application/libraries/
/application/logs/
/application/models/
/application/response/
/application/response/sample.php
/application/response/test.php
/application/views/
/application/test.php
/application/test2.php

/assets/
/assets/img,css,js -folders

/system/
/system/lots of more dirs

I have also enabled so I dont need to have index.php in my URL. Eg instead of http://example.com/index.php/registration I can access it through http://example.com/registration

.htaccess looks like this:

RewriteEngine on
RewriteCond $1 !^(index\.php|images|assets|robots\.txt)
RewriteRule ^(.*)$ /index.php/$1 [L] 

Hitting the following URLs:
http://mysite.com/ajax.php/test/test
http://mysite.com/ajax/test/test
http://mysite.com/ajax.php/test
http://mysite.com/ajax/test

I get the following message:

404 Page Not Found

The page you requested was not found.

What am I doing wrong and how do I fix the installation?

Proxy Library

2013-05-22T11:37:54-05:00

I’m having so much trouble with the proxy in my school center. I found this library, but I can’t download it https://github.com/EllisLab/CodeIgniter/wiki/Proxy-Library

What do you use when you need to config your proxies?

Thank you!

flexi cart - A comprehensive shopping cart library for CodeIgniter

2012-03-11T03:30:11-05:00

Hey all,

I would like to announce the release of ‘flexi cart’, a comprehensive shopping cart library for CodeIgniter.

Whilst CodeIgniter does indeed come with its own cart library, the library is quite basic in functionality and is only aimed at creating simple e-commerce stores.

The flexi cart library includes the following features:

Shipping
+ Base available shipping options and charges on a customers location.
+ Calculate shipping charges based on the weight and value of an order.
+ Include or exclude specific shipping options from discount offers.
+ Set shipping charges for specific items purchased from the store.
Example: Item A ships free of charge, Item B ships for $10 on top of the carts standard shipping charge.
+ Ban specific items from being shipped to specific locations.

Taxes
+ Base available tax rates on a customers ‘billing to’ or ‘shipping to’ location.
+ Define specific tax rates for specific items in the cart.
+ Customers can toggle whether to show cart prices include or excluding taxes.

Localisation
+ Setup locations like countries, states, cities, post/zip codes to even specific streets and door numbers.
+ Locations can be grouped into zones, where rules can then be applied to all locations within a zone, rather than setting the rule for each location.

Discounts and Reward Points/Vouchers
+ Setup complex rule conditions for specific items and groups of items that are added to the cart based on customer location, cart/item value, item quantities and whether other items are present within the cart.
+ Define how tax should be applied to specific discounts. E.g. Whether tax should be applied before or after the discount is applied.
+ Allow customers to earn reward points from purchasing items that they can then later exchange for a discount voucher.

Plus many more features…
+ Multiple currencies
+ Item stock control
+ Surcharges
+ Save/load incomplete carts for later shopping
+ Multilingual custom status and error messages
+ Currency and weight conversion tools

The purpose of the flexi cart library is to offer modularised shopping cart features, that allow a developer to pick and choose which features they require, without having to include features that are surplus to the clients requirements.

flexi cart is flexible enough to be used to create simple 10 item ecommerce stores, up to creating huge online stores rivaling the functionality of ecommerce giants like Magento, Opencart and X-cart. The tools are provided, you just have to put them together.

The library, documentation, and a comprehensive live online demo are available from the flexi cart site.
http://haseydesign.com/flexi-cart

The library has been a long time in the making and has been used for some of my own client sites.
I would now like to release the code to the public so that others can also make use of it.

Enjoy =)

P.s. If anyone does particularly like the style of this library, I have also built a user authentication system that was originally based on Ben Edmunds popular Ion Auth library.
The ‘flexi auth’ library is highly customisable like flexi cart including features like PHPASS password hashing, Google reCaptcha, user groups and privileges, plus much much more.

dB join issue

2013-05-20T13:27:22-05:00

I’m calling get_custom_user_data

$select= array('uacc_status');
   $where= array('uacc_id'=>$user_id);
   $row= $this->flexi_auth->get_custom_user_data($select, $where)->row(); 

and getting the following error

Unknown column ‘user_privileges.upriv_id’ in ‘field list’

SELECT `user_privileges`.`upriv_id`, `user_privileges`.`upriv_name`, `uacc_status` FROM (`user_accounts`) LEFT JOIN `user_groups` ON `user_accounts`.`uacc_group_fk` = `user_groups`.`ugrp_id` LEFT JOIN `user_profile` ON `user_accounts`.`uacc_id` = `user_profile`.`user_account_fk` WHERE `user_groups`.`ugrp_id` = ‘1’ AND `user_privilege_users`.`upriv_users_uacc_fk` = ‘1’ AND `uacc_id` = ‘1’

Any idea as to why this is occurring?

Tank Auth is_logged_in usage

2013-05-08T14:44:35-05:00

I am trying to verify (in the absence of documentation), my understanding of $this->tank_auth->is_logged_in()

As I understand it, this method verifies whether ‘somebody’ is logged in, but cannot verify who it is.

I want to know if a particular user is now logged in.

Thus my code at a certain point looks like this:

if ($this->tank_auth->is_logged_in() 
&&  $new_login_name == $this->tank_auth->get_username()) 

Do I need to bother with is_logged_in?
Is the second half of my && sufficient and safe?
Will a login always succeed, overriding a current login?

If there is doc I have failed to find, please point me to it. I support the concept of R-ing TFM when TFM exists