Comments (2)
Idea
../Private/Bundles/Example/Model/Users.php
<?php
namespace Bundles\Example\Model;
class Users {
public static function banned() {
return(Polyfony\Database::query()
->select()
->from('Users')
->whereNotNull('banned')
);
}
}
?>
../Private/Bundles/Example/Controller/UsersController.php
$this->BannedUsers = \Bundles\Example\Model\Users::banned();
from polyfony.
From this
// list of intervention requiring estimates
$this->InterventionsToEstimate = $this->Core->Database->query()
->select()
->from('Sites')
->join('Requests','Requests.id','Interventions.id_request')
->join('Interventions','Interventions.id_site','Sites.id')
->whereTrue('estimate_required') // estimate is required
->whereNull('estimate_request_date') // estimates requests have not been sent
->execute();
// list of interventions for which estimates request have been sent but not received yet
$this->InterventionsToReceiveEstimate = $this->Core->Database->query()
->select()
->from('Sites')
->join('Requests','Requests.id','Interventions.id_request')
->join('Interventions','Interventions.id_site','Sites.id')
->whereTrue('estimate_required') // estimate is required
->whereNotNull('estimate_request_date') // estimates requests have not been sent
->whereNull('estimate_choice_date') // estimate is not chosen, could also be id_estimate IS NULL
->execute();
To this
$this->InterventionsToEstimate = \Bundles\Admin\Model\Interventions::toEstimate();
$this->InterventionsToReceiveEstimate = \Bundles\Admin\Model\Interventions::pendingEstimateReception();
from polyfony.
Related Issues (20)
- Use PHP8's multi-typing on Accounts's PermissionsAccessors
- Only show assigned Roles and directly assigned Permissions in the Debug Bar
- ->autoPopulate() only if a value hasn't been manually set
- Remove the ucfirst filter from AccountsPermissions Model
- Don't throw exception when ->save[ing] an objet without any modifications HOT 1
- Specify a `user-select:text` on the whole Profiler
- Support HAVING clauses
- Implement a Router::getBaseUrl() method
- Rename the "column does not exist" error
- Implement a notIn() method HOT 1
- Consider the modification date of assets when generating a cache signature
- Use 401 Status Code instead of 403 when and where appropriate
- The Throttling feature should return 429 Status Code instead of 403
- Leverage PHP 8.1's new "Never" return type HOT 1
- Fix PHP 8.1 Warnings and Deprecation issues
- Query->update() unable to use the same column name twice
- Emails->setRecipients() convert recipients addresses to lowercase automatically
- Expired accounts should not redirect to the login page
- Allow for expirable signed URLs
- Query->whereNull() is broken, due to empty PDO parameter injection
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from polyfony.