AI provjera postavki

AI analize

Baza

piaiweb_auti

AI tablice

Kljucni indeksi

Catalog tablice

B2B indeksi

B2B settings

Inquiry self-check

Provjera	Status
`ai_part_inquiries` tablica	postoji
`/api/ai-parts/inquiry/` endpoint file	postoji
`/api/ai-parts/inquiry.php` wrapper file	postoji
`/admin/ai_inquiries/index.php` admin modul	postoji
`/database/migrations/012_ai_b2b_product_search.sql` migracija	postoji
`/database/migrations/013_ai_b2b_vehicle_aliases.sql` migracija	postoji
`/database/migrations/014_ai_b2b_part_rules_min_seed.sql` migracija	postoji
`/database/migrations/015_ai_b2b_ds3_aliases_and_part_normalization.sql` migracija	postoji
`/database/migrations/016_ai_b2b_front_left_fender_rule_fix.sql` migracija	postoji
`/database/migrations/017_ai_b2b_audi_tt_aliases.sql` migracija	postoji

B2B search settings

Setting key	Status	Value
`b2b_product_search_enabled`	postoji	1
`b2b_product_search_mode`	postoji	inquiry_only
`b2b_product_search_limit_per_part`	postoji	8
`b2b_product_search_min_score`	postoji	45
`b2b_product_search_show_prices`	postoji	1
`b2b_product_search_show_stock`	postoji	1

Tablice

Tablica	Status	Redaka	Nedostajuci indeksi
`ai_vehicle_analyses`	postoji	15	OK
`ai_vehicle_analysis_images`	postoji	97	OK
`ai_vehicle_candidates`	postoji	21	OK
`ai_part_candidates`	postoji	71	OK
`ai_part_aliases`	postoji	0	OK
`ai_vehicle_aliases`	postoji	0	OK
`ai_analysis_corrections`	postoji	16	OK
`ai_search_logs`	postoji	0	OK
`ai_settings`	postoji	140	OK
`ai_raw_logs`	postoji	49	OK
`ai_part_inquiries`	postoji	8	OK
`ai_b2b_make_aliases`	postoji	18	OK
`ai_b2b_vehicle_aliases`	postoji	7	OK
`ai_b2b_part_search_rules`	postoji	16	OK
`ai_inquiry_b2b_product_matches`	postoji	5	OK

Ako nedostaje tablica ili indeks, pokrenite SQL migracije iz /database/migrations/ redom.

AutoScan product catalog tablice

Tablica	Status	Nedostajuci indeksi
`b2b_categories`	postoji	-
`b2b_manufacturers`	postoji	-
`b2b_models`	postoji	OK
`b2b_products`	postoji	OK
`vehicle_makes`	postoji	-
`vehicle_models`	postoji	-
`vehicle_generations`	postoji	-
`part_categories`	postoji	-
`products`	postoji	-
`product_images`	postoji	-
`product_oem_numbers`	postoji	-
`product_vehicle_compatibility`	postoji	-
`ai_inquiry_product_matches`	postoji	-

Status B2B indeksa: OK

TASK 02A-UX: provjera novih polja

