php - CodeIgniter Where_In select from different table? -

-

i trying covert query in active record 

select  crm_clients.id, crm_clients.`moved_date`, crm_clients.`contractor_id`  dev_pfands.`crm_clients`  crm_clients.`contractor_id` = 11  , ( crm_clients.`status` = 9  or crm_clients.`status` = 8  or crm_clients.`status` = 7 )  , crm_clients.id in  (select   crm_client_cheques.`client_id`  dev_pfands.`crm_client_cheques`)  , crm_clients.`moved_date` between '2014-08-01'  , '2014-11-29 '  , crm_clients.`contractor_id`<>'' group crm_clients.`id

the section i'm having issue 

and crm_clients.id in      (select       crm_client_cheques.client_id          dev_pfands.crm_client_cheques) `

i've tried where_in method overtime try include attempt of $this ->db_pfands -> where('crm_client_cheques.client id' ,'id'); hit errors , have no idea how past this.

the original query should return 703 rows , when i've removed part i'm stuck increase 3045 need included. appreciated.

first of have error in code.

$this->db_pfands->where('crm_client_cheques.client id', 'id');

this 

$this->db_pfands->where('crm_client_cheques.client_id', 'id');

you have provide right column name , far know database's column name have not contain space.

now think active record query result.

$query = $this->db->select('crm_clients.id, crm_clients.moved_date, crm_clients.contractor_id')                   ->where('moved_date between "2014-08-01" , "2014-11-29"')                   ->where('contractor_id', 'id')                   ->where_in('status', [9,8,7])                   ->from('crm_clients')                   ->join('crm_client_cheques', 'crm_client_cheques.client_id = crm_clients.id')                   ->group_by('id')                   ->get(); $result = $query->result();

may have change couple of names because in different database, believe can it.


Comments

Post a Comment

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

-
i using activeadmin , have file doing this: activeadmin.register role something--- end however, server gives me error: runtimeerror: circular dependency detected while autoloading constant role /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:461:in `load_missing_constant' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:184:in `const_missing' ~/desktop/boxfox/app/admin/role.rb:1:in `<top (required)>' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `load' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `block in load_file' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:616:in `new_constants_in' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:423:in `load_file' /library/ruby/gems/2.0.0/gems/activesuppor...
Read more

c++ - OpenMP unpredictable overhead -

-
i have simple openmp code runs 4 empty threads , reports time: #include "omp.h" #include <sys/time.h> #include <cstdio> double start_time; void process_thread() { } int main(){ struct timeval tv; gettimeofday(&tv, null); start_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("beginning time: %.3fms ",start_time-start_time); #pragma omp parallel schedule(static,1) for(int i=0;i<4;i++) process_thread(); gettimeofday(&tv, null); double cur_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("finishing time: %.3fms\n\n",cur_time-start_time); } without openmp running time small , consistent: beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.050ms beginnin...
Read more

django rest framework - DRF 3.0: UniqueTogetherValidator with a read-only field -

-
in process of upgrading django rest framework 3.0 2.4.4 , want have read-only user field, failing because 'user' being required uniquetogethervalidator (i think) i have model (excuse typos, simplified , code works fine irl): class examplemodel(models.model): some_attr = models.positivesmallintegerfield() other_attr = models.positivesmallintegerfield() user = models.foreignkey(user) class meta: unique_together = ('some_attr', 'other_attr', 'user') viewset: class exampleviewset(viewsets.modelviewset): queryset = examplemodel.objects.all() serializer_class = exampleserializer def perform_create(self, serializer): serializer.save(user=self.request.user) def perform_update(self, serializer): serializer.save(user=self.request.user) serializer: class exampleserializer(serializers.modelserializer): user = userserializer(read_only=true) class meta: model = examplemodel n...
Read more