orocrm /
crm
| @@ 160-173 (lines=14) @@ | ||
| 157 | /** |
|
| 158 | * @return string |
|
| 159 | */ |
|
| 160 | protected function getFillContactRequestEmailActivityListQuery() |
|
| 161 | { |
|
| 162 | $sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' . |
|
| 163 | ' SELECT al.id, rel.contactrequest_id' . |
|
| 164 | ' FROM oro_activity_list al' . |
|
| 165 | ' JOIN %s rel ON rel.email_id = al.related_activity_id' . |
|
| 166 | ' AND al.related_activity_class = :class'; |
|
| 167 | ||
| 168 | return sprintf( |
|
| 169 | $sql, |
|
| 170 | $this->activityListExtension->getAssociationTableName('orocrm_contactus_request'), |
|
| 171 | $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_contactus_request') |
|
| 172 | ); |
|
| 173 | } |
|
| 174 | ||
| 175 | /** |
|
| 176 | * @return string |
|
| @@ 178-191 (lines=14) @@ | ||
| 175 | /** |
|
| 176 | * @return string |
|
| 177 | */ |
|
| 178 | protected function getFillContactRequestCallActivityListQuery() |
|
| 179 | { |
|
| 180 | $sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' . |
|
| 181 | ' SELECT al.id, rel.contactrequest_id' . |
|
| 182 | ' FROM oro_activity_list al' . |
|
| 183 | ' JOIN %s rel ON rel.call_id = al.related_activity_id' . |
|
| 184 | ' AND al.related_activity_class = :class'; |
|
| 185 | ||
| 186 | return sprintf( |
|
| 187 | $sql, |
|
| 188 | $this->activityListExtension->getAssociationTableName('orocrm_contactus_request'), |
|
| 189 | $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_contactus_request') |
|
| 190 | ); |
|
| 191 | } |
|
| 192 | } |
|
| 193 | ||
| @@ 209-222 (lines=14) @@ | ||
| 206 | /** |
|
| 207 | * @return string |
|
| 208 | */ |
|
| 209 | protected function getFillCartEmailActivityListQuery() |
|
| 210 | { |
|
| 211 | $sql = 'INSERT INTO %s (activitylist_id, cart_id)' . |
|
| 212 | ' SELECT al.id, rel.cart_id' . |
|
| 213 | ' FROM oro_activity_list al' . |
|
| 214 | ' JOIN %s rel ON rel.email_id = al.related_activity_id' . |
|
| 215 | ' AND al.related_activity_class = :class'; |
|
| 216 | ||
| 217 | return sprintf( |
|
| 218 | $sql, |
|
| 219 | $this->activityListExtension->getAssociationTableName('orocrm_magento_cart'), |
|
| 220 | $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_magento_cart') |
|
| 221 | ); |
|
| 222 | } |
|
| 223 | ||
| 224 | /** |
|
| 225 | * @return string |
|
| @@ 227-240 (lines=14) @@ | ||
| 224 | /** |
|
| 225 | * @return string |
|
| 226 | */ |
|
| 227 | protected function getFillCartCallActivityListQuery() |
|
| 228 | { |
|
| 229 | $sql = 'INSERT INTO %s (activitylist_id, cart_id)' . |
|
| 230 | ' SELECT al.id, rel.cart_id' . |
|
| 231 | ' FROM oro_activity_list al' . |
|
| 232 | ' JOIN %s rel ON rel.call_id = al.related_activity_id' . |
|
| 233 | ' AND al.related_activity_class = :class'; |
|
| 234 | ||
| 235 | return sprintf( |
|
| 236 | $sql, |
|
| 237 | $this->activityListExtension->getAssociationTableName('orocrm_magento_cart'), |
|
| 238 | $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_magento_cart') |
|
| 239 | ); |
|
| 240 | } |
|
| 241 | ||
| 242 | /** |
|
| 243 | * @return string |
|
| @@ 245-258 (lines=14) @@ | ||
| 242 | /** |
|
| 243 | * @return string |
|
| 244 | */ |
|
| 245 | protected function getFillOrderEmailActivityListQuery() |
|
| 246 | { |
|
| 247 | $sql = 'INSERT INTO %s (activitylist_id, order_id)' . |
|
| 248 | ' SELECT al.id, rel.order_id' . |
|
| 249 | ' FROM oro_activity_list al' . |
|
| 250 | ' JOIN %s rel ON rel.email_id = al.related_activity_id' . |
|
| 251 | ' AND al.related_activity_class = :class'; |
|
| 252 | ||
| 253 | return sprintf( |
|
| 254 | $sql, |
|
| 255 | $this->activityListExtension->getAssociationTableName('orocrm_magento_order'), |
|
| 256 | $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_magento_order') |
|
| 257 | ); |
|
| 258 | } |
|
| 259 | ||
| 260 | /** |
|
| 261 | * @return string |
|
| @@ 263-276 (lines=14) @@ | ||
| 260 | /** |
|
| 261 | * @return string |
|
| 262 | */ |
|
| 263 | protected function getFillOrderCallActivityListQuery() |
|
| 264 | { |
|
| 265 | $sql = 'INSERT INTO %s (activitylist_id, order_id)' . |
|
| 266 | ' SELECT al.id, rel.order_id' . |
|
| 267 | ' FROM oro_activity_list al' . |
|
| 268 | ' JOIN %s rel ON rel.call_id = al.related_activity_id' . |
|
| 269 | ' AND al.related_activity_class = :class'; |
|
| 270 | ||
| 271 | return sprintf( |
|
| 272 | $sql, |
|
| 273 | $this->activityListExtension->getAssociationTableName('orocrm_magento_order'), |
|
| 274 | $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_magento_order') |
|
| 275 | ); |
|
| 276 | } |
|
| 277 | } |
|
| 278 | ||