Tablica	Polje	Status	Napomena
`ai_vehicle_analyses`	`language_code`	postoji	-
`ai_vehicle_analyses`	`manual_vehicle_json`	postoji	-
`ai_vehicle_analyses`	`vision_primary_model`	postoji	-
`ai_vehicle_analyses`	`vision_fallback_model`	postoji	-
`ai_vehicle_analyses`	`vision_final_model`	postoji	-
`ai_vehicle_analyses`	`vision_fallback_used`	postoji	-
`ai_vehicle_analyses`	`vision_fallback_reason`	postoji	-
`ai_vehicle_analyses`	`vision_primary_vehicle_confidence`	postoji	-
`ai_vehicle_analyses`	`vision_final_vehicle_confidence`	postoji	-
`ai_vehicle_analyses`	`vision_primary_part_candidates_count`	postoji	-
`ai_vehicle_analyses`	`vision_final_part_candidates_count`	postoji	-
`ai_vehicle_analyses`	`vision_primary_vehicle_candidates_count`	postoji	-
`ai_vehicle_analyses`	`vision_final_vehicle_candidates_count`	postoji	-
`ai_part_candidates`	`candidate_source`	postoji	-
`ai_part_candidates`	`visible_on_image`	postoji	enum sadrzi `damage_detail`
`ai_part_inquiries`	`id`	postoji	-
`ai_part_inquiries`	`analysis_id`	postoji	-
`ai_part_inquiries`	`public_token`	postoji	-
`ai_part_inquiries`	`customer_name`	postoji	-
`ai_part_inquiries`	`customer_phone`	postoji	-
`ai_part_inquiries`	`customer_email`	postoji	-
`ai_part_inquiries`	`customer_city`	postoji	-
`ai_part_inquiries`	`preferred_contact`	postoji	-
`ai_part_inquiries`	`customer_message`	postoji	-
`ai_part_inquiries`	`confirmed_vehicle_label`	postoji	-
`ai_part_inquiries`	`confirmed_make_id`	postoji	-
`ai_part_inquiries`	`confirmed_model_id`	postoji	-
`ai_part_inquiries`	`confirmed_generation_id`	postoji	-
`ai_part_inquiries`	`confirmed_year`	postoji	-
`ai_part_inquiries`	`selected_parts_json`	postoji	-
`ai_part_inquiries`	`final_filter_json`	postoji	-
`ai_part_inquiries`	`images_json`	postoji	-
`ai_part_inquiries`	`inquiry_payload_json`	postoji	-
`ai_part_inquiries`	`status`	postoji	-
`ai_part_inquiries`	`admin_note`	postoji	-
`ai_part_inquiries`	`ip_address`	postoji	-
`ai_part_inquiries`	`user_agent`	postoji	-
`ai_part_inquiries`	`created_at`	postoji	-
`ai_part_inquiries`	`updated_at`	postoji	-
`ai_b2b_make_aliases`	`id`	postoji	-
`ai_b2b_make_aliases`	`alias`	postoji	-
`ai_b2b_make_aliases`	`alias_normalized`	postoji	-
`ai_b2b_make_aliases`	`b2b_manufacturer`	postoji	-
`ai_b2b_make_aliases`	`priority`	postoji	-
`ai_b2b_make_aliases`	`is_active`	postoji	-
`ai_b2b_vehicle_aliases`	`id`	postoji	-
`ai_b2b_vehicle_aliases`	`ai_make`	postoji	-
`ai_b2b_vehicle_aliases`	`ai_make_normalized`	postoji	-
`ai_b2b_vehicle_aliases`	`ai_model`	postoji	-
`ai_b2b_vehicle_aliases`	`ai_model_normalized`	postoji	-
`ai_b2b_vehicle_aliases`	`ai_generation`	postoji	-
`ai_b2b_vehicle_aliases`	`ai_generation_normalized`	postoji	-
`ai_b2b_vehicle_aliases`	`year_from`	postoji	-
`ai_b2b_vehicle_aliases`	`year_to`	postoji	-
`ai_b2b_vehicle_aliases`	`b2b_manufacturer`	postoji	-
`ai_b2b_vehicle_aliases`	`b2b_title_contains`	postoji	-
`ai_b2b_vehicle_aliases`	`is_active`	postoji	-
`ai_b2b_part_search_rules`	`id`	postoji	-
`ai_b2b_part_search_rules`	`category_key`	postoji	-
`ai_b2b_part_search_rules`	`ai_part_name`	postoji	-
`ai_b2b_part_search_rules`	`side`	postoji	-
`ai_b2b_part_search_rules`	`position`	postoji	-
`ai_b2b_part_search_rules`	`required_groups_json`	postoji	-
`ai_b2b_part_search_rules`	`priority`	postoji	-
`ai_b2b_part_search_rules`	`is_active`	postoji	-
`ai_inquiry_b2b_product_matches`	`id`	postoji	-
`ai_inquiry_b2b_product_matches`	`inquiry_id`	postoji	-
`ai_inquiry_b2b_product_matches`	`analysis_id`	postoji	-
`ai_inquiry_b2b_product_matches`	`product_code`	postoji	-
`ai_inquiry_b2b_product_matches`	`match_level`	postoji	-
`ai_inquiry_b2b_product_matches`	`selected_by_user`	postoji	-
`ai_inquiry_b2b_product_matches`	`product_snapshot_json`	postoji	-
`ai_inquiry_b2b_product_matches`	`fitment_snapshot_json`	postoji	-

Status novih polja: OK